v040_to_v041.sql

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

create table dbo.QX_ATTACHMENT_OBJECTS (
  PKEY             INT NOT NULL,
  ATTACHMENT_ID    INT,
  OBJECT_ID        INT,
  OBJECT_TYPE      INT,
constraint PK_QX_ATTACHMENT_OBJECTS primary key (PKEY),
constraint FK_QX_ATTACHMENT_OBJECTS_QX_ATTACHMENT foreign key (ATTACHMENT_ID) references QX_ATTACHMENT (ATTACHMENT_ID)
)
go

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