v062_to_v063.sql

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

alter table QX_AUTO_REPLY add REPLY_EMAIL varchar(255)
go
update QX_AUTO_REPLY set REPLY_EMAIL = '[e-mail]'
go
alter table QX_AUTO_REPLY alter column REPLY_EMAIL varchar(255) not null
go

update QX_ACCOUNT set REPLY_EMAIL = '[e-mail]' where REPLY_EMAIL is null
go
alter table QX_ACCOUNT alter column REPLY_EMAIL varchar(255) not null
go

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