当前文件： AutoDutySystem/App_Data/DutyDemo.sql[1K，2009-6-12 11:33:11]，打开代码结构图

		            
 1SET ANSI_NULLS ON
 2GO
 3SET QUOTED_IDENTIFIER ON
 4GO
 5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DutyDetail]') AND type in (N'U'))
 6BEGIN
 7CREATE TABLE [dbo].[DutyDetail](
 8    [ID] [int] IDENTITY(1,1) NOT NULL,
 9    [StaffID] [int] NOT NULL,
10    [DutyDate] [datetime] NOT NULL,
11    [DutyMonth] [int] NOT NULL,
12    [DutyDayOfWeek] [nvarchar](20) NOT NULL,
13    [DutyType] [bit] NOT NULL,
14 CONSTRAINT [PK_DutyDetail] 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].[DutyStaff]') AND type in (N'U'))
26BEGIN
27CREATE TABLE [dbo].[DutyStaff](
28    [ID] [int] IDENTITY(1,1) NOT NULL,
29    [StaffName] [nvarchar](50) NOT NULL,
30    [StaffAge] [int] NOT NULL,
31 CONSTRAINT [PK_DutyStaff] PRIMARY KEY CLUSTERED 
32(
33    [ID] ASC
34)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
35) ON [PRIMARY]
36END
37