SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [SingleArticle](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Alias] [varchar](50) NULL,
	[Group] [int] NULL CONSTRAINT [DF_SingleArticle_Group]  DEFAULT ((0)),
	[Title] [nvarchar](100) NULL,
	[Keywords] [nvarchar](100) NULL,
	[Description] [nvarchar](200) NULL,
	[Introduction] [nvarchar](500) NULL,
	[Content] [text] NULL,
	[Editor] [nvarchar](50) NULL,
	[Source] [nvarchar](50) NULL,
	[Thumbnail] [varchar](200) NULL,
	[Pagination] [int] NULL CONSTRAINT [DF_SingleArticle_Pagination]  DEFAULT ((0)),
	[PaginationWordsQuantity] [int] NULL,
	[UpdateDate] [datetime] NULL CONSTRAINT [DF_SingleArticle_UpdateDate]  DEFAULT (getdate()),
	[CreateDate] [datetime] NULL CONSTRAINT [DF_SingleArticle_CreateDate]  DEFAULT (getdate()),
	[Status] [int] NULL CONSTRAINT [DF_SingleArticle_Status]  DEFAULT ((1)),
	[Template] [varchar](100) NULL,
 CONSTRAINT [PK_SingleArticle] PRIMARY KEY CLUSTERED 
(
	[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] TEXTIMAGE_ON [PRIMARY]

GO
SET IDENTITY_INSERT [SingleArticle] ON 

INSERT [SingleArticle] ([ID], [Alias], [Group], [Title], [Keywords], [Description], [Introduction], [Content], [Editor], [Source], [Thumbnail], [Pagination], [PaginationWordsQuantity], [UpdateDate], [CreateDate], [Status], [Template]) VALUES (2, N'home', 1, N'关于我们', N'd33', N'223xx', N'112dfasfa', N'<p>21213xxxsdf</p><p>&nbsp;sdf</p><p>dsfs</p><p>fs</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>sa</p>', N'Admin', NULL, NULL, 0, NULL, CAST(N'2014-12-21 15:59:59.630' AS DateTime), NULL, 1, N'article/detail.html')
INSERT [SingleArticle] ([ID], [Alias], [Group], [Title], [Keywords], [Description], [Introduction], [Content], [Editor], [Source], [Thumbnail], [Pagination], [PaginationWordsQuantity], [UpdateDate], [CreateDate], [Status], [Template]) VALUES (4, N'Contact', 1, N'联系我们', N'fsaf', N'fsaf', N'asfsa', N'<p>联系我们</p><p>联系我们</p><p>&nbsp;</p><p>&nbsp;</p><p>联系我们</p><p>&nbsp;</p>', N'Admin', NULL, NULL, 0, NULL, CAST(N'2013-12-25 22:52:52.490' AS DateTime), CAST(N'2013-06-24 21:54:06.750' AS DateTime), 1, N'article/detail.html')
INSERT [SingleArticle] ([ID], [Alias], [Group], [Title], [Keywords], [Description], [Introduction], [Content], [Editor], [Source], [Thumbnail], [Pagination], [PaginationWordsQuantity], [UpdateDate], [CreateDate], [Status], [Template]) VALUES (5, N'message', 1, N'建议意见', N'建议意见', N'建议意见', N'', N'', N'Admin', NULL, NULL, 0, NULL, CAST(N'2013-12-29 14:57:23.903' AS DateTime), CAST(N'2013-06-24 21:54:23.247' AS DateTime), 1, N'article/message.html')
INSERT [SingleArticle] ([ID], [Alias], [Group], [Title], [Keywords], [Description], [Introduction], [Content], [Editor], [Source], [Thumbnail], [Pagination], [PaginationWordsQuantity], [UpdateDate], [CreateDate], [Status], [Template]) VALUES (6, N'Privacy', 1, N'免责声明', N'', N'', N'', N'免责声明', N'Admin', NULL, NULL, NULL, NULL, CAST(N'2013-12-29 14:55:58.047' AS DateTime), CAST(N'2013-06-25 22:06:00.330' AS DateTime), 1, N'article/detail.html')
SET IDENTITY_INSERT [SingleArticle] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SingleArticle', @level2type=N'COLUMN',@level2name=N'Source'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缩略图地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SingleArticle', @level2type=N'COLUMN',@level2name=N'Thumbnail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分页方式,0不分页(默认值),1手动分页,分页标记符:[NextPage],2自动分页' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SingleArticle', @level2type=N'COLUMN',@level2name=N'Pagination'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自动分页时的字符数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SingleArticle', @level2type=N'COLUMN',@level2name=N'PaginationWordsQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板,如果为空使用默认模板' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SingleArticle', @level2type=N'COLUMN',@level2name=N'Template'
GO
