v044_to_v045.sql

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

ALTER TABLE dbo.QX_ATTACHMENT DROP CONSTRAINT FK_QX_ATTACHMENT_QX_USER_TYPE
GO

DROP INDEX dbo.QX_ATTACHMENT.IDX_QX_ATTACHMENT_USER_TYPE
GO

alter table dbo.QX_ATTACHMENT
DROP COLUMN USER_TYPE_ID
GO

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