SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Article](
	[ArticleID] [int] IDENTITY(1,1) NOT NULL,
	[Group] [int] NULL,
	[CategoryID] [int] NULL,
	[TopicID] [int] NULL,
	[UserID] [int] NULL CONSTRAINT [DF_Article_UserID_1]  DEFAULT ((0)),
	[Number] [bigint] NULL,
	[Title] [nvarchar](200) NULL,
	[Author] [nvarchar](50) NULL,
	[Source] [nvarchar](50) NULL,
	[Keywords] [nvarchar](200) NULL,
	[Description] [nvarchar](200) NULL,
	[Introduction] [nvarchar](max) NULL,
	[Content] [ntext] NULL,
	[Thumbnail] [varchar](200) NULL,
	[Pagination] [int] NULL,
	[PaginationWordsQuantity] [int] NULL,
	[Status] [int] NULL,
	[Recommend] [int] NULL,
	[Sequence] [int] NULL CONSTRAINT [DF_Article_Sequence]  DEFAULT ((0)),
	[Visit] [int] NULL CONSTRAINT [DF_Article_Visit]  DEFAULT ((1)),
	[Editor] [nvarchar](50) NULL,
	[Link] [varchar](100) NULL,
	[CreateDate] [datetime] NULL CONSTRAINT [DF_Article_CreateDate]  DEFAULT (getdate()),
	[UpdateDate] [datetime] NULL CONSTRAINT [DF_Article_UpdateDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_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] TEXTIMAGE_ON [PRIMARY]

GO
SET IDENTITY_INSERT [Article] ON 

INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (1, 1, 4, 0, 6, 0, N'sfasfsd', N'', N'', N'', N'', N'fffxxxx', N'fffffffff', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-14 22:00:04.820' AS DateTime), CAST(N'2013-10-14 22:00:04.820' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (2, 1, 4, 0, 6, 0, N'ff', N'', N'', N'', N'', N'd', N'sdf', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-14 22:06:53.810' AS DateTime), CAST(N'2013-10-14 22:06:53.810' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (3, 1, 4, 0, 6, 0, N'sdfasfas', N'', N'', N'', N'', N'ddd', N'ddd', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-14 22:09:50.650' AS DateTime), CAST(N'2013-10-14 22:09:50.647' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (4, 1, 4, 0, 6, 0, N'dff', N'ddd', N'dddd', N'dfsdfas', N'fsadf', N'dsfas', N'<p>asfasfsassdfsaf</p><p>as</p><p>df</p><p>asf</p><p>&nbsp;</p><p>asd</p><p>fas</p><p>&nbsp;</p>', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-14 22:24:20.517' AS DateTime), CAST(N'2013-10-14 22:24:20.517' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (5, 1, 4, 0, 6, 0, N'ffffff', N'ff', N'', N'', N'', N'asdfasdf', N'sdfasf', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-17 22:37:45.993' AS DateTime), CAST(N'2013-12-29 16:29:00.727' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (6, 1, 0, 0, 6, 0, N'ssxxxxxx', N'xx', N'', N'', N'', N'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx', N'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-17 22:38:02.197' AS DateTime), CAST(N'2013-12-29 16:21:33.660' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (7, 1, 4, 0, 6, 635177356906759812, N'dddd', N'xxx', N'xxx', N'asdfasdfasdf', N'asfd', N'sdfasdf', N'<p>ffffffffffffffffffffffffffffffffffffffffasd</p><p>fa</p><p>sfd</p><p>s</p><p>vd</p><p>as</p><p>v</p>', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-18 23:28:10.673' AS DateTime), CAST(N'2013-10-18 23:28:10.673' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (8, 1, 5, 0, 6, 635178871319262799, N'产品1', N'', N'', N'', N'', N'产品1产品1产品1产品1', N'<p>产品1产品1产品1产品1产品1产品1产品1产品1产品</p><p>1产品1产品1产品1产品1产品1产品1产品1产品1产品1产品1产品1产品1</p>', N'Upload/thumbnail/20131020/019b6e0911d14dec92b31302e6096348.jpg', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-20 17:32:11.927' AS DateTime), CAST(N'2013-10-20 17:57:32.393' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (9, 1, 5, 0, 6, 635178885371103149, N'紫色深情', N'', N'', N'', N'', N'', N'<p align="center">紫色深情</p>', N'Upload/thumbnail/20131020/4ff7bb0fb1364b5fb83593f4114786e1.jpg', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-20 17:55:37.110' AS DateTime), CAST(N'2013-10-20 17:55:37.110' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (10, 1, 5, 0, 6, 635178885804590578, N'橙色活力', N'', N'', N'', N'', N'', N'<p align="center">橙色活力</p>', N'Upload/thumbnail/20131020/e8bb83d0d4574a398b19c44d9c03e565.jpg', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-20 17:56:20.460' AS DateTime), CAST(N'2013-10-20 17:56:20.460' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (11, 1, 5, 0, 6, 635178886029999855, N'蓝色清爽', N'', N'', N'', N'', N'', N'xx', N'Upload/thumbnail/20131020/7f94481c88c34b87855333c9a3ea5c39.jpg', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-20 17:56:43.000' AS DateTime), CAST(N'2013-10-20 17:56:43.000' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (12, 1, 5, 0, 6, 635178886247004457, N'粉色浪漫', N'', N'', N'', N'', N'', N'', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-10-20 17:57:04.700' AS DateTime), CAST(N'2013-10-20 17:57:04.700' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (13, 1, 4, 0, 6, 635196170775999210, N'xx', N'', N'', N'', N'', N'', N'ssssddddddddddddddddddddddddd', N'', 0, 0, 3, 0, 0, 1, N'admin', N'', CAST(N'2013-11-09 18:04:37.600' AS DateTime), CAST(N'2013-11-09 18:07:15.387' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (14, 2, 1, 0, 0, 332333, N'eeeeeeeeeeee', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (15, 2, 1, 0, 0, 33234, N'efsfdsafsdf', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (16, 2, 1, 0, 0, 332333, N'shgjhgjfjhgfjgf', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (17, 2, 1, 0, 0, 332333, N'cvzxvxzvz', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (18, 2, 1, 0, 0, 332333, N'45454xgffd', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (19, 2, 1, 0, 0, 332333, N'jkhjkghkhjjh', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (20, 2, 1, 0, 0, 332333, N'dgsdgfdbbbbb', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (21, 2, 1, 0, 0, 332333, N'nbmvbmvnmv', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (22, 2, 1, 0, 0, 332333, N'erwetwer', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, NULL, NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-14 22:18:49.590' AS DateTime))
INSERT [Article] ([ArticleID], [Group], [CategoryID], [TopicID], [UserID], [Number], [Title], [Author], [Source], [Keywords], [Description], [Introduction], [Content], [Thumbnail], [Pagination], [PaginationWordsQuantity], [Status], [Recommend], [Sequence], [Visit], [Editor], [Link], [CreateDate], [UpdateDate]) VALUES (23, 2, 1, 0, 0, 332333, N'xxxxxxxxxx', N'we', N'we', N'eeeee', N'rrrrr', N'wwww', N'wwww', N'Upload/thumbnail/20131020/49224f2c06d34b11b896ddbd792eb5e3.jpg', 0, 0, 3, 0, 0, 1, N'admin', NULL, CAST(N'2013-12-14 22:18:49.590' AS DateTime), CAST(N'2013-12-29 17:10:40.413' AS DateTime))
SET IDENTITY_INSERT [Article] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自定义组或模块,此字段为隐含字段,适应一个网站有不同的类似文章功能的需求,可为null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'Group'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属用户,0不属任何用户(默认)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章自定义唯一编号,可以为空' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'Number'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序,默认为0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'Sequence'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'访问/浏览量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'Visit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'跳转链接,如果不为空,则使用指定的链接地址,默认为空' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Article', @level2type=N'COLUMN',@level2name=N'Link'
GO
