v044_to_v045.sql

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

delete from QX_SYS_PROP where prop_id = 'INCOM_EMAIL_TICKET_BUILDVERSION'
go
DECLARE @id int
EXEC dbo.QX_NEXT_KEY 'QX_SYS_PROP', 1, @id OUTPUT
insert into QX_SYS_PROP (PKEY, PROP_ID, PROP_VAL, DESCRIPTION, NEED_RESTART)
values (@id, 'INCOM_EMAIL_TICKET_BUILDVERSION', '-1000', 'Email processing - default ticket buildversion', 1)
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_DEFAULT_DESC_TEXT', 'Empty email body', NULL, NULL, 0, 'Default Email text used in Email processing.')
EXEC dbo.QX_NEXT_KEY 'QX_SYS_PROP', 1, @id OUTPUT
insert into QX_SYS_PROP values (@id, 'INCOM_EMAIL_TICKET_RVERSION', '-1000', NULL, NULL, 0, 'Default Ticket Repbuild Version