ASP.NET MVC 实现页落网资源分享网站+充值管理+后台管理（1）之数据库设计

本文主要讲解本项目网站所应用到的知识点，及数据库的相关设计：

一、知识点

（1）本项目主要采取 MVC的编程模式，相信你已经了解到了MVC的具体含义是什么，这里不再赘述，有不了解的朋友，可以先了解相关资源，在来接着学习这里的知识。

（2）本项目已经进行多次抽象出了数据工厂模式、仓储类、业务层、实体层、及应用层，并将常用的和更改的一些帮助类和数据工厂模式、仓储类等封装成了程序集dll，大家可以直接下载应用或者访问开篇前的文章，里面有详细的讲解，这里不在赘述！

（3）本项目前端弹窗主要用到layer以及其他的一些数据验证插件，比如datepicker等，页面基本是原创手工重构，喜欢的朋友也可以参考或者在页落网上下载其他资源。

（4）本项目的数据库使用SQl Server创建，主键使用全球唯一码GUID字符串。

三、数据库设计

数据库的创建，相信你已经手脑纯熟了，这里不赘述，直接上创建代码：

（1）Base_SysLog系统日志表USE [SysDataBase]GO/****** Object: Table [dbo].[Base_SysLog] Script Date: 10/16/ 14:29:11 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Base_SysLog]([SysLogId] [varchar](50) NOT NULL,[ObjectId] [varchar](50) NULL,[LogType] [varchar](50) NULL,[IPAddress] [varchar](50) NULL,[IPAddressName] [varchar](200) NULL,[CompanyId] [varchar](50) NULL,[DepartmentId] [varchar](50) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](100) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](100) NULL,[ModuleId] [varchar](50) NULL,[Remark] [varchar](max) NULL,[Status] [varchar](50) NULL,CONSTRAINT [PK_BASE_SYSLOG] PRIMARY KEY NONCLUSTERED ([SysLogId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'SysLogId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对象主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'ObjectId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'LogType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'IPAddress'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP地址所在地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'IPAddressName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CompanyId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'DepartmentId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'ModuleId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'Remark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'Status'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog'GOALTER TABLE [dbo].[Base_SysLog] ADD CONSTRAINT [DF__Base_SysL__Creat__014935CB] DEFAULT (getdate()) FOR [CreateDate]GO（2）Base_SysLogDetail系统日志明细表USE [SysDataBase]GO/****** Object: Table [dbo].[Base_SysLogDetail] Script Date: 10/16/ 14:44:54 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Base_SysLogDetail]([SysLogDetailId] [varchar](50) NOT NULL,[SysLogId] [varchar](50) NULL,[PropertyName] [varchar](50) NULL,[PropertyField] [varchar](50) NULL,[NewValue] [varchar](max) NULL,[OldValue] [varchar](50) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](100) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](100) NULL,CONSTRAINT [PK_BASE_SYSLOGDETAIL] PRIMARY KEY NONCLUSTERED ([SysLogDetailId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志明细主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'SysLogDetailId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'SysLogId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'PropertyName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性字段' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'PropertyField'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性新值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'NewValue'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性旧值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'OldValue'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail'GOALTER TABLE [dbo].[Base_SysLogDetail] WITH CHECK ADD CONSTRAINT [FK_Base_SysLogDetail_Base_SysLog] FOREIGN KEY([SysLogId])REFERENCES [dbo].[Base_SysLog] ([SysLogId])ON DELETE CASCADEGOALTER TABLE [dbo].[Base_SysLogDetail] CHECK CONSTRAINT [FK_Base_SysLogDetail_Base_SysLog]GOALTER TABLE [dbo].[Base_SysLogDetail] ADD CONSTRAINT [DF_Base_SysLogDetail_CreateDate1] DEFAULT (getdate()) FOR [CreateDate]GO（3）Base_DataDictionaryDetail数据字典详细表USE [SysDataBase]GO/****** Object: Table [dbo].[Base_DataDictionaryDetail] Script Date: 10/16/ 14:45:27 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Base_DataDictionaryDetail]([DataDictionaryDetailId] [varchar](50) NOT NULL,[DataDictionaryType] [varchar](50) NULL,[ParentId] [varchar](50) NULL,[Code] [varchar](50) NULL,[DataDictionaryTitle] [nvarchar](200) NULL,[SortCode] [int] NULL,[Remark] [nvarchar](max) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [varchar](50) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [varchar](50) NULL,CONSTRAINT [PK_Base_DataDictionaryDetail] PRIMARY KEY CLUSTERED ([DataDictionaryDetailId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryDetailId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ParentId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'Code'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryTitle'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'Remark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典详细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail'GOALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD CONSTRAINT [DF_Base_DataDictionaryDetail_ParentId] DEFAULT ((0)) FOR [ParentId]GOALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD CONSTRAINT [DF_Base_DataDictionaryDetail_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD CONSTRAINT [DF_Base_DataDictionaryDetail_CreateDate] DEFAULT (getdate()) FOR [CreateDate]GO（4）Base_ProvinceCity省是区域表USE [SysDataBase]GO/****** Object: Table [dbo].[Base_ProvinceCity] Script Date: 10/16/ 14:45:48 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Base_ProvinceCity]([ProvinceCityId] [varchar](50) NOT NULL,[ParentId] [varchar](50) NULL,[Category] [varchar](50) NULL,[Code] [varchar](50) NULL,[FullName] [varchar](50) NULL,[Enabled] [int] NULL,[SortCode] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [varchar](50) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [varchar](50) NULL,CONSTRAINT [PK_Base_ProvinceCity] PRIMARY KEY CLUSTERED ([ProvinceCityId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省市区主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ProvinceCityId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ParentId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Category'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Code'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'FullName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Enabled'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省是区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity'GOALTER TABLE [dbo].[Base_ProvinceCity] ADD CONSTRAINT [DF_Base_ProvinceCity_Enabled] DEFAULT ((1)) FOR [Enabled]GOALTER TABLE [dbo].[Base_ProvinceCity] ADD CONSTRAINT [DF_Base_ProvinceCity_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Base_ProvinceCity] ADD CONSTRAINT [DF_Base_ProvinceCity_CreateDate] DEFAULT (getdate()) FOR [CreateDate]GO（5）Base_User系统用户表USE [SysDataBase]GO/****** Object: Table [dbo].[Base_User] Script Date: 10/16/ 14:46:19 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Base_User]([UserId] [varchar](50) NOT NULL,[Account] [varchar](50) NULL,[Password] [varchar](50) NULL,[Secretkey] [varchar](50) NULL,[RealName] [varchar](50) NULL,[Spell] [varchar](200) NULL,[Sex] [int] NULL,[Birthday] [datetime] NULL,[Mobile] [varchar](50) NULL,[OICQ] [varchar](50) NULL,[Email] [varchar](50) NULL,[ChangePasswordDate] [datetime] NULL,[OpenId] [int] NULL,[LogOnCount] [int] NULL,[FirstVisit] [datetime] NULL,[PreviousVisit] [datetime] NULL,[LastVisit] [datetime] NULL,[AuditStatus] [varchar](50) NULL,[AuditUserId] [varchar](50) NULL,[AuditUserName] [varchar](50) NULL,[AuditDateTime] [datetime] NULL,[Online] [int] NULL,[Remark] [varchar](200) NULL,[Enabled] [int] NULL,[SortCode] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [varchar](50) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [varchar](50) NULL,CONSTRAINT [PK_Base_User] PRIMARY KEY CLUSTERED ([UserId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Account'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Password'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Secretkey'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'RealName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名拼音' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Spell'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Sex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Birthday'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Mobile'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'OICQ'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改密码日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ChangePasswordDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单点登录标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'OpenId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LogOnCount'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'FirstVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'PreviousVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LastVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditStatus'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditDateTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在线' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Online'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Remark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Enabled'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User'GOALTER TABLE [dbo].[Base_User] ADD CONSTRAINT [DF_Base_User_Online] DEFAULT ((0)) FOR [Online]GOALTER TABLE [dbo].[Base_User] ADD CONSTRAINT [DF_Base_User_Enabled] DEFAULT ((1)) FOR [Enabled]GOALTER TABLE [dbo].[Base_User] ADD CONSTRAINT [DF_Base_User_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Base_User] ADD CONSTRAINT [DF_Base_User_CreateDate] DEFAULT (getdate()) FOR [CreateDate]GO（6）Com_Attachment资源附件信息表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_Attachment] Script Date: 10/16/ 14:47:15 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_Attachment]([FileID] [varchar](50) NOT NULL,[DataID] [varchar](50) NULL,[FileType] [varchar](500) NULL,[FileTitle] [nvarchar](200) NULL,[FileCover] [nvarchar](200) NULL,[FileMinCover] [nvarchar](200) NULL,[FileUrl] [nvarchar](200) NULL,[FileSize] [varchar](50) NULL,[FileSuffix] [varchar](50) NULL,[Remarks] [nvarchar](max) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,[FileIndexUrl] [nvarchar](500) NULL,[ContentKey] [nvarchar](500) NULL,[BrowseNum] [int] NULL,[CollectionNum] [int] NULL,[Integral] [int] NULL,CONSTRAINT [PK_Com_Attachment] PRIMARY KEY CLUSTERED ([FileID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附近ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'DataID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileTitle'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'封面' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileCover'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'封面缩略图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileMinCover'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileUrl'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件大小' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileSize'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件后缀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileSuffix'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'Remarks'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'解压后首页地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileIndexUrl'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键词' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ContentKey'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'BrowseNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收藏量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CollectionNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'积分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'Integral'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资源附件信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment'GOALTER TABLE [dbo].[Com_Attachment] ADD CONSTRAINT [DF_Com_Attachment_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Com_Attachment] ADD CONSTRAINT [DF__Com_Attac__Brows__4E88ABD4] DEFAULT ((0)) FOR [BrowseNum]GOALTER TABLE [dbo].[Com_Attachment] ADD CONSTRAINT [DF__Com_Attac__Colle__4F7CD00D] DEFAULT ((0)) FOR [CollectionNum]GOALTER TABLE [dbo].[Com_Attachment] ADD CONSTRAINT [DF__Com_Attac__Integ__5070F446] DEFAULT ((0)) FOR [Integral]GO（7）Com_Banner广告信息表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_Banner] Script Date: 10/16/ 14:47:52 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_Banner]([BannerID] [varchar](50) NOT NULL,[BannerType] [varchar](50) NULL,[BannerTitle] [nvarchar](200) NULL,[BannerCenter] [nvarchar](max) NULL,[BannerImg] [nvarchar](200) NULL,[BannerLink] [nvarchar](200) NULL,[State] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [varchar](50) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [varchar](50) NULL,CONSTRAINT [PK_Com_Banner] PRIMARY KEY CLUSTERED ([BannerID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerTitle'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerCenter'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerImg'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告列表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerLink'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告状态(1正常)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'State'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'Com_Banner', @value=N'广告信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner'GOALTER TABLE [dbo].[Com_Banner] ADD CONSTRAINT [DF_Com_Banner_State] DEFAULT ((1)) FOR [State]GOALTER TABLE [dbo].[Com_Banner] ADD CONSTRAINT [DF_Com_Banner_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Com_Banner] ADD CONSTRAINT [DF_Com_Banner_CreateDate] DEFAULT (getdate()) FOR [CreateDate]GO（9）Com_Article文章信息表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_Article] Script Date: 10/16/ 14:48:13 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_Article]([ArticleID] [varchar](50) NOT NULL,[ArticleType] [varchar](50) NULL,[ArticleTitle] [nvarchar](200) NULL,[ArticleSubTitle] [nvarchar](200) NULL,[Source] [varchar](50) NULL,[ArticleContent] [nvarchar](max) NULL,[BrowseNumber] [int] NULL,[GiveNum] [int] NULL,[Remarks] [nvarchar](max) NULL,[PicUrl] [nvarchar](200) NULL,[PutTime] [date] NULL,[OptionSet] [int] NULL,[State] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,CONSTRAINT [PK_Com_Article] PRIMARY KEY CLUSTERED ([ArticleID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleTitle'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章副标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleSubTitle'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'Source'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleContent'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'BrowseNumber'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点赞量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'GiveNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'Remarks'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'题图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'PicUrl'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'PutTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'选项设置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'OptionSet'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'State'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article'GOALTER TABLE [dbo].[Com_Article] ADD CONSTRAINT [DF_Com_Article_BrowseNumber] DEFAULT ((0)) FOR [BrowseNumber]GOALTER TABLE [dbo].[Com_Article] ADD CONSTRAINT [DF_Com_Article_GiveNum] DEFAULT ((0)) FOR [GiveNum]GOALTER TABLE [dbo].[Com_Article] ADD CONSTRAINT [DF_Icos_Article_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GO（10）Com_DownloadLog下载日志表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_DownloadLog] Script Date: 10/16/ 14:48:47 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_DownloadLog]([DownloadLogID] [varchar](50) NOT NULL,[DataID] [varchar](50) NULL,[Integral] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,CONSTRAINT [PK_Com_DownloadLog] PRIMARY KEY CLUSTERED ([DownloadLogID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下载ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DownloadLogID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DataID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用积分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'Integral'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOALTER TABLE [dbo].[Com_DownloadLog] ADD DEFAULT ((0)) FOR [DeleteMark]GO（11）OND_MessageReply评论信息表USE [SysDataBase]GO/****** Object: Table [dbo].[OND_MessageReply] Script Date: 10/16/ 14:49:14 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[OND_MessageReply]([MessageReplyID] [varchar](50) NOT NULL,[ParentID] [varchar](50) NULL,[DataID] [varchar](50) NULL,[MessageReplyCenter] [nvarchar](max) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[GiveNum] [int] NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,CONSTRAINT [PK_MessageReply] PRIMARY KEY CLUSTERED ([MessageReplyID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'评论ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'MessageReplyID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ParentID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'DataID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'评论内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'MessageReplyCenter'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点赞量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'GiveNum'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'留言评论信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply'GOALTER TABLE [dbo].[OND_MessageReply] ADD CONSTRAINT [DF__OND_Messa__Delet__5BE2A6F2] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[OND_MessageReply] ADD CONSTRAINT [DF_OND_MessageReply_GiveNum] DEFAULT ((0)) FOR [GiveNum]GO（12）Com_PayFor支付流水表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_PayFor] Script Date: 10/16/ 14:49:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_PayFor]([PayForID] [varchar](50) NOT NULL,[DataID] [varchar](50) NULL,[PayForContent] [nvarchar](50) NULL,[PayForType] [varchar](50) NULL,[PayForTime] [datetime] NULL,[PayForUrl] [nvarchar](200) NULL,[PayForState] [int] NULL,[Integral] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,CONSTRAINT [PK_Com_PayFor] PRIMARY KEY CLUSTERED ([PayForID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'DataID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForContent'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付凭证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForUrl'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付状态(0未支付,1已支付)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForState'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金币' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'Integral'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOALTER TABLE [dbo].[Com_PayFor] ADD CONSTRAINT [DF__Com_PayFo__PayFo__5812160E] DEFAULT ((0)) FOR [PayForState]GOALTER TABLE [dbo].[Com_PayFor] ADD CONSTRAINT [DF_Com_PayFor_Integral] DEFAULT ((0)) FOR [Integral]GOALTER TABLE [dbo].[Com_PayFor] ADD CONSTRAINT [DF__Com_PayFo__Delet__59063A47] DEFAULT ((0)) FOR [DeleteMark]GO（13）Com_Member会员信息表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_Member] Script Date: 10/16/ 14:50:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_Member]([MemberID] [varchar](50) NOT NULL,[Account] [varchar](50) NULL,[Password] [varchar](50) NULL,[Secretkey] [varchar](50) NULL,[RealName] [varchar](50) NULL,[Spell] [varchar](200) NULL,[Sex] [int] NULL,[Birthday] [datetime] NULL,[Mobile] [varchar](50) NULL,[OICQ] [varchar](50) NULL,[Email] [varchar](50) NULL,[ChangePasswordDate] [datetime] NULL,[OpenId] [int] NULL,[LogOnCount] [int] NULL,[FirstVisit] [datetime] NULL,[PreviousVisit] [datetime] NULL,[LastVisit] [datetime] NULL,[AuditStatus] [varchar](50) NULL,[AuditUserId] [varchar](50) NULL,[AuditUserName] [varchar](50) NULL,[AuditDateTime] [datetime] NULL,[Online] [int] NULL,[Remark] [varchar](200) NULL,[Enabled] [int] NULL,[SortCode] [int] NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [varchar](50) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [varchar](50) NULL,[PhotoUrl] [varchar](50) NULL,[MemberType] [int] NULL,[Integral] [int] NULL,[VerCode] [varchar](50) NULL,[State] [int] NULL,CONSTRAINT [PK_Com_Member] PRIMARY KEY CLUSTERED ([MemberID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'MemberID'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Account'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Password'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Secretkey'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'RealName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名拼音' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Spell'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Sex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Birthday'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Mobile'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'OICQ'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Email'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改密码日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ChangePasswordDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单点登录标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'OpenId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'LogOnCount'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'FirstVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'PreviousVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'LastVisit'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditStatus'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditDateTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在线' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Online'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Remark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Enabled'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'SortCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'PhotoUrl'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员类型（0普通会员，1VIP会员）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'MemberType'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金币' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Integral'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'VerCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态（0未激活，1正常使用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'State'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member'GOALTER TABLE [dbo].[Com_Member] ADD CONSTRAINT [DF_Com_Member_Online] DEFAULT ((0)) FOR [Online]GOALTER TABLE [dbo].[Com_Member] ADD CONSTRAINT [DF_Com_Member_Enabled] DEFAULT ((1)) FOR [Enabled]GOALTER TABLE [dbo].[Com_Member] ADD CONSTRAINT [DF_Com_Member_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GOALTER TABLE [dbo].[Com_Member] ADD CONSTRAINT [DF_Com_Member_CreateDate] DEFAULT (getdate()) FOR [CreateDate]GOALTER TABLE [dbo].[Com_Member] ADD DEFAULT ((0)) FOR [Integral]GOALTER TABLE [dbo].[Com_Member] ADD DEFAULT ((0)) FOR [State]GO（14）Com_Approve操作记录表USE [SysDataBase]GO/****** Object: Table [dbo].[Com_Approve] Script Date: 10/16/ 14:50:36 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Com_Approve]([ApproveId] [varchar](50) NOT NULL,[DataId] [varchar](50) NULL,[Action] [nvarchar](50) NULL,[ActionCode] [varchar](50) NULL,[Idea] [nvarchar](400) NULL,[DeleteMark] [int] NULL,[CreateDate] [datetime] NULL,[CreateUserId] [varchar](50) NULL,[CreateUserName] [nvarchar](200) NULL,[ModifyDate] [datetime] NULL,[ModifyUserId] [varchar](50) NULL,[ModifyUserName] [nvarchar](200) NULL,CONSTRAINT [PK_Com_Approve] PRIMARY KEY CLUSTERED ([ApproveId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批记录ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ApproveId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'DataId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批动作' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'Action'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动作编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ActionCode'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'Idea'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'DeleteMark'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyDate'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyUserId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyUserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve'GOALTER TABLE [dbo].[Com_Approve] ADD CONSTRAINT [DF_Com_Approve_DeleteMark] DEFAULT ((0)) FOR [DeleteMark]GO