代码搜索结果

create table dbo.QX_HELPLINK ( TAB_ID varchar(255), LINK varchar(255), constraint PK_QX_HELPLINK primary key (TAB_ID) ) go UPDATE QX_SYS_PROP SET PROP_VAL = '068' WHERE (PROP_ID = 'DB_CO

-- remove captions tables if exists (select * from dbo.sysobjects where id = object_id(N'[QX_CAPTION]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [QX_CAPTION] GO if exists (select * f

create table dbo.QX_HIDDENCONTROL ( FORM_ID VARCHAR(255) NOT NULL, FIELD_ID VARCHAR(255) NOT NULL, constraint PK_QX_HIDDENCONTROL primary key (FORM_ID, FIELD_ID) ) GO

ALTER TABLE QX_HISTORY ADD qx_datemodified DATETIME NULL GO DELETE FROM QX_HIS_TBLFIELD GO UPDATE QX_SYS_PROP SET PROP_VAL = '014' WHERE (PROP_ID = 'DB_CORE_VERSION');

create table dbo.QX_INBOX ( PKEY int not null, MESSAGE_TYPE int not null default 0, -- 0 is email message, 1 - alert MESSAGE_SENDER int null, MESSAGE_SENDER_EMAIL varchar(1024),

create table dbo.QX_AUTO_REPLY ( PKEY int not null, NAME varchar(255) not null, DESCRIPTION varchar(255) null, SUCCESSFUL_SUBJECT varchar(255) not null, SUCCESSFUL_BODY text n

ALTER TABLE dbo.QX_ATTACHMENT DROP CONSTRAINT FK_QX_ATTACHMENT_QX_USER_TYPE GO DROP INDEX dbo.QX_ATTACHMENT.IDX_QX_ATTACHMENT_USER_TYPE GO alter table dbo.QX_ATTACHMENT DROP COLUMN USER_TYPE_

delete from QX_SEARCH go UPDATE QX_SYS_PROP SET PROP_VAL = '048' WHERE (PROP_ID = 'DB_CORE_VERSION'); go

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

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