sqlsetup.sql

基于ASP的OA办公系统有BBS

IF EXISTS(Select * From sysobjects where name = 'db_Administer' )
	DROP TABLE db_Administer
GO
CREATE TABLE [db_Administer] (
	[aID] [Tinyint] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [varchar] (30) NOT NULL ,
	[aModule] [varchar] (50) NOT NULL ,
	[aEditType] [text] NULL ,
	[aAddType] [text] NULL ,
	[aDelType] [text] NULL ,
	[aViewType] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Archives' )
	DROP TABLE db_Archives
GO	
CREATE TABLE [db_Archives] (
	[Ass_ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[Ass_str0] [int] NULL ,
	[Ass_str1] [varchar] (50) NULL ,
	[Ass_str2] [varchar] (50) NULL ,
	[Ass_str3] [varchar] (50) NULL ,
	[Ass_str4] [varchar] (50) NULL ,
	[Ass_str5] [varchar] (50) NULL ,
	[Ass_str6] [varchar] (50) NULL ,
	[Ass_str7] [varchar] (50) NULL ,
	[Ass_str8] [varchar] (50) NULL ,
	[Ass_str9] [varchar] (50) NULL ,
	[Ass_str10] [varchar] (50) NULL ,
	[Ass_str11] [varchar] (50) NULL ,
	[Ass_str12] [varchar] (50) NULL ,
	[Ass_str13] [varchar] (50) NULL ,
	[Ass_str14] [varchar] (50) NULL ,
	[Ass_str15] [varchar] (50) NULL ,
	[Ass_str16] [varchar] (50) NULL ,
	[Ass_str17] [varchar] (50) NULL ,
	[Ass_str18] [varchar] (50) NULL ,
	[Ass_str19] [varchar] (50) NULL ,
	[Ass_str20] [varchar] (50) NULL ,
	[Ass_str21] [varchar] (50) NULL ,
	[Ass_str22] [varchar] (50) NULL ,
	[Ass_str23] [varchar] (50) NULL ,
	[Ass_str24] [varchar] (50) NULL ,
	[Ass_str25] [varchar] (50) NULL ,
	[Ass_str26] [varchar] (50) NULL ,
	[Ass_str27] [varchar] (50) NULL ,
	[Ass_str28] [varchar] (50) NULL ,
	[Ass_str29] [varchar] (50) NULL ,
	[Ass_str30] [varchar] (50) NULL ,
	[Ass_str31] [varchar] (50) NULL ,
	[Ass_str32] [varchar] (50) NULL ,
	[Ass_str33] [varchar] (50) NULL ,
	[Ass_str34] [varchar] (50) NULL ,
	[Ass_str35] [varchar] (50) NULL ,
	[Ass_str36] [text] NULL ,
	[Ass_str37] [text] NULL ,
	[Ass_str38] [text] NULL ,
	[Ass_str39] [text] NULL ,
	[Ass_str40] [text] NULL ,
	[Ass_str41] [text] NULL ,
	[Ass_date] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Arrangement' )
	DROP TABLE db_Arrangement
GO		
CREATE TABLE [db_Arrangement] (
	[aID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[aTitle] [varchar] (200) NOT NULL ,
	[aContent] [text] NULL ,
	[aDate] [datetime] NULL ,
	[aTime] [datetime] NULL ,
	[aComment] [text] NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Asset' )
	DROP TABLE db_Asset
GO		
CREATE TABLE [db_Asset] (
	[ID] [smallint] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [varchar] (50) NULL ,
	[aID] [smallint] NOT NULL ,
	[uID] [int] NOT NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_AssetGroup' )
	DROP TABLE db_AssetGroup
GO		
CREATE TABLE [db_AssetGroup] (
	[aID] [smallint] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [varchar] (50) NOT NULL ,
	[uID] [int] NOT NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Associate_Group' )
	DROP TABLE db_Associate_Group
GO		
CREATE TABLE [db_Associate_Group] (
	[aID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[uID] [int] NOT NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Associate_User' )
	DROP TABLE db_Associate_User
GO		
CREATE TABLE [db_Associate_User] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[aSex] [varchar] (2) NOT NULL ,
	[aEmail] [nvarchar] (50) NULL ,
	[aTelHome] [nvarchar] (50) NULL ,
	[aTelOffice] [nvarchar] (50) NULL ,
	[aTelMob] [nvarchar] (50) NULL ,
	[aOicq] [nvarchar] (12) NULL ,
	[aMsn] [nvarchar] (50) NULL ,
	[aWork] [nvarchar] (200) NULL ,
	[aAddress] [nvarchar] (200) NULL ,
	[aZip] [nvarchar] (6) NULL ,
	[aUrl] [nvarchar] (200) NULL ,
	[aComment] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Back_Flow' )
	DROP TABLE db_Back_Flow
GO
CREATE TABLE [db_Back_Flow] (
	[bID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[fID] [int] NULL ,
	[fContent] [text] NULL ,
	[cID] [int] NULL ,
	[bSetup] [tinyint] NULL ,
	[bDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Branch' )
	DROP TABLE db_Branch
GO
CREATE TABLE [db_Branch] (
	[bID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[bName] [nvarchar] (50) NOT NULL ,
	[bLevel] [nvarchar] (50) NULL ,
	[bChief] [nvarchar] (50) NULL ,
	[bTel] [nvarchar] (50) NULL ,
	[bFax] [nvarchar] (50) NULL ,
	[bAddress] [nvarchar] (200) NULL ,
	[bUser] [text] NULL ,
	[bInfo] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Censor' )
	DROP TABLE db_Censor
GO		
CREATE TABLE [db_Censor] (
	[cID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[fID] [int] NULL ,
	[cComment] [nvarchar] (200) NULL ,
	[cAdvice] [text] NULL ,
	[uID] [int] NOT NULL ,
	[cStep] [tinyint] NOT NULL ,
	[cOverDate] [datetime] NULL ,
	[cBack] [tinyint] Not NULL DEFAULT (0),
	[cCensor] [bit] Not NULL DEFAULT (0)
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Common_Associate_Group' )
	DROP TABLE db_Common_Associate_Group
GO		
CREATE TABLE [db_Common_Associate_Group] (
	[cID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[uID] [int] NOT NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Common_Associate_User' )
	DROP TABLE db_Common_Associate_User
GO		
CREATE TABLE [db_Common_Associate_User] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[cID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[aSex] [nvarchar] (2) NOT NULL ,
	[aEmail] [nvarchar] (50) NULL ,
	[aTelHome] [nvarchar] (50) NULL ,
	[aTelOffice] [nvarchar] (50) NULL ,
	[aTelMob] [nvarchar] (50) NULL ,
	[aOicq] [nvarchar] (12) NULL ,
	[aMsn] [nvarchar] (50) NULL ,
	[aWork] [nvarchar] (200) NULL ,
	[aAddress] [nvarchar] (200) NULL ,
	[aZip] [nvarchar] (6) NULL ,
	[aUrl] [nvarchar] (200) NULL ,
	[aComment] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Common_Customer_Group' )
	DROP TABLE db_Common_Customer_Group
GO		
CREATE TABLE [db_Common_Customer_Group] (
	[cID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[uID] [int] NOT NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Common_Customer_User' )
	DROP TABLE db_Common_Customer_User
GO		
CREATE TABLE [db_Common_Customer_User] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[cID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[aSex] [nvarchar] (2) NOT NULL ,
	[aEmail] [nvarchar] (50) NULL ,
	[aTelHome] [nvarchar] (50) NULL ,
	[aTelOffice] [nvarchar] (50) NULL ,
	[aTelMob] [nvarchar] (50) NULL ,
	[aOicq] [nvarchar] (12) NULL ,
	[aMsn] [nvarchar] (50) NULL ,
	[aWork] [nvarchar] (200) NULL ,
	[aAddress] [nvarchar] (200) NULL ,
	[aZip] [nvarchar] (6) NULL ,
	[aUrl] [nvarchar] (200) NULL ,
	[aComment] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Customer_Group' )
	DROP TABLE db_Customer_Group
GO		
CREATE TABLE [db_Customer_Group] (
	[aID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[uID] [int] NOT NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Customer_User' )
	DROP TABLE db_Customer_User
GO		
CREATE TABLE [db_Customer_User] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[aName] [nvarchar] (50) NOT NULL ,
	[aSex] [nvarchar] (2) NOT NULL ,
	[aEmail] [nvarchar] (50) NULL ,
	[aTelHome] [nvarchar] (50) NULL ,
	[aTelOffice] [nvarchar] (50) NULL ,
	[aTelMob] [nvarchar] (50) NULL ,
	[aOicq] [nvarchar] (12) NULL ,
	[aMsn] [nvarchar] (50) NULL ,
	[aWork] [nvarchar] (200) NULL ,
	[aAddress] [nvarchar] (200) NULL ,
	[aZip] [nvarchar] (6) NULL ,
	[aUrl] [nvarchar] (200) NULL ,
	[aComment] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Document' )
	DROP TABLE db_Document
GO
CREATE TABLE [db_Document] (
	[dID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[dTitle] [nvarchar] (255) NOT NULL ,
	[dContent] [text] NULL ,
	[dAttachment] [text] NULL ,
	[dDate] [datetime] NOT NULL DEFAULT (getdate()) ,
	[dType] [tinyint] NOT NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[dReader] [text] NULL ,
	[dDelUser] [text] NULL ,
	[dSended] [bit] NOT NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Document_Template' )
	DROP TABLE db_Document_Template
GO
CREATE TABLE [db_Document_Template] (
	[dID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,