SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Information](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[InfoID] [bigint] NULL CONSTRAINT [DF_Transaction_InfoID]  DEFAULT ((0)),
	[CategoryID] [int] NULL,
	[UserID] [int] NULL,
	[UserAccount] [varchar](20) NULL,
	[Title] [nvarchar](100) NULL,
	[Thumbnail] [varchar](200) NULL CONSTRAINT [DF_Information_Thumbnail]  DEFAULT (''),
	[UpdateDate] [datetime] NULL CONSTRAINT [DF_Transacation_UpdateDate]  DEFAULT (getdate()),
	[CreateDate] [datetime] NULL CONSTRAINT [DF_Transacation_CreateDate]  DEFAULT (getdate()),
	[IP] [varchar](50) NULL,
	[AreaID] [int] NULL,
	[Views] [int] NULL CONSTRAINT [DF_Transacation_Views]  DEFAULT ((1)),
	[Status] [int] NULL CONSTRAINT [DF_Transacation_Status]  DEFAULT ((2)),
	[Recommend] [int] NULL CONSTRAINT [DF_Transacation_Recommend]  DEFAULT ((0)),
 CONSTRAINT [PK_Transacation] 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]

GO
SET IDENTITY_INSERT [Information] ON 

INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (91, 635557640640733860, 25, 1, N'test', N'供应HRB400螺纹钢', N'/Upload/info/20150102/dc376f41b9684747b497a981c6babc60.jpg', CAST(N'2014-01-02 02:54:28.817' AS DateTime), CAST(N'2014-01-02 02:54:28.817' AS DateTime), N'58.220.2.130', 0, 2, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (92, 635557643106983139, 25, 1, N'test', N'供应莱钢三级螺纹钢Φ12(质量保证)', N'/Upload/info/20150102/a18e8fa32c5240b29e4b2df15e06d883.jpg', CAST(N'2014-01-02 02:54:28.817' AS DateTime), CAST(N'2014-01-02 02:54:28.817' AS DateTime), N'58.220.2.130', 0, 7, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (93, 635558136293481410, 25, 1, N'test', N'供应多种螺纹钢', N'/Upload/info/20150102/fec1a1940b4c4b9cba61b7edea1a7f7e.jpg', CAST(N'2014-01-02 02:54:28.817' AS DateTime), CAST(N'2014-01-02 02:54:28.817' AS DateTime), N'58.220.2.132', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (94, 635558140597157759, 25, 1, N'test', N'供应昆钢螺纹钢 昆明钢材批发', N'/Upload/info/20150102/be0e99dd00a7493796f03f971a13ab37.jpg', CAST(N'2014-03-05 16:47:44.873' AS DateTime), CAST(N'2014-03-05 16:47:44.873' AS DateTime), N'58.220.2.132', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (95, 635558142871467148, 25, 1, N'test', N'供应螺旋管厂/沈阳螺纹钢厂哪家好/沈阳圆钢', N'/Upload/info/20150102/79cf3827fe9e4e5ebd7d130c409c7a22.jpg', CAST(N'2014-03-05 16:47:44.873' AS DateTime), CAST(N'2014-03-05 16:47:44.873' AS DateTime), N'58.220.2.132', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (96, 635558144803680761, 25, 1, N'test', N'供应中安兴旺低合金板 船板 容器板 螺纹钢 锅炉板 圆钢 普板 中厚板 Z向板', N'/Upload/info/20150102/3c628bd5334b4b7f8742975c08f49691.jpg', CAST(N'2014-03-05 16:47:44.873' AS DateTime), CAST(N'2014-03-05 16:47:44.873' AS DateTime), N'58.253.238.242', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (97, 635558146304967214, 25, 1, N'test', N'大量批发厂标螺纹钢', N'/Upload/info/20150102/f087ba1ee5924b9b93354adb70b8271b.jpg', CAST(N'2014-03-05 16:47:44.873' AS DateTime), CAST(N'2014-03-05 16:47:44.873' AS DateTime), N'58.253.238.242', 0, 17, 1, 1)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (98, 635558148929583572, 25, 1, N'test', N'厂家供应GQ50直螺纹钢筋切断机 弯曲机 直销 欢迎选购', N'/Upload/info/20150102/3c3b7dc8ab36451cbf43886bc84ed5e5.jpg', CAST(N'2014-05-12 17:01:38.057' AS DateTime), CAST(N'2014-05-12 17:01:38.057' AS DateTime), N'58.253.238.242', 0, 2, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (99, 635558152008432894, 26, 1, N'test', N'120mm圆钢/建筑圆钢/普通圆钢/元钢/国标圆钢', N'/Upload/info/20150102/d947d3c5eae244cda49d546bc7ba760a.jpg', CAST(N'2014-05-12 17:01:38.057' AS DateTime), CAST(N'2014-05-12 17:01:38.057' AS DateTime), N'58.253.238.242', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (100, 635558153607396402, 26, 1, N'test', N'首钢Q235圆钢普通圆钢45#圆钢10#圆钢Q235合结圆钢', N'/Upload/info/20150102/e552f2cfece54338ace74f85e65bfb8b.jpg', CAST(N'2014-05-12 17:01:38.057' AS DateTime), CAST(N'2014-05-12 17:01:38.057' AS DateTime), N'59.44.152.110', 0, 3, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (102, 635558155713573040, 27, 1, N'test', N'供应崟海机械采石设备唐山模具钢 圆钢', N'/Upload/info/20150102/d5eda98027644beaa3c5606f375e1e36.jpg', CAST(N'2014-05-12 17:01:38.057' AS DateTime), CAST(N'2014-05-12 17:01:38.057' AS DateTime), N'59.44.152.110', 0, 9, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (103, 635558158168902595, 31, 1, N'test', N'供应丹阳一诺塑料贸易有限公司 通用塑料', N'/Upload/info/20150102/e38b8e3e58dc466eb6d457ef7ee7c43f.jpg', CAST(N'2014-05-12 17:01:38.057' AS DateTime), CAST(N'2014-05-12 17:01:38.057' AS DateTime), N'59.44.152.110', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (104, 635558160729369260, 31, 1, N'test', N'供应软胶硬胶通用塑料去纹增亮剂抗冲击剂', N'/Upload/info/20150102/7d071b7e822a42328b3cb6ff8721911c.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'59.44.152.110', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (105, 635558164169428471, 31, 1, N'test', N'供应广洋塑料PVC磨粉料PVC磨粉 环保料 通用塑料', N'/Upload/info/20150102/4e1cd0b5c15b47f8a3a56c5a86dbd3e4.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'59.126.147.161', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (106, 635558165505065610, 31, 1, N'test', N'聚乙烯蜡 聚乙烯蜡厂家 厂家直销 通用塑料', N'/Upload/info/20150102/04da9c5dc03a4447b1230b7ae317bc02.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'59.126.147.161', 0, 2, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (107, 635558194644148451, 31, 2, N'test2', N'供应启盛14改性塑料 通用塑料', N'/Upload/info/20150102/89e70b12a6054f30a93829ac57c901e5.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'59.126.147.161', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (108, 635558197009259995, 31, 2, N'test2', N'供应山西龙源博昌塑业有限公司0通用塑料', N'/Upload/info/20150102/cbd2b10af3e04ba998584efa215f282d.png', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'59.126.147.161', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (109, 635558199295704310, 32, 2, N'test2', N'供应长城：防老剂２６４、抗氧剂264、抗氧剂T501', N'/Upload/info/20150102/7e3140b938c2401e886659f9f91e3f36.png', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.206.239.195', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (110, 635558200954138279, 32, 2, N'test2', N'供应天然橡胶9', N'/Upload/info/20150102/994b1bc1d47b4caeb203f33cafca01ba.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.206.239.195', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (111, 635558203112251411, 32, 2, N'test2', N'供应龙溪50mm-20m 涤纶长丝平纹 天然橡胶消防水带天然橡胶水带 农用 机械 ', N'/Upload/info/20150102/ada7f26953e54e169049217f7f309cdf.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.206.239.195', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (112, 635558204648060665, 33, 2, N'test2', N'合成橡胶用沸石滤料', N'/Upload/info/20150102/dcbd73992e8a4e7a8e2be75358e1c9f6.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.206.239.195', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (113, 635558209937727216, 37, 2, N'test2', N'30S竹 30S人棉 春夏款舒适人棉面料', N'/Upload/info/20150102/bab9c21eb64b4daf9ac2ca5885eda8fd.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.214.118.170', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (114, 635558211427843475, 37, 2, N'test2', N'供应涤纶面料 人棉面料 面料加工', N'/Upload/info/20150102/e7f401e3daa04883acbbd958a68ab453.jpg', CAST(N'2014-06-18 17:21:18.043' AS DateTime), CAST(N'2014-06-18 17:21:18.043' AS DateTime), N'60.214.118.170', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (115, 635558212625834353, 37, 2, N'test2', N'数码印花加工 空气棉 人棉面料 全棉印花 旗子 裁片热转印加工', N'/Upload/info/20150102/f8f7cccfe39c4cae89b53597230397a9.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'60.214.118.170', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (116, 635558214218362317, 38, 2, N'test2', N'供应涤纶面料3', N'/Upload/info/20150102/be0202c72e844e9f9e8dbb5a2a657849.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'60.214.118.170', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (117, 635558215810613064, 38, 2, N'test2', N'供应涛辉麻布 纯亚麻布 亚麻棉布 箱包布料 涤纶面料 帆布面料亚麻面料', N'/Upload/info/20150102/97aec11885364f78a2cd352133124b37.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.133.51.6', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (118, 635558222824106620, 38, 3, N'test3', N'供应【品轩纺】高端雪纺面料 丝绸面料 涤纶面料厂家', N'/Upload/info/20150102/f9467d7e62f74943b8962c8347f00c58.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.133.51.6', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (119, 635558224266435904, 38, 3, N'test3', N'75D针织里布 复合涤纶面料 全涤里布', N'/Upload/info/20150102/aa3dadfd6345457d9629b3d7b8234dc8.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.133.51.6', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (120, 635558225865600457, 39, 3, N'test3', N'供应华广H203无弹蕾丝面料 针织面料', N'/Upload/info/20150102/cea90861451749f5a7fbbbb99175d3d2.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.133.51.6', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (121, 635558227417830425, 39, 3, N'test3', N'夏丹针织，针织面料(图)', N'/Upload/info/20150102/e767203723744e6c929bfc37edba0fd7.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.157.126.37', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (122, 635558228675734582, 39, 3, N'test3', N'面料 针织面料厂家', N'/Upload/info/20150102/c5854e2ec8024a729726d8706b6dfd3d.jpg', CAST(N'2014-06-22 18:47:47.707' AS DateTime), CAST(N'2014-06-22 18:47:47.707' AS DateTime), N'61.157.126.37', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (123, 635558230591615836, 42, 3, N'test3', N'供应 昆山大量 瓦楞包装纸箱/纸包装盒/纸包装箱 规格齐全 欢迎定制', N'/Upload/info/20150102/ebc02264772d49e88847b469416b47f0.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.157.126.37', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (124, 635558231842431763, 42, 3, N'test3', N'供应 纸包装', N'/Upload/info/20150102/91cc189ac4194ccfb788979e3956e240.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.156.35.2', 0, 2, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (125, 635558234045584814, 42, 3, N'test3', N'供应纸包装', N'/Upload/info/20150102/49bfac1bc87d46b5bb5210cd8c5316f0.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.156.35.2', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (126, 635558235295364316, 44, 3, N'test3', N'供应 立式真空包装机 外抽式真空包装机 汇利 食品包装机械 全自动真空包装机', N'/Upload/info/20150102/7178ccad096f405ea658d121fc1acd9a.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.156.35.2', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (127, 635558237022710915, 44, 3, N'test3', N'供应全自动给袋式包装机GD8 300A 正压开袋', N'/Upload/info/20150102/108c17646a10491a9f6ea36dfc9fc98c.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.156.35.2', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (128, 635558238802171795, 44, 3, N'test3', N'供应清大天宏 DXDF60EZ型食品粉末自动包装机', N'/Upload/info/20150102/31964322030548478798f806c35dcec6.jpg', CAST(N'2014-07-05 09:17:44.300' AS DateTime), CAST(N'2014-07-05 09:17:44.300' AS DateTime), N'61.163.165.250', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (129, 635558241063674826, 45, 4, N'test4', N'供应无纺布袋 购物袋 手提袋 礼品袋', N'/Upload/info/20150102/8db11d2a1d5c4b21b80488f71ed9c9ba.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.163.165.250', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (130, 635558242689574842, 45, 4, N'test4', N'厂家定制 纸袋 礼品袋 定制礼品袋 批发礼品袋', N'/Upload/info/20150102/010f1efc84c942639898584b55be26da.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.163.165.250', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (131, 635558245128911731, 45, 4, N'test4', N'供应H1300化妆袋化妆盒礼品袋', N'/Upload/info/20150102/95758f90f25b405ca15e30a723bc199c.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.163.165.250', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (132, 635558247069273320, 45, 4, N'test4', N'批量手机挂绳,证件绳,杯绳,礼品袋绳 低价批发 厂家直销', N'/Upload/info/20150102/5ebc6bf51ccd4f1cbf297894ca693cb4.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.163.165.250', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (133, 635558248414264322, 52, 4, N'test4', N'供应轴承', N'/Upload/info/20150102/c8c6c1d302d74b998fa5ac048e5c6aa6.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.184.192.42', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (134, 635558249520845722, 52, 4, N'test4', N'供应 慧聪网优质供货商 中用轴承商店 轴承 轴承 价格电议', N'/Upload/info/20150102/abcc31d7da824578b20acd1333456abb.jpg', CAST(N'2014-07-22 12:35:11.500' AS DateTime), CAST(N'2014-07-22 12:35:11.500' AS DateTime), N'61.184.192.42', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (135, 635558250975587675, 52, 4, N'test4', N'轴承 ABS齿圈 ABS齿圈厂家', N'/Upload/info/20150102/5e522e1b0a804080835e48f34e5f8337.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'61.184.192.42', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (136, 635558252141889742, 52, 4, N'test4', N'供应微机保护 微机保护 轴承电机 减速机 电动机 轴承机电 泉州厂家批发直销 ', N'/Upload/info/20150102/e2387314ceaf4fdfa8bcbaf24ffa3231.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'61.184.192.42', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (137, 635558253387802666, 52, 4, N'test4', N'供应XQ695轴承滑轮', N'/Upload/info/20150102/6d1f9254984441f398f0a0514a91faef.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'101.4.60.46', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (138, 635558255280271159, 60, 4, N'test4', N'脚踏剪板机', N'/Upload/info/20150102/62bd698e73f0444dbd50d3abe3173c14.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'101.4.60.46', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (139, 635558256806841427, 60, 4, N'test4', N'专业生产塑料拖链坦克链 ，进口原料工程塑料拖链现货标准品', N'/Upload/info/20150102/0e73b9664c584bf285a614b036631c86.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'101.4.60.46', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (140, 635558258433890002, 60, 1, N'test', N'供应剪板机厂家现货供应上海 杭州 苏州 无锡 嘉兴剪板机', N'/Upload/info/20150102/a6a6ea976f9d406f8ad764b992e740c4.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'101.4.60.46', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (141, 635558261869873912, 61, 1, N'test', N'供应泰新FP消防排烟风机', N'/Upload/info/20150102/4b41804c463c443e969e2fc47cbe167d.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'106.2.184.228', 0, 1, 1, 0)
INSERT [Information] ([ID], [InfoID], [CategoryID], [UserID], [UserAccount], [Title], [Thumbnail], [UpdateDate], [CreateDate], [IP], [AreaID], [Views], [Status], [Recommend]) VALUES (142, 635558263829909700, 61, 1, N'test', N'盛中SZ-A型低噪声前向多翼离心通风机工业风机', N'/Upload/info/20150102/51bd9a8516ae49d79e9afc02721bc956.jpg', CAST(N'2014-09-22 16:51:42.680' AS DateTime), CAST(N'2014-09-22 16:51:42.680' AS DateTime), N'106.2.184.228', 0, 1, 1, 0)
SET IDENTITY_INSERT [Information] OFF
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据表ID,主键,自增长编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'与各表相连的信息编号,必须唯一' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @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'Information', @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'Information', @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'Information', @level2type=N'COLUMN',@level2name=N'UserAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @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'Information', @level2type=N'COLUMN',@level2name=N'Thumbnail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据更新时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'UpdateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布者IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'IP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'Views'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息状态,1有效,2等待审核,3 审核失败,4删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'推荐状态,0无推荐(默认),1推荐置顶' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Information', @level2type=N'COLUMN',@level2name=N'Recommend'
GO
