v056_to_v057.sql

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

alter table dbo.QX_ACCOUNT add constraint FK_ACCOUNT_OWNER_QX_USERS foreign key (OWNER_ID) references QX_USERS (PKEY)
go
alter table dbo.QX_EMAIL_ROUTING_RULES add constraint FK_ROUTING_OWNER_QX_USERS foreign key (OWNER_ID) references QX_USERS (PKEY)
go

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