当前文件： GongWenLiuZhuan/DB_51aspx/MyOA_CreateTable.sql[4K，2009-6-12 11:43:27]，打开代码结构图

		            
 1CREATE DATABASE MyOA
 2GO
 3
 4USE MyOA
 5GO
 6
 7CREATE TABLE [dbo].[Department] (
 8    [DepartmentId] [int] NULL ,
 9    [DepartmentName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
10) ON [PRIMARY]
11GO
12
13CREATE TABLE [dbo].[File] (
14    [FileId] [int] IDENTITY (1, 1) NOT NULL ,
15    [FileTitle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
16    [FileContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,
17    [FromUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
18    [ToUserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
19    [AffixFile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
20    [FileStatus] [int] NULL 
21) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
22GO
23
24CREATE TABLE [dbo].[FileStatus] (
25    [FileStatusId] [int] NULL ,
26    [FileStatusName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
27) ON [PRIMARY]
28GO
29
30CREATE TABLE [dbo].[Plan] (
31    [PlanId] [int] IDENTITY (1, 1) NOT NULL ,
32    [LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
33    [PlanDate] [datetime] NULL ,
34    [PlanContent] [text] COLLATE Chinese_PRC_CI_AS NULL 
35) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
36GO
37
38CREATE TABLE [dbo].[Role] (
39    [RoleId] [int] NULL ,
40    [RoleName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
41    [HasDuty_UserView] [int] NULL ,
42    [HasDuty_UserManage] [int] NULL ,
43    [HasDuty_RoleManage] [int] NULL ,
44    [HasDuty_FileView] [int] NULL ,
45    [HasDuty_FileSubmit] [int] NULL ,
46    [HasDuty_FileDispose] [int] NULL ,
47    [HasDuty_LogManage] [int] NULL 
48) ON [PRIMARY]
49GO
50
51CREATE TABLE [dbo].[TreeMenu] (
52    [NodeId] [int] NOT NULL ,
53    [ParentId] [int] NOT NULL ,
54    [Text] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
55    [Url] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
56    [Duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
57) ON [PRIMARY]
58GO
59
60CREATE TABLE [dbo].[User] (
61    [UserId] [int] IDENTITY (1, 1) NOT NULL ,
62    [LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
63    [UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
64    [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
65    [DepartmentId] [int] NULL ,
66    [RoleId] [int] NULL 
67) ON [PRIMARY]
68GO
69