v041_to_v042.sql

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

UPDATE QW_FIELDINFO SET qw_enumlabel = 'Escalation Workgroup' WHERE qw_tablename='qw_ticketescalation_recipient' AND qw_columnname='qw_recipient' AND qw_enumvalue=0
UPDATE QW_FIELDINFO SET qw_enumlabel = 'Escalation Employee' WHERE qw_tablename='qw_ticketescalation_recipient' AND qw_columnname='qw_recipient' AND qw_enumvalue=1
UPDATE QW_FIELDINFO SET qw_enumlabel = 'Escalation Email' WHERE qw_tablename='qw_ticketescalation_recipient' AND qw_columnname='qw_recipient' AND qw_enumvalue=2
go

ALTER TABLE QW_TICKETESCALATION ADD QW_SENDMODE NUMERIC(2,0) NULL
GO

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