v043_to_v044.sql

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

ALTER TABLE dbo.QX_IMAGE DROP CONSTRAINT FK_QX_IMAGE_QX_USER_TYPE
GO

DROP INDEX dbo.QX_IMAGE.IDX_QX_IMAGE_CREATOR_TYPE
GO
DROP INDEX dbo.QX_IMAGE.IDX_QX_IMAGE_MODIFIER_TYPE
GO

ALTER TABLE dbo.QX_IMAGE
  DROP COLUMN CREATOR_TYPE_ID, MODIFIER_TYPE_ID
GO

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