v008_to_v009.sql

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

alter table dbo.QW_PRODUCT
drop constraint fk_qw_product_workgroup
go

alter table dbo.QW_PRODUCT
drop constraint fk_qw_product_organization
go

alter table dbo.QW_PRODUCT
drop column qw_workgroupid
go

alter table dbo.QW_PRODUCT
drop column qw_manager
go

alter table dbo.QW_PRODUCT
drop column qw_managerphone
go

alter table dbo.QW_PRODUCT
drop column qw_organizationid
go

alter table dbo.QW_COMPONENT
drop constraint fk_qw_component_workgroup
go

alter table dbo.QW_COMPONENT
drop column qw_workgroupid
go

-- all new update scripts must include a line like this:
UPDATE QX_SYS_PROP SET PROP_VAL = '009' WHERE (PROP_ID = 'DB_APP_VERSION');