代码搜索结果

CREATE TABLE dbo.QW_CATEGORY ( [qw_categoryid] [int] NOT NULL, [qw_name] [varchar] (255) NOT NULL , [qw_description] [varchar] (2000) NULL , CONSTRAINT [pk_qw_category] PRIMARY KEY

update QX_ERROR_CFG set MESSAGE_HND_CLASS = 'com.queplix.core.modules.services.utils.log.impl.DefMailMsgHnd' where ERROR_CFG_ID = 100 go -- all new update scripts must include a line like this:

--------- Add extra fields to QW_TICKET ---------- ALTER TABLE [dbo].[QW_TICKET] ADD [qw_categcallid] int NULL ALTER TABLE [dbo].[QW_TICKET] ADD [qw_subcatcallid] int NULL ALTER TABLE [dbo].[QW

--------- Add history field to QW_EMPLOYEE ---------- ALTER TABLE [dbo].[QW_EMPLOYEE] ADD [qw_history] int NULL GO -- all new update scripts must include a line like this: UPDATE QX_SYS_PROP

CREATE VIEW dbo.QW_DD_SOLUTIONTOPIC_VW AS SELECT qw_enumvalue AS pkey, qw_enumlabel AS value FROM QW_FIELDINFO WHERE (qw_tablename = 'qw_solution') AND (qw_columnname = 'qw_topic') go C

delete from QX_SYS_PROP where prop_id = 'INCOM_EMAIL_TICKET_BUILDVERSION' go DECLARE @id int EXEC dbo.QX_NEXT_KEY 'QX_SYS_PROP', 1, @id OUTPUT insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DES

delete from QX_SYS_PROP where PROP_ID = 'INCOM_EMAIL_INTER_DEFAULT_DESC_TEXT' go -- all new update scripts must include a line like this: UPDATE QX_SYS_PROP SET PROP_VAL = '048' WHERE (PROP_ID =

CREATE TABLE dbo.QW_CUSTOMER ( [qw_customerid] [int] NOT NULL, [qw_orgid] [int] NULL, [qw_firstname] [varchar] (100) NULL , [qw_lastname] [varchar] (100) NULL , [qw_fullname] [varchar] (255)

alter table dbo.QW_ORGANIZATION add qw_cocode [varchar] (255) NULL go CREATE VIEW dbo.QW_DD_EMPLOYEEREACHBY_VW AS SELECT qw_enumvalue AS pkey, qw_enumlabel AS value FROM QW_FIELDINFO JOIN QW_F

CREATE TABLE dbo.QW_EMPLOYEE ( [qw_employeeid] [int] NOT NULL , [qw_userid] [int] NULL , [qw_employeenum] [varchar] (100) NULL , [qw_orgid] [int] NULL , [qw_managerid] [int] NULL , [qw_fir