SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [FriendLinks](
	[LinkID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryID] [int] NULL,
	[LinkName] [nvarchar](50) NULL,
	[LinkUrl] [varchar](100) NULL,
	[LogoUrl] [varchar](100) NULL,
	[LinkType] [int] NULL,
	[IsRecommend] [int] NULL CONSTRAINT [DF_FriendLinks_IsRecommend]  DEFAULT ((1)),
	[LinkStatus] [int] NULL CONSTRAINT [DF_FriendLinks_LinkStatus]  DEFAULT ((1)),
	[Remarks] [nvarchar](max) NULL,
	[LinkSort] [int] NULL CONSTRAINT [DF_FriendLinks_LinkSort]  DEFAULT ((0)),
 CONSTRAINT [PK_FriendLinks] PRIMARY KEY CLUSTERED 
(
	[LinkID] 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 [FriendLinks] ON 

INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (1, 1, N'百度', N'http://www.baidu.com', N'', 1, 2, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (4, 1, N'sdfasfa', N'http://www.soso.com', N'', 1, 2, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (5, 1, N'sdfsafdasdf', N'http://www.baidu.com', N'', 1, 2, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (6, 1, N'sfasfdasfd', N'http://www.baidu.com', N'', 1, 1, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (7, 1, N'dsafdasfasdfafa', N'http://www.baidu.com', N'', 1, 1, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (13, 1, N'dfsafsaf', N'http://sfasww.coms.com', N'', 1, 2, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (14, 1, N'wwwerqwer', N'http://www.com.cn', N'', 1, 1, 1, N'', 0)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (15, 1, N'碧秀软件', N'http://soft.bixiu.net', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (16, 1, N'搜狐', N'http://www.sohu.com', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (17, 1, N'新浪', N'http://www.sina.com.cn', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (18, 1, N'谷歌', N'http://www.google.com', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (19, 1, N'腾讯网', N'http://www.qq.com', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (20, 1, N'雅虎', N'http://www.yahoo.com', N'', 1, NULL, 1, N'', NULL)
INSERT [FriendLinks] ([LinkID], [CategoryID], [LinkName], [LinkUrl], [LogoUrl], [LinkType], [IsRecommend], [LinkStatus], [Remarks], [LinkSort]) VALUES (21, 1, N'淘宝网', N'http://www.taobao.com', N'', 1, NULL, 1, N'', NULL)
SET IDENTITY_INSERT [FriendLinks] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'友情连接表自增长编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'CategoryID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接URL' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站Logo地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LogoUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接类型,1文件字链接,2图片链接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否推荐,1推荐,2不推荐' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'IsRecommend'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接状态,1显示,2不显示,默认为1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'友情链接排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'FriendLinks', @level2type=N'COLUMN',@level2name=N'LinkSort'
GO
