v028_to_v029.sql

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

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='Ticket Customer' WHERE (qw_tablename = 'qw_ticketnotification_recipient') AND (qw_columnname = 'qw_recipient') AND qw_enumvalue = 4
delete from QW_FIELDINFO WHERE (qw_tablename = 'qw_ticketnotification_recipient') AND (qw_columnname = 'qw_recipient') AND qw_enumvalue = 5
GO

UPDATE QX_SYS_PROP SET PROP_VAL = '029' WHERE (PROP_ID = 'DB_APP_VERSION');