📄 sqlsetup.sql

📁 基于ASP的OA办公系统有BBS
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
	[dTitle] [nvarchar] (200) NOT NULL ,
	[dContent] [text] NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[tType] [bit] NOT NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Email' )
	DROP TABLE db_Email
GO		
CREATE TABLE [db_Email] (
	[eID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[eTitle] [nvarchar] (255) NOT NULL ,
	[eContent] [text] NULL ,
	[eAttachment] [text] NULL ,
	[eDate] [datetime] NOT NULL DEFAULT (getdate()),
	[eType] [tinyint] NOT NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[eReader] [text] NULL ,
	[eReply] [text] NULL ,
	[eDelUser] [text] NULL ,
	[eSendSave] [bit] NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Flow_Document' )
	DROP TABLE db_Flow_Document
GO		
CREATE TABLE [db_Flow_Document] (
	[fID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[fGS] [nvarchar] (20) NULL ,
	[fFH] [nvarchar] (20) NULL ,
	[fMM] [nvarchar] (20) NULL ,
	[fJJ] [nvarchar] (20) NULL ,
	[fBT] [nvarchar] (50) NULL ,
	[fZH] [nvarchar] (25) NULL ,
	[fTitle] [nvarchar] (255) NOT NULL ,
	[fContent] [text] NULL ,
	[fAttachment] [text] NULL ,
	[fSignature] [tinyint] NULL DEFAULT (0) ,
	[fFWJG] [nvarchar] (80) NULL ,
	[fComment] [text] NULL ,
	[fZTC] [nvarchar] (200) NULL ,
	[fYF] [text] NULL ,
	[fYS] [nvarchar] (5) NULL ,
	[fDate] [datetime] NOT NULL DEFAULT (getdate()),
	[fType] [tinyint] NULL ,
	[zgUser] [nvarchar] (10) NULL ,
	[zbUser] [nvarchar] (10) NULL ,
	[zuUser] [nvarchar] (10) NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[fReader] [text] NULL ,
	[fDelUser] [text] NULL ,
	[fCensorNum] [tinyint] NULL ,
	[fCensorer] [nvarchar] (6) NULL ,
	[fBack] [bit] NOT NULL DEFAULT (0) ,
	[fBackDate] [datetime] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Flow_Document_Template' )
	DROP TABLE db_Flow_Document_Template
GO		
CREATE TABLE [db_Flow_Document_Template] (
	[fID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[fTitle] [nvarchar] (200) NOT NULL ,
	[fContent] [text] NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[tType] [bit] NOT NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Forum_Category' )
	DROP TABLE db_Forum_Category
GO
CREATE TABLE [db_Forum_Category] (
	[fID] [smallint] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[fTitle] [nvarchar] (100) NOT NULL ,
	[fComment] [text] NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[uID] [int] NOT NULL ,
    [fTopicCount] [int] NOT NULL DEFAULT (0) ,
	[fReplyCount] [int] NOT NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Forum_Reply' )
	DROP TABLE db_Forum_Reply
GO		
CREATE TABLE [db_Forum_Reply] (
	[rID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[tID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[rContent] [text] NULL ,
	[rPoctDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Forum_Topic' )
	DROP TABLE db_Forum_Topic
GO		
CREATE TABLE [db_Forum_Topic] (
	[tID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[fID] [smallint] NOT NULL ,
	[uID] [int] NOT NULL ,
	[tTitle] [nvarchar] (200) NOT NULL ,
	[tContent] [text] NULL ,
	[tPostDate] [datetime] NOT NULL DEFAULT (getdate()),
	[tView] [int] NULL ,
	[tReplyCount] [int] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Group' )
	DROP TABLE db_Group
GO
CREATE TABLE [db_Group] (
	[gID] [smallint] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[gName] [nvarchar] (80) NOT NULL ,
	[gUser] [text] NULL 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Meeting' )
	DROP TABLE db_Meeting
GO
CREATE TABLE [db_Meeting] (
	[mID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[mChief] [int]  NULL ,
	[mTitle] [nvarchar] (200) NOT NULL ,
	[mComment] [text] NULL ,
	[gUser] [text]  NULL ,
	[bUser] [text]  NULL ,
	[uUser] [text]  NULL ,
	[mDate] [datetime] NOT NULL DEFAULT (getdate()) ,
	[mType] [bit] NOT NULL DEFAULT (0)
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Meeting_Online' )
	DROP TABLE db_Meeting_Online
GO
CREATE TABLE [db_Meeting_Online] (
	[oID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[mID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[oDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Msg' )
	DROP TABLE db_Msg
GO		
CREATE TABLE [db_Msg] (
	[mID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[mFrom] [int] NOT NULL ,
	[mTo] [int] NOT NULL ,
	[mMessage] [text] NULL ,
	[mDate] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_News' )
	DROP TABLE db_News
GO
CREATE TABLE [db_News] (
	[nID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[nTitle] [nvarchar] (255) NOT NULL ,
	[nContent] [text] NULL ,
	[nDate] [datetime] NOT NULL DEFAULT (getdate()),
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[nReader] [text] NULL 
) ON [PRIMARY]
GO

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

IF EXISTS(Select * From sysobjects where name = 'db_Policy' )
	DROP TABLE db_Policy
GO		
CREATE TABLE [db_Policy] (
	[pID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[pTitle] [nvarchar] (255) NOT NULL ,
	[pContent] [text] NULL ,
	[pDate] [datetime] NOT NULL DEFAULT (getdate()),
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[pReader] [text] NULL 
) ON [PRIMARY]
GO		

IF EXISTS(Select * From sysobjects where name = 'db_Reserve' )
	DROP TABLE db_Reserve
GO		
CREATE TABLE [db_Reserve] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[aID] [int] NOT NULL ,
	[uID] [int] NOT NULL ,
	[StartTime] [datetime] NULL ,
	[EndTime] [datetime] NULL ,
	[Asset_Info] [text] NULL 
) ON [PRIMARY]
GO	

IF EXISTS(Select * From sysobjects where name = 'db_Signature' )
	DROP TABLE db_Signature
GO		
CREATE TABLE [db_Signature] (
	[sID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uID] [int] NOT NULL ,
	[sName] [nvarchar] (80) NOT NULL ,
	[sSignature] [nvarchar] (100) NULL ,
	[sComment] [text] NULL ,
	[gUser] [text] NULL ,
	[bUser] [text] NULL ,
	[uUser] [text] NULL ,
	[sDate] [datetime] NOT NULL DEFAULT (getdate()),
	[sType] [bit] NOT NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_User' )
	DROP TABLE db_User
GO
CREATE TABLE [db_User] (
	[uID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[uName] [nvarchar] (20) NOT NULL ,
	[uSex] [nvarchar] (2) NOT NULL ,
	[uPassword] [nvarchar] (50) NOT NULL ,
	[uTel] [nvarchar] (20)  NULL ,
	[uEmail] [nvarchar] (50) NULL ,
	[uOicq] [nvarchar] (12)  NULL ,
	[uInfo] [text]  NULL ,
	[uRegTime] [datetime] NOT NULL DEFAULT (getdate()),
	[uLastLoginTime] [datetime] NULL ,
	[uLastActiveTime] [datetime] NULL,
	[uOnline] [bit] NOT NULL DEFAULT (0), 
	[uLevel] [nvarchar] (1) NULL ,
	[uLoginCount] [int] NOT NULL DEFAULT (0) ,
	[uChkDesk] [bit] NOT NULL DEFAULT (0) 
) ON [PRIMARY]
GO

IF EXISTS(Select * From sysobjects where name = 'db_Version' )
	DROP TABLE db_Version
GO		
CREATE TABLE [db_Version] (
	[ID] [int] IDENTITY (1, 1) PRIMARY KEY  CLUSTERED  NOT NULL ,
	[vSerialNumber] [nvarchar] (50) NULL ,
) ON [PRIMARY]
GO
		
		
		
INSERT INTO [db_USER] ([uName],[uSex], [uPassword],[uTel],[uEmail],[uOicq],[uInfo],[uLastLoginTime],[uLastActiveTime],[uLevel]) VALUES ('admin','男','293740B3817A38ADC0898C1858AA86','13540042001','net-oa@sohu.com','2503086','NET-OA开发人：江南行客',getdate(),getdate(),'1')

INSERT INTO [db_Branch] ([bName],[bLevel],[bChief],[bUser]) VALUES ('最高部门','0','|1|','|1|')

INSERT INTO [db_Group] ([gName],[gUser]) VALUES ('管理用户组','|1|')

INSERT INTO [db_Signature] ([uID],[sName],[sSignature],[sComment],[sType]) VALUES (1,'个人印鉴','1/1_signature.gif','个人印章，仅供本人使用。',1)

INSERT INTO [db_Signature] ([uID],[sName],[sSignature],[sComment],[uUser],[sType]) VALUES (1,'软件鉴定章','1/1_jnxk.gif','"江南行客软件制作中心"鉴定章','|1|',0)


INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('动态信息', 'NEWS','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('公共计划信息', 'COMMONARRANGEMENT','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('公共通讯录', 'COMMONASSOCIATE','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('公共客户', 'COMMONCUSTOMER','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('论坛管理', 'FORUM','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('会议管理', 'MEETING','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('普通公文模板', 'DOCUMENTTEMPLATE','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('流转公文模板', 'FLOWDOCUMENTTEMPLATE','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('部门管理', 'BRANCH','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('用户组管理', 'GROUP','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('用户管理', 'USER','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('印章管理', 'SIGNATURE','|','|','|','|')
INSERT INTO [db_Administer] ([aName],[aModule],[aAddType],[aEditType],[aDelType],[aViewType]) VALUES ('资源管理', 'ASSET','|','|','|','|')

		
INSERT INTO [db_Version]([vSerialNumber]) VALUES ('Demo')
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -