SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [SiteConfig](
	[ConfigID] [int] NOT NULL CONSTRAINT [DF_Config_ConfigID]  DEFAULT ((1)),
	[SiteName] [nvarchar](50) NULL,
	[DomainName] [varchar](100) NULL,
	[Logo] [varchar](500) NULL,
	[SiteTitle] [nvarchar](500) NULL,
	[Keywords] [nvarchar](500) NULL,
	[Description] [nvarchar](500) NULL,
	[Copyright] [nvarchar](500) NULL,
	[RecordNo] [varchar](200) NULL,
	[StatisticalCode] [varchar](500) NULL,
	[UploadPath] [varchar](20) NULL,
	[Template] [varchar](50) NULL,
	[MobileTemplate] [varchar](50) NULL,
	[MobileDomainName] [varchar](100) NULL,
	[AllowVisit] [int] NULL CONSTRAINT [DF_Config_AllowVisit]  DEFAULT ((1)),
	[LoginRelease] [int] NULL CONSTRAINT [DF_Config_LoginRelease]  DEFAULT ((1)),
	[AutomaticAuditInformation] [int] NULL CONSTRAINT [DF_Config_AutomaticAuditInformation]  DEFAULT ((0)),
	[AutomaticAuditUser] [int] NULL CONSTRAINT [DF_Config_AutomaticAuditUser]  DEFAULT ((1)),
	[EmailService] [int] NULL CONSTRAINT [DF_Config_EmailService]  DEFAULT ((1)),
	[IPSource] [int] NULL CONSTRAINT [DF_Config_IPSource]  DEFAULT ((0)),
	[AllowVisitArea] [nvarchar](100) NULL,
	[VerificationCodeStyle] [varchar](50) NULL CONSTRAINT [DF_SiteConfig_VerificationCodeStyle]  DEFAULT ('digit'),
	[SingleSignOn] [varchar](50) NULL CONSTRAINT [DF_SiteConfig_SingleSignOn]  DEFAULT ('local'),
 CONSTRAINT [PK_Config] PRIMARY KEY CLUSTERED 
(
	[ConfigID] 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
INSERT [SiteConfig] ([ConfigID], [SiteName], [DomainName], [Logo], [SiteTitle], [Keywords], [Description], [Copyright], [RecordNo], [StatisticalCode], [UploadPath], [Template], [MobileTemplate], [MobileDomainName], [AllowVisit], [LoginRelease], [AutomaticAuditInformation], [AutomaticAuditUser], [EmailService], [IPSource], [AllowVisitArea], [VerificationCodeStyle], [SingleSignOn]) VALUES (1, N'碧秀分类网', N'http://soft.bixiu.net', N'/Templates/blue/images/common_logo.png', N'碧秀分类网', N'碧秀分类网碧秀分类网', N'碧秀分类网碧秀分类网碧秀分类网碧秀分类网碧秀分类网', N'碧秀分类网', N'备案号:沪ICP备1002001   增值电信业务许可证:沪-001', N' <script type="text/javascript" src="http://tajs.qq.com/stats?sId=39883228" charset="UTF-8"></script> ', NULL, N'blue', N'mobile', N'', 1, 1, 1, 1, 1, 0, N'北京市', N'digit', N'local')
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'SiteName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'站点域名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'DomainName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Logo地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'Logo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'SiteTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO关键词' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'Keywords'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SEO描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版权信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'Copyright'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备案号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'RecordNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'统计代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'StatisticalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上传文件夹根路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'UploadPath'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前使用的模板' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'Template'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'移动端访问的模板(如果为空则与pc端相同)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'MobileTemplate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'识别要访问移动端网站的域名(如果为空,则不支持)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'MobileDomainName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许访问网站,1允许(默认),0关闭网站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'AllowVisit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录发布信息,1是(默认),0否' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'LoginRelease'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动审核发布的信息,1自动,0手动(默认)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'AutomaticAuditInformation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动审核用户注册信息,1自动(默认),0手动' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'AutomaticAuditUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开启邮件服务(启用后网站需要配置邮件服务器才能使用),1开启(默认),0关闭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'EmailService'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ip数据获取源,(0 QQ纯真数据库,1淘宝Api)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'IPSource'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'允许访问的城市,多个城市用逗号分隔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'AllowVisitArea'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证码风格(digit数字,digitchar字母和数字)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'VerificationCodeStyle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单点登录(默认local本地,ucenter)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SiteConfig', @level2type=N'COLUMN',@level2name=N'SingleSignOn'
GO
