v056_to_v057.sql

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

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