/******  2013-8-21更新 5.2--5.3 开始******/
GO
/***e_setting加字段 isfloat***/
alter table [dbo].[e_setting] ADD [isfloat] [bit] NULL
GO
UPDATE [dbo].[e_setting] SET isfloat=0 where id=1
GO
/******e_eachedition*****/
alter table [dbo].[e_eachedition] ADD [ismany] [bit] NULL
GO
UPDATE [dbo].[e_eachedition] SET [ismany]=0
GO

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mvc_adtype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[mvc_adtype] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[classname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[classen] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[classdes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[adwidth] [int] NULL ,
	[adheight] [int] NULL ,
	[sortid] [int] NULL 
) ON [PRIMARY] 
GO

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mvc_ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[mvc_ad] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[typeid] [int] NULL ,
	[adtitle] [nvarchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
	[adfile] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[adlink] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[hits] [int] NULL ,
	[addtime] [datetime] NULL 
) ON [PRIMARY]
GO
--SET IDENTITY_INSERT [dbo].[mvc_adtype] ON
INSERT [dbo].[mvc_adtype] ([classname], [classen], [classdes], [adwidth], [adheight], [sortid]) VALUES (N'首页漂浮广告左边', convert(text, N'sideleft' collate Chinese_PRC_CI_AS), N'', 165, 354, 1)
INSERT [dbo].[mvc_adtype] ([classname], [classen], [classdes], [adwidth], [adheight], [sortid]) VALUES (N'首页漂浮广告右边', convert(text, N'sideright' collate Chinese_PRC_CI_AS), N'', 165, 354, 2)
INSERT [dbo].[mvc_adtype] ([classname], [classen], [classdes], [adwidth], [adheight], [sortid]) VALUES (N'首页左边广告', convert(text, N'leftbottom' collate Chinese_PRC_CI_AS), N'', 202, 64, 3)
--SET IDENTITY_INSERT [dbo].[mvc_adtype] OFF
Go