当前文件： DutySystem/App_Data/database.sql[2K，2009-6-12 11:41:29]，打开代码结构图

		            
 1SET ANSI_NULLS ON
 2GO
 3SET QUOTED_IDENTIFIER ON
 4GO
 5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LHB_Office_ZBB]') AND type in (N'U'))
 6BEGIN
 7CREATE TABLE [dbo].[LHB_Office_ZBB](
 8    [id] [int] IDENTITY(1,1) NOT NULL,
 9    [L_ZBB_KS] [int] NULL,
10    [L_ZBB_nameId] [int] NULL,
11    [L_ZBB_BZ] [varchar](25) NULL,
12    [L_ZBB_dateBegin] [datetime] NULL,
13    [L_ZBB_dateEnd] [datetime] NULL
14) ON [PRIMARY]
15END
16GO
17SET ANSI_NULLS ON
18GO
19SET QUOTED_IDENTIFIER ON
20GO
21IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LHB_Office_ZBB_KS]') AND type in (N'U'))
22BEGIN
23CREATE TABLE [dbo].[LHB_Office_ZBB_KS](
24    [id] [int] IDENTITY(1,1) NOT NULL,
25    [L_KS_KSMC] [varchar](50) NULL,
26    [L_KS_KSBM] [varchar](50) NULL
27) ON [PRIMARY]
28END
29GO
30SET ANSI_NULLS ON
31GO
32SET QUOTED_IDENTIFIER ON
33GO
34IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LHB_Office_ZBB_USER]') AND type in (N'U'))
35BEGIN
36CREATE TABLE [dbo].[LHB_Office_ZBB_USER](
37    [id] [int] IDENTITY(1,1) NOT NULL,
38    [L_user_name] [varchar](50) NULL,
39    [L_user_sex] [bit] NULL,
40    [L_user_KSBM] [int] NULL,
41    [L_user_Number] [varchar](50) NULL
42) ON [PRIMARY]
43END
44