v008_to_v009.sql
来自「CRM源码This file describes some issues tha」· SQL 代码 · 共 36 行
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');
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?