v009_to_v010.sql

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

delete from QX_CAP_TYPE where CAP_TYPE_ID=9
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QX_BUTTON]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[QX_BUTTON]
GO

insert into QX_CAP_TYPE values (9, 'Form Button')
GO

create table dbo.QX_BUTTON (
  FORM_ID              VARCHAR(255) NOT NULL,
  BUTTON_ID            VARCHAR(255) NOT NULL,
  BUTTON_ORDER         INT,
constraint PK_QX_BUTTON primary key (FORM_ID, BUTTON_ID)
)
GO

alter table QX_FORM add USE_DEFAULT_ACTIONS BIT DEFAULT 1
go

update QX_FORM set USE_DEFAULT_ACTIONS = 1
go

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