代码搜索结果

truncate table qx_search alter table qx_search drop column body alter table qx_search add body text NULL UPDATE QX_SYS_PROP SET PROP_VAL = '064' WHERE (PROP_ID = 'DB_CORE_VERSION'); go

create table dbo.QX_MAIL_PROVIDER ( PKEY int not null, PROVIDER_ID varchar(50), PROVIDER_NAME varchar(50), constraint PK_QX_MAIL_PROVIDER primary key (PKEY), ) go DECLARE @i

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

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

create table dbo.QX_ATTACHMENT_OBJECTS ( PKEY INT NOT NULL, ATTACHMENT_ID INT, OBJECT_ID INT, OBJECT_TYPE INT, constraint PK_QX_ATTACHMENT_OBJECTS primary key (

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.QX_DD_USER_PROP') AND OBJECTPROPERTY(id, N'IsView') = 1) DROP VIEW dbo.QX_DD_USER_PROP go UPDATE QX_SYS_PROP SET PROP_VAL = '03

update QX_MAIL_PROVIDER set PROVIDER_ID = 'POP3', PROVIDER_NAME = 'pop3' where PROVIDER_ID = 'pop3' update QX_MAIL_PROVIDER set PROVIDER_ID = 'IMAP', PROVIDER_NAME = 'imap' where PROVIDER_ID = 'imap'

alter table QX_EXTERNALFIELD add SOURCEFIELD VARCHAR(255) NULL go UPDATE QX_SYS_PROP SET PROP_VAL = '058' WHERE (PROP_ID = 'DB_CORE_VERSION'); go

create unique index IDX_USERS_LOGINNAME on dbo.QX_USERS (LOGINNAME) go delete from QX_TIMEZONE go insert into QX_TIMEZONE values (1,'Brazil/Acre','(GMT-05:00) Acre Time',-300) insert into QX_

DECLARE @id int EXEC dbo.QX_NEXT_KEY 'qx_script', 1, @id OUTPUT insert into QX_SCRIPT(SCRIPT_ID, SCRIPT_NAME, SCRIPT_DESCRIPTION, SCRIPT_CLASS_NAME, CREATOR_ID, DATE_MODIFIED) values(@id, 'Inbox',