代码搜索结果
找到约 10,000 项符合
V 的代码
v036_to_v037.sql
DELETE FROM QW_FIELDINFO
WHERE qw_tablename = 'qw_solution' AND qw_columnname = 'qw_solutionstatus'
GO
/* solution status */
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,q
v012_to_v013.sql
--------- Add extra fields to QW_TICKET ----------
ALTER TABLE [dbo].[QW_TICKET] ADD [qw_modifiedbyid] int NULL
GO
ALTER TABLE [dbo].[QW_TICKET] ADD CONSTRAINT [fk_qw_ticket_modifiedby] FOREIGN
v033_to_v034.sql
delete from dbo.QW_FIELDINFO
where qw_tablename='qw_solution' and qw_columnname='qw_topic'
go
INSERT INTO QW_FIELDINFO (qw_tablename,qw_columnname,qw_columntype,qw_enumvalue,qw_enumlabel) VALUES
v019_to_v020.sql
update qw_ticket set qw_customerid = -1000 where qw_customerid is null
go
-- all new update scripts must include a line like this:
UPDATE QX_SYS_PROP SET PROP_VAL = '020' WHERE (PROP_ID = 'DB_APP_V
v039_to_v040.sql
alter table QW_SOLUTION
add qw_solution varchar(2000) NOT NULL DEFAULT ' ',
qw_solutiontext text NULL,
qw_intcomments text NULL
GO
alter table QW_SOLUTION
alter column qw_problem var
v021_to_v022.sql
ALTER TABLE QX_USER_PROP
ALTER COLUMN PROP_VAL VARCHAR(2048)
GO
UPDATE QX_SYS_PROP SET PROP_VAL = '022' WHERE (PROP_ID = 'DB_CORE_VERSION');
v046_to_v047.sql
delete from QX_SYS_PROP where PROP_ID = 'INCOM_EMAIL_INTER_SOURCE'
go
delete from QX_SYS_PROP where PROP_ID = 'INCOM_EMAIL_INTER_DEFAULT_AGENT'
go
UPDATE QX_SYS_PROP SET PROP_VAL = '047' WHERE (
v027_to_v028.sql
alter table qx_form_settings
add myqueweb bit not null default 1
go
UPDATE QX_SYS_PROP SET PROP_VAL = '028' WHERE (PROP_ID = 'DB_CORE_VERSION');
GO
v042_to_v043.sql
create view qx_user_roles as
select distinct r.role_id, u.user_id
from qx_role r, qx_role_to_users u
where r.role_id = u.role_id
union all
select r.role_id, g.employeegroup
from qx_role r
v026_to_v027.sql
ALTER TABLE QX_USER_PROP
ALTER COLUMN PROP_ID VARCHAR(512) NOT NULL
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qx_user_permissions]') and OBJECTPROPERTY(id, N'IsView