代码搜索结果

UPDATE QX_USERS SET USER_TYPE = 0, PASSWORD= '' GO UPDATE QX_LOCK SET USER_TYPE_ID = 0 GO UPDATE QX_USER_PROP SET USER_TYPE_ID = 0 GO UPDATE QX_USER_LOG SET USER_TYPE_ID = 0 GO UPDATE

UPDATE QW_FIELDINFO SET qw_enumlabel = 'Escalation Workgroup' WHERE qw_tablename='qw_ticketescalation_recipient' AND qw_columnname='qw_recipient' AND qw_enumvalue=0 UPDATE QW_FIELDINFO SET qw_enumlab

insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 3, 'Solution') insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 4, 'Message') GO -- all new update scripts must incl

DECLARE @id int EXEC dbo.QX_NEXT_KEY 'QX_SYS_PROP', 1, @id OUTPUT insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART) values (@id, 'INCOM_EMAIL_TICKET_STATUS', '1', 'Email

alter table QW_SOLUTION ADD qw_productid int NULL alter table QW_SOLUTION ADD qw_componentid int NULL go -- all new update scripts must include a line like this: UPDATE QX_SYS_PROP SET PROP_

BEGIN TRANSACTION CREATE TABLE dbo.TMP_QW_FIELDINFO( qw_tablename varchar(128) NOT NULL, qw_columnname varchar(255) NOT NULL, qw_columntype int NOT NULL, qw_en

DECLARE @id int EXEC dbo.QX_NEXT_KEY 'qx_script', 1, @id OUTPUT insert into QX_SCRIPT(SCRIPT_ID, SCRIPT_NAME, SCRIPT_DESCRIPTION, SCRIPT_CLASS_NAME, CREATOR_ID, DATE_MODIFIED) values(@id, 'Solution

alter table dbo.QW_TICKETEVENT drop constraint fk_qw_ticketevent_ticket -- all new update scripts must include a line like this: UPDATE QX_SYS_PROP SET PROP_VAL = '021' WHERE (PROP_ID = 'DB_APP_V

-- QW_ESCALATION_EVENT CREATE TABLE dbo.QW_ESCALATION_EVENT ( QW_ESCEVENTID INT NOT NULL, QW_ESCALATIONID INT NOT NULL, QW_TICKETID INT NOT NULL, QW_NEXT_CHECK

CREATE TABLE dbo.QW_TICKET ( [qw_ticketid] [int] NOT NULL , [qw_status] [int] NOT NULL , [qw_priority] [int] NOT NULL , [qw_type] [int] NOT NULL , [qw_source] [int] NOT NULL ,