v053_to_v054.sql

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

update QX_SYS_PROP set PROP_VAL = '0' where PROP_ID = 'IN_EMAIL_TICKET_STATUS'
update QX_SYS_PROP set PROP_VAL = '0' where PROP_ID = 'IN_EMAIL_TICKET_TYPE'
delete from QX_SYS_PROP where PROP_ID = 'IN_EMAIL_TICKET_BUILDVERSION'
go

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