代码搜索结果

set QUOTED_IDENTIFIER ON go create table dbo.TMP_QX_SYS_PROP ( PROP_ID VARCHAR(255), PROP_VAL VARCHAR(255), PROP_TEXT TEXT, PROP_DATA IMAGE, NEED_RESTART NUMERIC, DESCRIPTIO

alter table QX_VIEW_OBJECTS add grid bit not null default 1 go UPDATE QX_SYS_PROP SET PROP_VAL = '052' WHERE (PROP_ID = 'DB_CORE_VERSION'); go

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

alter table dbo.QX_ACCOUNT add LASTUID varchar(512) go alter table dbo.QX_ACCOUNT add LASTMESSAGE_DIGEST varchar(512) go UPDATE QX_SYS_PROP SET PROP_VAL = '067' WHERE (PROP_ID = 'DB_CORE_VERSION

create table dbo.QX_STATES ( pkey int not null, name varchar(255) not null, state_id varchar(2) not null, constraint PK_QX_ST

alter table QX_AUTO_REPLY add REPLY_EMAIL varchar(255) go update QX_AUTO_REPLY set REPLY_EMAIL = 'noreply@queplix.com' go alter table QX_AUTO_REPLY alter column REPLY_EMAIL varchar(255) not null

delete from QX_PERMISSION where permission_object_type = 4 go delete from QX_VIEW_OBJECTS where type = 4 go delete from QX_VIEW_OBJECT_TYPES where pkey=4 go UPDATE QX_SYS_PROP SET PROP_VAL

--drop old tables if exists (select * from dbo.sysobjects where id = object_id(N'QX_RIGHT') and OBJECTPROPERTY(id, N'IsView') = 1) drop view dbo.QX_RIGHT go if exists (select * from dbo.sysobjec

alter table dbo.QX_ACCOUNT add constraint FK_ACCOUNT_OWNER_QX_USERS foreign key (OWNER_ID) references QX_USERS (PKEY) go alter table dbo.QX_EMAIL_ROUTING_RULES add constraint FK_ROUTING_OWNER_QX_USE

create table dbo.QX_LINK ( FORM_ID VARCHAR(255) NOT NULL, FIELD_ID VARCHAR(255) NOT NULL, LINKED_FORM_ID VARCHAR(255) NOT NULL, constraint PK_QX_LINK primary k