luo.txt

来自「一个OA办公自动化管理系统」· 文本 代码 · 共 86 行

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

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

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

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

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

CREATE TABLE [dbo].[PassWord] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (50) NULL ,
	[PassWord] [nvarchar] (50) NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[PubOAData] (
	[DraftID] [int] NOT NULL ,
	[SendDate] [datetime] NULL ,
	[SendMen] [nvarchar] (50) NULL ,
	[Addressee] [nvarchar] (50) NULL ,
	[CopyTo] [nvarchar] (50) NULL ,
	[Topic] [nvarchar] (50) NULL ,
	[KeyWord] [nvarchar] (50) NULL ,
	[Summary] [nvarchar] (4000) NULL ,
	[Accessory] [nvarchar] (100) NULL ,
	[Style] [bit] NOT NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[PubOAGroup] (
	[GroupID] [nvarchar] (50) NOT NULL ,
	[Explain] [nvarchar] (200) NULL ,
	[Type] [nvarchar] (50) NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[PubOAPower] (
	[FunctionID] [nvarchar] (50) NOT NULL ,
	[Explain] [nvarchar] (50) NULL ,
	[GroupID] [nvarchar] (50) NULL ,
	[TeamID] [nvarchar] (50) NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[PubOATeam] (
	[TeamID] [nvarchar] (50) NOT NULL ,
	[Explain] [nvarchar] (50) NULL ,
	[Type] [nvarchar] (50) NULL 
) ON [PRIMARY]

ALTER TABLE [dbo].[PassWord] WITH NOCHECK ADD 
	CONSTRAINT [PK_PassWord] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[PubOAData] WITH NOCHECK ADD 
	CONSTRAINT [DF_PubOAData_Style] DEFAULT (0) FOR [Style],
	CONSTRAINT [PK_PubOAData] PRIMARY KEY  NONCLUSTERED 
	(
		[DraftID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[PubOAGroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_PubOAGroup] PRIMARY KEY  NONCLUSTERED 
	(
		[GroupID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[PubOAPower] WITH NOCHECK ADD 
	CONSTRAINT [PK_PubOAPower] PRIMARY KEY  NONCLUSTERED 
	(
		[FunctionID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[PubOATeam] WITH NOCHECK ADD 
	CONSTRAINT [PK_PubOATeam] PRIMARY KEY  NONCLUSTERED 
	(
		[TeamID]
	)  ON [PRIMARY]