v043_to_v044.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

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