v011_to_v012.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

--------- 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');