数据库篇之[bsp_adverts]数据表-网上商城BrnShop1.9升级至2.1升级说明（非官方版本）

asp.net(c#)网上商城BrnShop1.9升级至2.1升级说明（非官方版本） 

数据库篇之[bsp_adverts]数据表
主要描述在数据库方面进行升级（使用前请参照网上商城BrnShop1.9升级至2.1升级说明（非官方版本仅提供技术交流）的使用协议）

主要看下[bsp_adverts]两个版本之间的升级差异如下图

这次升级就比较简单

直接插入相关的数据即可

SET IDENTITY_INSERT [bsp_adverts] ON
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (72, 0, 34, 1, CAST(0x0000A40700C60F84 AS DateTime), CAST(0x0000A6E500C60F84 AS DateTime), 3, 1, N'手机一层广告位左侧', N'/', N'ad_1412201201199038431.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (73, 0, 34, 1, CAST(0x0000A40700C62F28 AS DateTime), CAST(0x0000A6EB00C62F28 AS DateTime), 1, 1, N'手机一层广告位右下', N'/', N'ad_1412201201594621057.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (74, 0, 34, 1, CAST(0x0000A40700C655D4 AS DateTime), CAST(0x0000A6DD00C655D4 AS DateTime), 2, 1, N'手机一层广告位右上', N'/', N'ad_1412201202184881940.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (75, 0, 35, 1, CAST(0x0000A40700C68CE8 AS DateTime), CAST(0x0000A6DE00C68CE8 AS DateTime), 3, 1, N'手机二层广告位左上', N'/', N'ad_1412201203308643336.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (76, 0, 35, 1, CAST(0x0000A40700C6C3FC AS DateTime), CAST(0x0000A6DD00C6C3FC AS DateTime), 2, 1, N'手机二层广告位左下', N'/', N'ad_1412201203526375790.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (77, 0, 35, 1, CAST(0x0000A40700C6DDC4 AS DateTime), CAST(0x0000A57100C6DDC4 AS DateTime), 1, 1, N'手机二层广告位右侧', N'/', N'ad_1412201204125747193.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (78, 0, 36, 1, CAST(0x0000A40700C6FD68 AS DateTime), CAST(0x0000A6E500C6FD68 AS DateTime), 0, 1, N'手机三层广告位', N'/', N'ad_1412201208588830952.jpg', N'', N'', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (79, 0, 37, 1, CAST(0x0000A40700C72C48 AS DateTime), CAST(0x0000A6E400C72C48 AS DateTime), 0, 1, N'手机四层广告位', N'/', N'ad_1412201205528674557.png', N'特价美食', N'吃货聚集地', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (80, 0, 37, 1, CAST(0x0000A40700C781D4 AS DateTime), CAST(0x0000A6E400C781D4 AS DateTime), 0, 1, N'手机四层广告位', N'/', N'ad_1412201206375560118.png', N'特价美食', N'吃货聚集地', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (81, 0, 37, 1, CAST(0x0000A40700C7A4FC AS DateTime), CAST(0x0000A6DD00C7A4FC AS DateTime), 0, 1, N'手机四层广告位', N'/', N'ad_1412201207066766774.png', N'特价美食', N'吃货聚集地', N'', N'', N'')
INSERT [bsp_adverts] ([adid], [clickcount], [adposid], [state], [starttime], [endtime], [displayorder], [type], [title], [url], [body], [extfield1], [extfield2], [extfield3], [extfield4], [extfield5]) VALUES (82, 0, 37, 1, CAST(0x0000A40700C7C4A0 AS DateTime), CAST(0x0000A6DE00C7C4A0 AS DateTime), 0, 1, N'手机四层广告位', N'/', N'ad_1412201207310680725.png', N'特价美食', N'吃货聚集地', N'', N'', N'')
SET IDENTITY_INSERT [bsp_adverts] OFF