v040_to_v041.sql

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

DECLARE @id int
EXEC dbo.QX_NEXT_KEY 'qx_script', 1, @id OUTPUT
insert into QX_SCRIPT(SCRIPT_ID, SCRIPT_NAME, SCRIPT_DESCRIPTION, SCRIPT_CLASS_NAME, CREATOR_ID, DATE_MODIFIED)
values(@id, 'Escalations', 'Sends escalations', 'com.queplix.qwoss.notification.EscalationAction', 0, getdate())
go

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