SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Announcement](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](300) NULL,
	[Link] [varchar](100) NULL,
	[Content] [nvarchar](max) NULL,
	[StartDate] [datetime] NULL,
	[EndDate] [datetime] NULL,
	[Recommend] [int] NULL CONSTRAINT [DF_Announcement_Recommend]  DEFAULT ((0)),
	[Sequence] [int] NULL CONSTRAINT [DF_Announcement_Sequence]  DEFAULT ((10)),
	[Directory] [varchar](50) NULL,
	[Visit] [int] NULL CONSTRAINT [DF_Announcement_View]  DEFAULT ((1)),
	[Status] [int] NULL CONSTRAINT [DF_Announcement_Status]  DEFAULT ((1)),
	[Editor] [nvarchar](50) NULL,
	[CreateDate] [datetime] NULL CONSTRAINT [DF_Announcement_CreateDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_Announcement] 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 [Announcement] ON 

INSERT [Announcement] ([ID], [Title], [Link], [Content], [StartDate], [EndDate], [Recommend], [Sequence], [Directory], [Visit], [Status], [Editor], [CreateDate]) VALUES (2, N'sfdasldfa;fdj', N'', N'<p><u>dfsa</u></p><p><u></u>&nbsp;</p><p><u>s</u></p><p>&nbsp;</p><p>sa</p>', CAST(N'2013-08-15 09:59:24.053' AS DateTime), CAST(N'2013-08-15 09:59:24.053' AS DateTime), 0, 11, NULL, NULL, 1, N'Admin', CAST(N'2013-08-15 09:59:24.053' AS DateTime))
INSERT [Announcement] ([ID], [Title], [Link], [Content], [StartDate], [EndDate], [Recommend], [Sequence], [Directory], [Visit], [Status], [Editor], [CreateDate]) VALUES (3, N'国庆快乐', N'', N'<p><u>dfsa</u></p><p><u></u>&nbsp;</p><p><u>s国庆快乐国庆快乐国庆快乐国庆快乐国庆快乐</u></p><p>&nbsp;</p><p>sa</p>', CAST(N'2013-08-15 09:59:24.000' AS DateTime), CAST(N'2013-08-15 09:59:24.000' AS DateTime), 0, 11, NULL, 1, 1, N'Admin', CAST(N'2013-08-15 09:59:24.053' AS DateTime))
INSERT [Announcement] ([ID], [Title], [Link], [Content], [StartDate], [EndDate], [Recommend], [Sequence], [Directory], [Visit], [Status], [Editor], [CreateDate]) VALUES (4, N'改版', N'', N'<p><u>dfsa</u></p><p><u></u>&nbsp;</p><p><u>s</u></p><p>&nbsp;改版改版改版</p><p>sa</p>', CAST(N'2013-08-15 09:59:24.000' AS DateTime), CAST(N'2013-08-15 09:59:24.000' AS DateTime), 1, 11, NULL, 1, 1, N'Admin', CAST(N'2013-08-15 09:59:24.053' AS DateTime))
INSERT [Announcement] ([ID], [Title], [Link], [Content], [StartDate], [EndDate], [Recommend], [Sequence], [Directory], [Visit], [Status], [Editor], [CreateDate]) VALUES (5, N'sfdasldfa;fdj', N'', N'<p><u>dfsa</u></p><p><u></u>&nbsp;</p><p><u>s</u></p><p>&nbsp;</p><p>sa</p>', CAST(N'2013-08-15 09:59:24.053' AS DateTime), CAST(N'2013-08-15 09:59:24.053' AS DateTime), 0, 11, NULL, 1, 1, N'Admin', CAST(N'2013-08-15 09:59:24.053' AS DateTime))
INSERT [Announcement] ([ID], [Title], [Link], [Content], [StartDate], [EndDate], [Recommend], [Sequence], [Directory], [Visit], [Status], [Editor], [CreateDate]) VALUES (6, N'新版上线', N'', N'<p><u>dfsa</u></p><p><u></u>&nbsp;</p><p><u>s</u></p><p>&nbsp;</p><p>sa</p>', CAST(N'2013-08-15 09:59:24.000' AS DateTime), CAST(N'2013-08-15 09:59:24.000' AS DateTime), 0, 11, NULL, 1, 1, N'Admin', CAST(N'2013-08-15 09:59:24.053' AS DateTime))
SET IDENTITY_INSERT [Announcement] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'必填,公告标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'跳转连接,如果不为空将跳转到指定地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Link'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公告内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Content'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'起始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'StartDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'EndDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'推荐,置顶,0不推荐(默认),1推荐' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Recommend'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Sequence'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目录名称(用作url路由)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Directory'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态,1显示(默认),0隐藏' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编辑人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'Editor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Announcement', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
