代码搜索结果

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, 'Escalati

CREATE TABLE dbo.QW_WORKFLOW ( qw_workflowid int NOT NULL, qw_objecttype int NOT NULL, qw_statusfrom int NULL, qw_statusto int NULL, qw_roleid int NULL, C

ALTER TABLE [dbo].[QW_TICKET] ADD [qw_employeeid] int NULL GO ALTER TABLE [dbo].[QW_TICKET] ADD CONSTRAINT [fk_qw_ticket_employee] FOREIGN KEY([qw_employeeid]) REFERENCES [dbo].[QW_EMPLOYEE] ([qw_

ALTER TABLE dbo.QW_SOLUTION DROP CONSTRAINT FK_QW_SOLUTION_MODIFIEDBY GO ALTER TABLE dbo.QW_SOLUTION ADD CONSTRAINT FK_QW_SOLUTION_MODIFIEDBY FOREIGN KEY (qw_modifiedby) REFERENCES QX_USERS (PKEY

update QW_FIELDINFO set qw_enumlabel='Agent' WHERE (qw_tablename = 'qw_ticketnotification_recipient') AND (qw_columnname = 'qw_recipient') AND qw_enumvalue = 2 update QW_FIELDINFO set qw_enumlabel=

DROP TABLE QW_ENVIRONMENT GO CREATE TABLE dbo.QW_ENVIRONMENT ( [qw_envid] [int] NOT NULL, [qw_envconfname] [varchar] (100) NULL, [qw_productid] [int] NOT NULL, [qw_orgid] [

CREATE TABLE dbo.QW_ENVIRONMENT ( [qw_envid] [int] NOT NULL, [qw_envlabel] [varchar] (100) NULL, [qw_testedby] [varchar] (100) NULL, [qw_os] [varchar] (50) NULL, [qw_osve

insert into QX_SYS_PROP (PROP_ID, PROP_VAL, DESCRIPTION) values ('DB_APP_VERSION', '002', 'Application database version. Do not modify'); -- all new update scripts must include a line like this: UPDAT

delete from QX_SYS_PROP where PROP_ID in ('INCOM_EMAIL_TICKET_STATUS', 'INCOM_EMAIL_TICKET_PRIORITY', 'INCOM_EMAIL_TICKET_TYPE', 'INCOM_EMAIL_TICKET_SOURCE', 'INCOM_EMAIL_TICKET_IMPACT', 'INCOM_EMAIL

CREATE TABLE dbo.QW_HARDWARE ( qw_hardwareid int NOT NULL, qw_name varchar(255) NOT NULL , qw_description varchar(2000) NULL , CONSTRAINT pk_qw_hardware PRIMARY KEY (qw_ha