SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Collect](
	[CollectID] [int] IDENTITY(1,1) NOT NULL,
	[UseID] [int] NULL,
	[UserID] [int] NULL,
	[InfoID] [bigint] NULL,
	[Title] [nvarchar](100) NULL,
	[Content] [nvarchar](max) NULL,
	[Url] [varchar](200) NULL,
	[CreateDate] [datetime] NULL CONSTRAINT [DF_Collect_CreateDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_Collect] PRIMARY KEY CLUSTERED 
(
	[CollectID] 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 [Collect] ON 

INSERT [Collect] ([CollectID], [UseID], [UserID], [InfoID], [Title], [Content], [Url], [CreateDate]) VALUES (1, 1, 1, 11111, N'	 三星正品国行,W999,S4', NULL, N'/item/635184781764423193', CAST(N'2013-11-16 19:36:45.087' AS DateTime))
SET IDENTITY_INSERT [Collect] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收藏自增长编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @level2type=N'COLUMN',@level2name=N'CollectID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用途编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @level2type=N'COLUMN',@level2name=N'UseID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @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'Collect', @level2type=N'COLUMN',@level2name=N'InfoID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @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'Collect', @level2type=N'COLUMN',@level2name=N'Content'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'url地址,可选' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @level2type=N'COLUMN',@level2name=N'Url'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收藏时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Collect', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
