/******  2012-12-22 更新 4.9-5.0 开始******/
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[e_signon]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [dbo].[e_signon] (
	[signkey] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[userurl] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
	[lasttime] [datetime] NULL 
) 
GO
/******e_eachedition*****/
alter table [dbo].[e_eachedition] ADD [litpic] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL,
[zoompic] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL
GO
UPDATE [dbo].[e_eachedition] SET [litpic] ='',[zoompic]=''
GO
/***e_setting加字段 isuserlogin***/
alter table [dbo].[e_setting] ADD [isuserlogin] [bit] NULL,[editor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
GO
UPDATE [dbo].[e_setting] SET isuserlogin=0,[editor]='tinymce' where id=1
GO
/******update data *****/
INSERT [dbo].[mvc_adminmenu] ([id], [classname], [classen], [classdes], [parentid], [depth], [parentpath], [childclass], [sortid], [isrefer], [referurl]) VALUES (94, N'单点登录设置', convert(text, N'' collate Chinese_PRC_CI_AS), N'', 90, 1, convert(text, N'0,90' collate Chinese_PRC_CI_AS), convert(text, N'94' collate Chinese_PRC_CI_AS), 4, 1, convert(text, N'SSO.aspx' collate Chinese_PRC_CI_AS))
GO

/******mvc_info*****/
alter table [dbo].[mvc_info] ADD [editer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[auditor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
GO
UPDATE [dbo].[mvc_info] SET [editer] ='',[auditor]=''
GO


