v034_to_v035.sql

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

insert into dbo.QX_LOCALIZATION_TYPE values (2, 'HTML contents');
insert into dbo.QX_LOCALIZED_OBJECT_TYPE values (10, 'Html element')

if exists (select * from dbo.sysobjects where id = object_id(N'[QX_HTML_ELEMENT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [QX_HTML_ELEMENT]
GO

create table dbo.QX_HTML_ELEMENT (
  FORM_ID              VARCHAR(255) NOT NULL,
  HTML_ELEMENT_ID            VARCHAR(255) NOT NULL,
  HTML_ELEMENT_ORDER         INT,
constraint PK_QX_HTML_ELEMENT primary key (FORM_ID, HTML_ELEMENT_ID)
)
go

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