v039_to_v040.sql

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

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, 'SESSION_TIMEOUT', '720', 'User logon session timeout (in minutes)', 0)
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, 'SESSION_TIMEOUT_WARN_BEFORE', '3', 'If the value is positive integer, a warning will be displayed the specified number of minutes before user logon session times out', 0)
go

UPDATE QX_SYS_PROP SET PROP_VAL = '040' WHERE (PROP_ID = 'DB_CORE_VERSION');
go