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

asp.net(c#)网上商城BrnShop1.9升级至2.1升级说明（非官方版本）
主要描述在数据库方面进行升级（使用前请参照网上商城BrnShop1.9升级至2.1升级说明（非官方版本仅提供技术交流）的使用协议）

BrnShop1.9正式版本

/****** Object:  Table [dbo].[bsp_banners]    Script Date: 12/09/2014 14:07:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [bsp_banners](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[starttime] [datetime] NOT NULL,
	[endtime] [datetime] NOT NULL,
	[isshow] [tinyint] NOT NULL,
	[title] [nvarchar](100) NOT NULL,
	[img] [nvarchar](250) NOT NULL,
	[url] [nvarchar](250) NOT NULL,
	[displayorder] [int] NOT NULL,
 CONSTRAINT [PK_bsp_banners] 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
CREATE NONCLUSTERED INDEX [starttime_endtime_isshow] ON [bsp_banners]
(
	[starttime] ASC,
	[endtime] ASC,
	[isshow] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bannerid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @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'bsp_banners', @level2type=N'COLUMN',@level2name=N'starttime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'endtime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否展示' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'isshow'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @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'bsp_banners', @level2type=N'COLUMN',@level2name=N'img'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @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'bsp_banners', @level2type=N'COLUMN',@level2name=N'displayorder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'banner表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners'
GO
SET IDENTITY_INSERT [bsp_banners] ON
INSERT [bsp_banners] ([id], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (1, CAST(0x0000A35100B595F0 AS DateTime), CAST(0x0000A4D700B595F0 AS DateTime), 1, N'火爆促销', N'fr_1412061404492825858.jpg', N'/', 5)
INSERT [bsp_banners] ([id], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (4, CAST(0x0000A385017AA854 AS DateTime), CAST(0x0000A4D6017AA854 AS DateTime), 1, N'火爆促销', N'fr_1412061404419541666.jpg', N'/', 6)
INSERT [bsp_banners] ([id], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (5, CAST(0x0000A3EB0148AB74 AS DateTime), CAST(0x0000A5580148AB74 AS DateTime), 1, N'火爆促销', N'fr_1412061405306289506.jpg', N'/', 0)
INSERT [bsp_banners] ([id], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (6, CAST(0x0000A3EB0148CD70 AS DateTime), CAST(0x0000A5540148CD70 AS DateTime), 1, N'火爆促销', N'fr_1412061404554409380.jpg', N'/', 0)
SET IDENTITY_INSERT [bsp_banners] OFF

BrnShop2.1正式版本

/****** Object:  Table [dbo].[bsp_banners]    Script Date: 01/13/2015 10:11:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [bsp_banners](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[type] [tinyint] NOT NULL,
	[starttime] [datetime] NOT NULL,
	[endtime] [datetime] NOT NULL,
	[isshow] [tinyint] NOT NULL,
	[title] [nvarchar](100) NOT NULL,
	[img] [nvarchar](250) NOT NULL,
	[url] [nvarchar](250) NOT NULL,
	[displayorder] [int] NOT NULL,
 CONSTRAINT [PK_bsp_banners] 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
CREATE NONCLUSTERED INDEX [type_starttime_endtime_isshow] ON [bsp_banners]
(
	[type] ASC,
	[starttime] ASC,
	[endtime] ASC,
	[isshow] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bannerid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型(0代表PC,1代表手机)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开始时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'starttime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'endtime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否展示' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'isshow'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @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'bsp_banners', @level2type=N'COLUMN',@level2name=N'img'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'链接地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @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'bsp_banners', @level2type=N'COLUMN',@level2name=N'displayorder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'banner表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners'
GO
SET IDENTITY_INSERT [bsp_banners] ON
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (1, 0, CAST(0x0000A35100B595F0 AS DateTime), CAST(0x0000A4D700B595F0 AS DateTime), 1, N'火爆促销', N'fr_1412061404492825858.jpg', N'/', 5)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (4, 0, CAST(0x0000A385017AA854 AS DateTime), CAST(0x0000A4D6017AA854 AS DateTime), 1, N'火爆促销', N'fr_1412061404419541666.jpg', N'/', 6)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (5, 0, CAST(0x0000A3EB0148AB74 AS DateTime), CAST(0x0000A5580148AB74 AS DateTime), 1, N'火爆促销', N'fr_1412061405306289506.jpg', N'/', 0)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (6, 0, CAST(0x0000A3EB0148CD70 AS DateTime), CAST(0x0000A5540148CD70 AS DateTime), 1, N'火爆促销', N'fr_1412061404554409380.jpg', N'/', 0)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (7, 1, CAST(0x0000A40700AEA434 AS DateTime), CAST(0x0000A6E400AEA434 AS DateTime), 1, N'特大促销', N'fr_1412201036420464063.jpg', N'/', 0)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (8, 1, CAST(0x0000A40700AEEF34 AS DateTime), CAST(0x0000A6DD00AEEF34 AS DateTime), 1, N'特大促销', N'fr_1412201037096779867.jpg', N'/', 0)
INSERT [bsp_banners] ([id], [type], [starttime], [endtime], [isshow], [title], [img], [url], [displayorder]) VALUES (9, 1, CAST(0x0000A40700AF0B54 AS DateTime), CAST(0x0000A6E400AF0B54 AS DateTime), 1, N'特大促销', N'fr_1412201037338523694.jpg', N'/', 0)
SET IDENTITY_INSERT [bsp_banners] OFF

其中差异内容如图

差异内容有：

1.有[type]列

2.非聚合索引名称

3.执行增加扩展属性

4.数据插入

更新方法：

ALTER TABLE [bsp_banners]
  ADD [type] [tinyint]
  GO
  UPDATE [bsp_banners]
  SET [type] = 0	-- 默认为PC端
  GO
  ALTER TABLE [bsp_banners]
  ALTER COLUMN [type] [tinyint] NOT NULL	--
  GO
  CREATE NONCLUSTERED INDEX [type_starttime_endtime_isshow] ON [bsp_banners]
(
	[type] ASC,
	[starttime] ASC,
	[endtime] ASC,
	[isshow] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型(0代表PC,1代表手机)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'bsp_banners', @level2type=N'COLUMN',@level2name=N'type'

时间： 2024-03-06 09:07:57

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

数据库篇之[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

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

asp.net(c#)网上商城BrnShop1.9升级至2.1升级说明(非官方版本) 主要描述在数据库方面进行升级(使用前请参照网上商城BrnShop1.9升级至2.1升级说明(非官方版本仅提供技术交流)的使用协议) 针对1.9版本中的数据库插入,本人认为在升级的过程中可以不必去理会.(个人建议而以)

网上商城BrnShop1.9升级至2.1升级说明（非官方版本仅提供技术交流）

开源Asp.Net MVC网上商城BrnShop1.9正式版本升级至开源Asp.Net MVC网上商城BrnShop2.1正式版本的非官方说明文档,如有任何异议请回复或是私信沟通. 升级前的说明: 1.此文档旨在为开源系统提供交流 2.升级的文件备份与数据库备份,如因此引起的不必要麻烦.本人不负任何直接责任或是间接责任. 写此文档的说明 1.官方没有提供便捷升级的包以及相关文件 2.官方没有提供提供升级说明网上商城BrnShop1.9升级至2.1升级说明(非官方版本仅提供技术交流) 1.数据库

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

数据库篇之[bsp_advertpositions]数据表主要描述在数据库方面进行升级(使用前请参照网上商城BrnShop1.9升级至2.1升级说明(非官方版本仅提供技术交流)的使用协议) 主要看下[bsp_advertpositions]两个版本之间的升级差异如下图这次升级就比较简单直接插入相关的数据即可 SET IDENTITY_INSERT [bsp_advertpositions] ON INSERT [bsp_advertpositions] ([adposid], [title

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

数据库篇之[bsp_favorites]数据表差异如图: SET IDENTITY_INSERT [bsp_favorites] ON INSERT [bsp_favorites] ([recordid], [uid], [pid], [state], [addtime]) VALUES (9, 1, 46, 0, CAST(0x0000A3FC00F2D9AD AS DateTime)) SET IDENTITY_INSERT [bsp_favorites] OFF

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

文件差异如图: 更新语句如下: GO ALTER TABLE [bsp_gifts] ADD [pid] [int] GO UPDATE [bsp_gifts] SET [pid]=0 --请更改为你商品库里有的ID即可 GO ALTER TABLE [bsp_gifts] ALTER COLUMN [pid] [int] NOT NULL GO CREATE NONCLUSTERED INDEX [pid] ON [bsp_gifts] ( [pid] ASC )WITH (PAD_INDEX

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

文件差异更新方法如下 1.增加列 2.更新列值 3.修改列不为空 4.执行新的扩展属性语句如下: GO ALTER TABLE [bsp_orders] ADD [isreview] [tinyint] GO UPDATE [bsp_orders] SET [isreview]=0 GO ALTER TABLE [bsp_orders] ALTER COLUMN [isreview] [tinyint] NOT NULL GO EXEC sys.sp_addextendedproperty

vs2010-用VS2010打开sdf数据库文件中的数据表时提示找不到指定模块

问题描述用VS2010打开sdf数据库文件中的数据表时提示找不到指定模块解决方案 VS没有安装正确,重新安装下看看

怎样把一个datagridview表中的数据存为一个数据库中的一个数据表？

问题描述如题....在线等..... 解决方案解决方案二:从它的数据源datatable直接循环构成insert语句即可解决方案三:SqlCommandBuilderSCB=newSqlCommandBuilder(dataAdapter1);dataAdapter1.Update(dgv1.Tables[0]);解决方案四:注意要定义变量dataAdapter1,ds1dgv要绑定ds1.Tables[0]SqlCommandBuilderSCB=newSqlCommandBuilder(