当前文件： AssignWorkSystem/App_Data/ICwork.sql[3K，2009-6-12 11:32:51]，打开代码结构图

		            
 1SET ANSI_NULLS ON
 2GO
 3SET QUOTED_IDENTIFIER ON
 4GO
 5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Task]') AND type in (N'U'))
 6BEGIN
 7CREATE TABLE [dbo].[Task](
 8    [ID] [int] IDENTITY(1,1) NOT NULL,
 9    [ProjectID] [int] NOT NULL,
10    [TaskName] [nvarchar](50) NOT NULL,
11    [BeginDate] [datetime] NOT NULL,
12    [EndDate] [datetime] NOT NULL,
13    [TaskComment] [nvarchar](50) NULL,
14 CONSTRAINT [PK_Task] PRIMARY KEY CLUSTERED 
15(
16    [ID] ASC
17)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
18) ON [PRIMARY]
19END
20GO
21SET ANSI_NULLS ON
22GO
23SET QUOTED_IDENTIFIER ON
24GO
25IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Assignment]') AND type in (N'U'))
26BEGIN
27CREATE TABLE [dbo].[Assignment](
28    [ID] [int] IDENTITY(1,1) NOT NULL,
29    [TaskID] [int] NOT NULL,
30    [Engineer] [nvarchar](50) NOT NULL,
31    [Manager] [nvarchar](50) NOT NULL,
32    [state] [bit] NOT NULL,
33    [description] [nvarchar](200) NULL,
34 CONSTRAINT [PK_Assignment] PRIMARY KEY CLUSTERED 
35(
36    [ID] ASC
37)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
38) ON [PRIMARY]
39END
40GO
41SET ANSI_NULLS ON
42GO
43SET QUOTED_IDENTIFIER ON
44GO
45IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[passport]') AND type in (N'U'))
46BEGIN
47CREATE TABLE [dbo].[passport](
48    [ID] [int] IDENTITY(1,1) NOT NULL,
49    [engineer] [nvarchar](50) NOT NULL,
50 CONSTRAINT [PK_passport] PRIMARY KEY CLUSTERED 
51(
52    [ID] ASC
53)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
54) ON [PRIMARY]
55END
56GO
57SET ANSI_NULLS ON
58GO
59SET QUOTED_IDENTIFIER ON
60GO
61IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Project]') AND type in (N'U'))
62BEGIN
63CREATE TABLE [dbo].[Project](
64    [ID] [int] IDENTITY(1,1) NOT NULL,
65    [ProjectName] [nvarchar](50) NULL,
66    [ProjectGroup] [nvarchar](50) NULL,
67    [ProjectLead] [nvarchar](50) NULL,
68 CONSTRAINT [PK_Project] PRIMARY KEY CLUSTERED 
69(
70    [ID] ASC
71)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
72) ON [PRIMARY]
73END
74