contact0310.sql

本人为公司开发的Flex办公系统web源码,包括数据库脚本文件。

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Contact')
	DROP DATABASE [Contact]
GO

CREATE DATABASE [Contact]  ON (NAME = N'Contact_Data', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL\data\Contact_Data.MDF' , SIZE = 24, FILEGROWTH = 10%) LOG ON (NAME = N'Contact_Log', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL\data\Contact_Log.LDF' , SIZE = 99, FILEGROWTH = 10%)
 COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'Contact', N'autoclose', N'false'
GO

exec sp_dboption N'Contact', N'bulkcopy', N'false'
GO

exec sp_dboption N'Contact', N'trunc. log', N'false'
GO

exec sp_dboption N'Contact', N'torn page detection', N'true'
GO

exec sp_dboption N'Contact', N'read only', N'false'
GO

exec sp_dboption N'Contact', N'dbo use', N'false'
GO

exec sp_dboption N'Contact', N'single', N'false'
GO

exec sp_dboption N'Contact', N'autoshrink', N'false'
GO

exec sp_dboption N'Contact', N'ANSI null default', N'false'
GO

exec sp_dboption N'Contact', N'recursive triggers', N'false'
GO

exec sp_dboption N'Contact', N'ANSI nulls', N'false'
GO

exec sp_dboption N'Contact', N'concat null yields null', N'false'
GO

exec sp_dboption N'Contact', N'cursor close on commit', N'false'
GO

exec sp_dboption N'Contact', N'default to local cursor', N'false'
GO

exec sp_dboption N'Contact', N'quoted identifier', N'false'
GO

exec sp_dboption N'Contact', N'ANSI warnings', N'false'
GO

exec sp_dboption N'Contact', N'auto create statistics', N'true'
GO

exec sp_dboption N'Contact', N'auto update statistics', N'true'
GO

if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) )
	exec sp_dboption N'Contact', N'db chaining', N'false'
GO

use [Contact]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Docus_s1_Docus]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Docus_s1] DROP CONSTRAINT FK_Docus_s1_Docus
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Docus_s2_users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[Docus_s2] DROP CONSTRAINT FK_Docus_s2_users
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[datetostr]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[datetostr]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getPRRows]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[getPRRows]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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