v041_to_v042.sql

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

create view dbo.QX_DD_OBJECT_TYPE as
    select
        ENUM_VALUE as PKEY,
        ENUM_LABEL as NAME
    from QX_FIELDINFO
    where (TABLE_NAME = 'qx_inbox') and (COLUMN_NAME = 'object_type')
go

insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 0, 'Interaction')
go
insert into QX_FIELDINFO values ('qx_inbox', 'object_type', 14, 1, 'Case')
go

DECLARE @id int
EXEC dbo.QX_NEXT_KEY 'qx_sys_prop', 1, @id OUTPUT
insert into QX_SYS_PROP values (@id, 'INCOM_EMAIL_INTER_SOURCE', '3', NULL, NULL, 0, 'Interaction email filter source field')
EXEC dbo.QX_NEXT_KEY 'qx_sys_prop', 1, @id OUTPUT
insert into QX_SYS_PROP values (@id, 'INCOM_EMAIL_INTER_DEFAULT_AGENT', '-1000', NULL, NULL, 0, 'Default Email agent