代码搜索结果

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[QX_USERS]') AND OBJECTPROPERTY(id, N'IsView') = 1) DROP VIEW [dbo].[QX_USERS] GO IF EXISTS (SELECT * FROM dbo.sysobjects WH

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

create table dbo.QX_HISTORY ( qx_historyid int not null, qx_history text null, qx_object varchar(255) null, qx_objectid int null ) go UPDATE QX_SYS_PROP SET PROP_VAL = '011' WHERE (PR

DECLARE @id int EXEC dbo.QX_NEXT_KEY 'QX_SYS_PROP', 1, @id OUTPUT insert into QX_SYS_PROP values (@id, 'INCOM_EMAIL_DEFAULT_CUSTOMER_NAME', 'Email processing', NULL, NULL, 0, 'Default Customer name

delete from QX_SYS_PROP where PROP_ID = 'INCOM_EMAIL_DEFAULT_CUSTOMER_NAME' go delete from QX_SYS_PROP where PROP_ID = 'INCOM_EMAIL_DEFAULT_CUSTOMER_ID' go alter table dbo.QX_ACCOUNT add REPLY_E

drop view qx_user_roles go create view qx_user_roles as select distinct r.role_id, u.user_id, r.default_focus_id from qx_role r, qx_role_to_users u where r.role_id = u.role_

ALTER TABLE dbo.QX_BUTTON ADD PERMISSION INT NULL GO UPDATE QX_SYS_PROP SET PROP_VAL = '061' WHERE (PROP_ID = 'DB_CORE_VERSION'); go

create table QX_EMAIL_SERVICE_LOG ( PKEY int NOT NULL , MESSAGE_ID int NULL , MESSAGE_TYPE int NULL , E_TO varchar(255) NULL , E_FROM varchar(255) NULL , E_SUBJECT varchar(1022) NULL , M

ALTER TABLE dbo.QX_IMAGE DROP CONSTRAINT FK_QX_IMAGE_QX_USER_TYPE GO DROP INDEX dbo.QX_IMAGE.IDX_QX_IMAGE_CREATOR_TYPE GO DROP INDEX dbo.QX_IMAGE.IDX_QX_IMAGE_MODIFIER_TYPE GO ALTER TABLE db

--drop old tables set alter table dbo.QX_ROLE drop constraint FK_QX_ROLE_TO_FOCUS; drop view dbo.qx_permission_objects drop table dbo.qx_focus; drop table dbo.qx_subfocus; drop table dbo.qx_tab;