代码搜索结果

-- QW_TICKETESCALATION CREATE TABLE dbo.QW_TICKETESCALATION ( QW_ESCALATIONID INT NOT NULL, QW_PRODUCTID INT, QW_PRODUCTFILTER VARCHAR(255), QW_ORGANIZATIONID INT,

BEGIN TRANSACTION GO EXECUTE sp_rename N'dbo.QW_TICKET.qw_agentcallid', N'Tmp_qw_agentid_1', 'COLUMN' GO EXECUTE sp_rename N'dbo.QW_TICKET.Tmp_qw_agentid_1', N'qw_agentid', 'COLUMN' GO COMMIT

BEGIN TRANSACTION GO EXECUTE sp_rename N'dbo.QW_TICKET.qw_datepending', N'Tmp_qw_datedelivered_1', 'COLUMN' GO EXECUTE sp_rename N'dbo.QW_TICKET.Tmp_qw_datedelivered_1', N'qw_datedelivered', 'C

CREATE TABLE dbo.QW_ORGANIZATION ( [qw_orgid] [int] NOT NULL , [qw_parentid] [int] NULL , [qw_regionid] [int] NULL , [qw_name] [varchar] (255) NOT NULL , [qw_description] [varchar] (255) NUL

CREATE TABLE dbo.QW_ADDRESS ( [qw_addressid] [int] NOT NULL , [qw_addresstype] [int] NOT NULL , [qw_objectid] [int] NOT NULL , [qw_objecttype] [int] NOT NULL , [qw_address1] [varchar] (255)

-------- DEF VALUES ---------- insert into QX_USERS (pkey,loginname,fullname,user_type) values (-1000,'defemp','DEFAULT_EMPLOYEE',1) insert into QW_EMPLOYEE (qw_employeeid,qw_userid,qw_firstname,qw_

update QX_SYS_PROP set PROP_VAL = '0' where PROP_ID = 'IN_EMAIL_TICKET_STATUS' update QX_SYS_PROP set PROP_VAL = '0' where PROP_ID = 'IN_EMAIL_TICKET_TYPE' delete from QX_SYS_PROP where PROP_ID = 'I

CREATE TABLE #TMP_TNR_TABLE( QW_RECIPIENT INT, QW_NOTIFICATIONID INT ) GO INSERT INTO #TMP_TNR_TABLE SELECT * FROM QW_TICKETNOTIFICATION_RECIPIENT GO

update qw_ticket set qw_agentid = 0, qw_ownerid = 0 go ALTER TABLE [dbo].[QW_TICKET] DROP CONSTRAINT [fk_qw_ticket_agent] GO ALTER TABLE [dbo].[QW_TICKET] ADD CONSTRAINT [fk_qw_ticket_agent] FOREI

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, 'Send rep