db_sql

USE [ASIMS]
GO
/****** Object:  Table [db_owner].[Sys_RoleMember]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Sys_RoleMember](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [RoleID] [int] NULL,
 [UserID] [varchar](50) NULL,
 [UserName] [nvarchar](20) NULL,
 [CreatorID] [varchar](10) NULL,
 [CreatorName] [nvarchar](20) NULL,
 [CreateDate] [datetime] NULL,
 CONSTRAINT [PK_SYS_ROLEMEMBER] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'RoleID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成员ID' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成员名称' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人员工号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'CreatorID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'CreatorName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户角色成员信息表' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_RoleMember'
GO
SET IDENTITY_INSERT [db_owner].[Sys_RoleMember] ON
INSERT [db_owner].[Sys_RoleMember] ([ID], [RoleID], [UserID], [UserName], [CreatorID], [CreatorName], [CreateDate]) VALUES (2, 1, N'PMICHOL', N'洪林', N'PMICHUB', NULL, CAST(0x00009DAC00D91CB0 AS DateTime))
INSERT [db_owner].[Sys_RoleMember] ([ID], [RoleID], [UserID], [UserName], [CreatorID], [CreatorName], [CreateDate]) VALUES (3, 1, N'PMICHUB', N'胡兵', N'PMICHUB', NULL, CAST(0x00009DAC00D91CB0 AS DateTime))
INSERT [db_owner].[Sys_RoleMember] ([ID], [RoleID], [UserID], [UserName], [CreatorID], [CreatorName], [CreateDate]) VALUES (8, 2, N'PCITYJX', N'颜建兴', N'PCITYJX', NULL, CAST(0x00009DCE00B2A54D AS DateTime))
INSERT [db_owner].[Sys_RoleMember] ([ID], [RoleID], [UserID], [UserName], [CreatorID], [CreatorName], [CreateDate]) VALUES (9, 2, N'PCITHTJ', N'黄体健', N'PCITYJX', NULL, CAST(0x00009DCE00B2A552 AS DateTime))
SET IDENTITY_INSERT [db_owner].[Sys_RoleMember] OFF
/****** Object:  Table [db_owner].[Sys_Role]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Sys_Role](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [ParentID] [int] NULL,
 [Name] [nvarchar](100) NULL,
 [OwnerType] [int] NULL,
 [OwnerID] [varchar](50) NULL,
 [CreatorID] [varchar](50) NULL,
 [CreatorName] [nvarchar](20) NULL,
 [CreateDate] [datetime] NULL,
 [ViewOrder] [int] NULL,
 [Memo] [nvarchar](200) NULL,
 CONSTRAINT [PK_SYS_ROLE] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父节点流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ParentID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所有者类型' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'OwnerType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所有者标识' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'OwnerID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人员工号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreatorID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreatorName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示序号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ViewOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Memo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户角色信息表' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Role'
GO
SET IDENTITY_INSERT [db_owner].[Sys_Role] ON
INSERT [db_owner].[Sys_Role] ([ID], [ParentID], [Name], [OwnerType], [OwnerID], [CreatorID], [CreatorName], [CreateDate], [ViewOrder], [Memo]) VALUES (1, NULL, N'系统管理员', NULL, N'', N'PMICHUB', N'', CAST(0x00009DAC00D91BB0 AS DateTime), 1, N'')
INSERT [db_owner].[Sys_Role] ([ID], [ParentID], [Name], [OwnerType], [OwnerID], [CreatorID], [CreatorName], [CreateDate], [ViewOrder], [Memo]) VALUES (2, NULL, N'角色1', NULL, N'', N'PCITYJX', N'', CAST(0x00009DCE00B2A54D AS DateTime), 2, N'角色1')
SET IDENTITY_INSERT [db_owner].[Sys_Role] OFF
/****** Object:  Table [db_owner].[Sys_Right]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Sys_Right](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [ObjType] [int] NULL,
 [ObjID] [varchar](50) NULL,
 [ObjName] [nvarchar](100) NULL,
 [RightString] [varchar](max) NULL,
 [CreatorID] [varchar](50) NULL,
 [CreatorName] [nvarchar](20) NULL,
 [CreateDate] [datetime] NULL,
 CONSTRAINT [PK_SYS_RIGHT] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被授权对象类型' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'ObjType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被授权对象编号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'ObjID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被授权对象名称' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'ObjName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限字符串' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'RightString'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人员工号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'CreatorID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人姓名' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'CreatorName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统授权信息表' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Right'
GO
SET IDENTITY_INSERT [db_owner].[Sys_Right] ON
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (1, 1, N'1', N'系统管理员', N'18-17-19-22-20-21', N'PMICHOL', NULL, CAST(0x00009DAC00A4A2A4 AS DateTime))
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (2, 1, N'2', N'角色1', N'19-22', N'PCITYJX', N'颜建兴', CAST(0x00009DCA009320A6 AS DateTime))
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (4, 2, N'4311', N'中国广东核电集团\合营公司\总经理部', N'19-22', N'PCITYJX', N'颜建兴', CAST(0x00009DCA009341E7 AS DateTime))
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (6, 2, N'4360', N'中国广东核电集团\运营公司\总经理部', NULL, N'PCITYJX', N'颜建兴', CAST(0x00009DD200B60C39 AS DateTime))
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (9, 0, N'PCITYJX', N'颜建兴', NULL, N'PCITYJX', N'颜建兴', CAST(0x00009DD200B84597 AS DateTime))
INSERT [db_owner].[Sys_Right] ([ID], [ObjType], [ObjID], [ObjName], [RightString], [CreatorID], [CreatorName], [CreateDate]) VALUES (10, 0, N'PCITHTJ', N'黄体健', NULL, N'PCITYJX', N'颜建兴', CAST(0x00009DD200B9D52E AS DateTime))
SET IDENTITY_INSERT [db_owner].[Sys_Right] OFF
/****** Object:  Table [db_owner].[Sys_FunctionPoint]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Sys_FunctionPoint](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [ParentID] [int] NULL,
 [Code] [varchar](50) NULL,
 [Name] [nvarchar](100) NULL,
 [Type] [int] NULL,
 [Url] [nvarchar](200) NULL,
 [IsMenu] [int] NULL,
 [ViewOrder] [int] NULL,
 [Status] [int] NULL,
 [Memo] [nvarchar](200) NULL,
 CONSTRAINT [PK_SYS_FUNCTIONPOINT] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父节点流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'ParentID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型(0:页面/1:按钮)' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'页面链接' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Url'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否作为菜单显示(0:否/1:是)' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'IsMenu'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示序号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'ViewOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint', @level2type=N'COLUMN',@level2name=N'Memo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统功能点信息表' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_FunctionPoint'
GO
SET IDENTITY_INSERT [db_owner].[Sys_FunctionPoint] ON
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (16, 0, NULL, N'系统管理', 1, NULL, NULL, 1, 1, NULL)
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (17, 16, N'', N'功能点管理', 1, N'../SysManage/FunPoint/List.aspx', NULL, 2, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (25, 24, N'test', N'tes', 1, N'test', NULL, 25, 0, N'test')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (26, 0, N'', N'系统功能点1', 2, N'', NULL, 26, 1, N'tteset')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (18, 16, N'', N'常量管理', 1, N'../SysManage/Const/List.aspx', NULL, 3, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (19, 24, N'', N'角色管理', 1, N'../SysManage/Role/List.aspx', NULL, 4, 0, NULL)
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (20, 23, N'', N'操作日志', 1, N'../SysManage/Log/Operation/List.aspx', NULL, 6, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (21, 23, N'', N'异常日志', 1, N'../SysManage/Log/Exception/List.aspx', NULL, 7, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (22, 24, N'', N'权限授予', 1, N'../SysManage/Right/Main.aspx', NULL, 5, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (23, 16, N'', N'系统日志', 1, N'', NULL, 24, 1, N'')
INSERT [db_owner].[Sys_FunctionPoint] ([ID], [ParentID], [Code], [Name], [Type], [Url], [IsMenu], [ViewOrder], [Status], [Memo]) VALUES (24, 16, N'', N'系统授权', 1, N'', NULL, 23, 1, N'')
SET IDENTITY_INSERT [db_owner].[Sys_FunctionPoint] OFF
/****** Object:  Table [db_owner].[Sys_Const]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Sys_Const](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [ParentID] [int] NULL,
 [Code] [varchar](20) NULL,
 [Name] [nvarchar](100) NULL,
 [ConstValue] [nvarchar](100) NULL,
 [ViewOrder] [int] NULL,
 [Visible] [int] NULL,
 [Memo] [nvarchar](200) NULL,
 CONSTRAINT [PK_SYS_CONST] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'ParentID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'值' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'ConstValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示序号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'ViewOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'可见度' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'Visible'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Sys_Const', @level2type=N'COLUMN',@level2name=N'Memo'
GO
SET IDENTITY_INSERT [db_owner].[Sys_Const] ON
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (1, 0, N'd', N'd', N'd', 1, 0, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (2, 10, N'222', N'test1111', N'22', 2, 1, N'')
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (3, 2, N'hh', N'hh', N'8', 3, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (4, 3, N'fff', N'dd', N'55', 4, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (5, 0, N'rr', N'rrr', N'rr', 5, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (8, 0, N'bbb', N'bbb', N'bbb', 8, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (6, 2, N'ddd', N'ddd', N'ddd', 6, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (7, 0, N'jjj', N'jjj', N'jjj', 7, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (9, 0, N'qqq', N'qqqq', N'qqqq', 2, 1, N'')
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (10, 0, N'ccc', N'cccccc', N'cccccc', 10, 1, NULL)
INSERT [db_owner].[Sys_Const] ([ID], [ParentID], [Code], [Name], [ConstValue], [ViewOrder], [Visible], [Memo]) VALUES (11, 0, N'eeeeeee', N'eee', N'eeeeeeee', 11, 9, NULL)
SET IDENTITY_INSERT [db_owner].[Sys_Const] OFF
/****** Object:  Table [db_owner].[Log_Operation]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Log_Operation](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [RecordID] [int] NULL,
 [OpType] [nvarchar](10) NULL,
 [OpDesc] [nvarchar](max) NULL,
 [PageUrl] [nvarchar](500) NULL,
 [UserID] [varchar](50) NULL,
 [UserName] [nvarchar](20) NULL,
 [UserIP] [varchar](128) NULL,
 [OpDate] [datetime] NULL,
 CONSTRAINT [PK_LOG_OPERATION] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作记录流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'RecordID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作类型(浏览/新增/修改/删除)' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'OpType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作描述' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'OpDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作页面URL' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'PageUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作用户员工号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作用户姓名' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作用户IP地址' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'UserIP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作发生时间' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Operation', @level2type=N'COLUMN',@level2name=N'OpDate'
GO
/****** Object:  Table [db_owner].[Log_Exception]    Script Date: 09/02/2010 10:41:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [db_owner].[Log_Exception](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Code] [varchar](50) NULL,
 [Message] [nvarchar](400) NULL,
 [StackTrace] [nvarchar](max) NULL,
 [PageUrl] [nvarchar](500) NULL,
 [UserID] [varchar](50) NULL,
 [UserName] [nvarchar](20) NULL,
 [LogDate] [datetime] NULL,
 CONSTRAINT [PK_LOG_EXCEPTION] PRIMARY KEY NONCLUSTERED
(
 [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流水号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常类型编码' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'Code'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常消息' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'Message'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常堆栈信息' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'StackTrace'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常页URL' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'PageUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户员工号' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户姓名' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常发生时间' , @level0type=N'SCHEMA',@level0name=N'db_owner', @level1type=N'TABLE',@level1name=N'Log_Exception', @level2type=N'COLUMN',@level2name=N'LogDate'
GO
/****** Object:  UserDefinedFunction [db_owner].[getRoleMember]    Script Date: 09/02/2010 10:41:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  PMICHOL
-- Create date: 6/4/2010
-- Description: get the member of role by roleid
-- =============================================
CREATE FUNCTION [db_owner].[getRoleMember](@id int)
RETURNS nvarchar(2000)
AS
BEGIN
 DECLARE @result nvarchar(2000)
 set @result=''
 SELECT @result=@result+';'+UserName from db_owner.Sys_RoleMember where RoleID=@id
 IF(len(@result)>1)
    SET @result=right(@result,len(@result)-1)
 RETURN (@result)
END
GO