v045_to_v046.sql

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

ALTER TABLE dbo.QW_SOLUTION DROP CONSTRAINT FK_QW_SOLUTION_MODIFIEDBY
GO

ALTER TABLE dbo.QW_SOLUTION
ADD CONSTRAINT FK_QW_SOLUTION_MODIFIEDBY FOREIGN KEY (qw_modifiedby) REFERENCES QX_USERS (PKEY)
GO

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