v049_to_v050.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

delete from QX_SYS_PROP where PROP_ID in ('INCOM_EMAIL_TICKET_STATUS', 'INCOM_EMAIL_TICKET_PRIORITY', 'INCOM_EMAIL_TICKET_TYPE',
'INCOM_EMAIL_TICKET_SOURCE', 'INCOM_EMAIL_TICKET_IMPACT', 'INCOM_EMAIL_TICKET_OWNER', 'INCOM_EMAIL_TICKET_BUILDVERSION', 'INCOM_EMAIL_INTER_SOURCE',
'INCOM_EMAIL_INTER_DEFAULT_AGENT', 'INCOM_EMAIL_TICKET_RVERSION', 'INCOM_EMAIL_TICKET_AGENT', 'INCOM_EMAIL_TICKET_PRODUCT',
'INCOM_EMAIL_DEFAULT_CUSTOMER_NAME', 'INCOM_EMAIL_DEFAULT_CUSTOMER_ID')
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, 'IN_EMAIL_TICKET_STATUS', '1', 'Email processing - default ticket status', 1)
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, 'IN_EMAIL_TICKET_PRIORITY', '1', 'Email processing - default ticket priority', 1)
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, 'IN_EMAIL_TICKET_TYPE', '1', 'Email processing - default ticket type', 1)
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, 'IN_EMAIL_TICKET_SOURCE', '1', 'Email processing - default ticket source', 1)
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, 'IN_EMAIL_TICKET_IMPACT', '1', 'Email processing - default ticket impact', 1)
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, 'IN_EMAIL_TICKET_OWNER', '1', 'Email processing - default ticket owner', 1)
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, 'IN_EMAIL_TICKET_BUILDVERSION', '-1000', 'Email processing - default ticket buildversion', 1)
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, 'IN_EMAIL_INTER_SOURCE', '3', 'Interaction email filter source field', 1)
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, 'IN_EMAIL_INTER_DEFAULT_AGENT', '-1000', 'Default Email agent