v042_to_v043.sql

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

delete from QX_FIELDINFO where table_name = 'qx_inbox' and column_name = 'object_type'
go

insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 1, 'Interaction')
go
insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 2, 'Ticket')
go


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