v011_to_v012.sql

来自「CRM源码This file describes some issues tha」· SQL 代码 · 共 13 行

--------- 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_TICKET] ADD [qw_probtypecallid] int NULL 
ALTER TABLE [dbo].[QW_TICKET] ADD [qw_reasoncallid] int NULL 
ALTER TABLE [dbo].[QW_TICKET] ADD [qw_repenvcallid] int NULL 
ALTER TABLE [dbo].[QW_TICKET] ADD [qw_testenvcallid] int NULL 
GO

-- all new update scripts must include a line like this:
UPDATE QX_SYS_PROP SET PROP_VAL = '012' WHERE (PROP_ID = 'DB_APP_VERSION');