INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)站点首页' , 2 , 'system' , 'index' , 0 , 'system_index.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)文章频道首页' , 2 , 'article' , 'channel' , 0 , 'article_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)文章列表' , 2 , 'article' , 'class' , 0 , 'article_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)文章内容页' , 2 , 'article' , 'content' , 0 , 'article_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)下载频道首页' , 2 , 'soft' , 'channel' , 0 , 'soft_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)下载列表页' , 2 , 'soft' , 'class' , 0 , 'soft_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)下载内容页' , 2 , 'soft' , 'content' , 0 , 'soft_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)图片频道首页' , 2 , 'photo' , 'channel' , 0 , 'photo_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)图片栏目页' , 2 , 'photo' , 'class' , 0 , 'photo_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)图片内容页' , 2 , 'photo' , 'content' , 0 , 'photo_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)视频频道首页' , 2 , 'video' , 'channel' , 0 , 'video_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)视频栏目页' , 2 , 'video' , 'class' , 0 , 'video_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(js版)视频内容页' , 2 , 'video' , 'content' , 0 , 'video_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)站点首页' , 3 , 'system' , 'index' , 0 , 'system_index.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)文章频道首页' , 3 , 'article' , 'channel' , 0 , 'article_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)文章列表' , 3 , 'article' , 'class' , 0 , 'article_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)文章内容页' , 3 , 'article' , 'content' , 0 , 'article_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)下载频道首页' , 3 , 'soft' , 'channel' , 0 , 'soft_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)下载列表页' , 3 , 'soft' , 'class' , 0 , 'soft_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)下载内容页' , 3 , 'soft' , 'content' , 0 , 'soft_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)图片频道首页' , 3 , 'photo' , 'channel' , 0 , 'photo_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)图片栏目页' , 3 , 'photo' , 'class' , 0 , 'photo_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)图片内容页' , 3 , 'photo' , 'content' , 0 , 'photo_content.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)视频频道首页' , 3 , 'video' , 'channel' , 0 , 'video_channel.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)视频栏目页' , 3 , 'video' , 'class' , 0 , 'video_class.htm' )
INSERT INTO [jcms_normal_template] (Title,pId,Type,sType,IsDefault,Source) values('v2009(html版)视频内容页' , 3 , 'video' , 'content' , 0 , 'video_content.htm' )
INSERT INTO [jcms_normal_templateproject] (Title,Info,Dir,isDefault) values('v2009(js版)' , '基本不用ajax' , 'v2009_2' , 0 )
INSERT INTO [jcms_normal_templateproject] (Title,Info,Dir,isDefault) values('v2009(html版)' , '基本不用ajax' , 'v2009_3' , 0 )
CREATE TABLE [jcms_normal_special] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (100) NULL ,
[Info] [nvarchar] (200) NULL ,
[Source] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_special] WITH NOCHECK ADD CONSTRAINT [PK__normal_special] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]
GO
CREATE TABLE [jcms_normal_specialcontent] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (100) NULL ,
[sId] [int] NOT NULL ,
[ChannelId] [int] NOT NULL ,
[ContentId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_specialcontent] WITH NOCHECK ADD CONSTRAINT [PK__normal_specialcontent] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]
GO
alter table [jcms_normal_user] add [Points] [int] NULL
GO
UPDATE [jcms_normal_user] SET [Points]=0
GO
alter table [jcms_normal_class] add [Number] [nvarchar] (10) NULL
GO
UPDATE [jcms_normal_class] SET [Number]=''
GO
CREATE TABLE [jcms_normal_masterlogs] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[MasterId] [int] NOT NULL ,
[OperInfo] [nvarchar] (200) NULL ,
[OperTime] [datetime] NULL ,
[OperIP] [nvarchar] (15) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_masterlogs] WITH NOCHECK ADD CONSTRAINT [PK__normal_masterlogs] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]
GO
alter table [jcms_normal_channel] add [ClassDepth] [int] NULL
GO
UPDATE [jcms_normal_channel] SET [ClassDepth]=4
GO
alter table [jcms_normal_modules] add [SearchFieldValues] [nvarchar] (200) NULL
GO
alter table [jcms_normal_modules] add [SearchFieldTexts] [nvarchar] (200) NULL
GO
UPDATE [jcms_normal_modules] SET [SearchFieldValues]='title,summary',[SearchFieldTexts]='标题,简介'
GO
alter table [jcms_normal_channel] add [IsHtml] [int] NULL
GO
UPDATE [jcms_normal_channel] SET [IsHtml]=1
GO
CREATE TABLE [jcms_normal_skins] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (30) NULL ,
[Source] [nvarchar] (50) NULL ,
[BodyWidth] [int] NULL ,
[LeftWidth] [int] NULL ,
[RightWidth] [int] NULL ,
[TitleColor] [nvarchar] (10) NULL ,
[BorderColor] [nvarchar] (10) NULL ,
[TintBackground] [nvarchar] (10) NULL ,
[DarkBackground] [nvarchar] (10) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_skins] WITH NOCHECK ADD CONSTRAINT [PK__normal_skins] PRIMARY KEY CLUSTERED ([Id]) ON [PRIMARY]
GO
INSERT INTO [jcms_normal_skins] (Title,Source,BodyWidth,LeftWidth,RightWidth,TitleColor,BorderColor,TintBackground,DarkBackground) values(N'浅蓝色宽屏' , N'blue1002' , 1002 , 252 , 740 , N'#00599B' , N'#AACCEE' , N'#C5E5FF' , N'#316395')
INSERT INTO [jcms_normal_skins] (Title,Source,BodyWidth,LeftWidth,RightWidth,TitleColor,BorderColor,TintBackground,DarkBackground) values(N'浅蓝色中屏' , N'blue0912' , 912 , 222 , 680 , N'#00599B' , N'#AACCEE' , N'#C5E5FF' , N'#316395')
INSERT INTO [jcms_normal_skins] (Title,Source,BodyWidth,LeftWidth,RightWidth,TitleColor,BorderColor,TintBackground,DarkBackground) values(N'浅蓝色窄屏' , N'blue0788' , 788 , 178 , 600 , N'#00599B' , N'#AACCEE' , N'#C5E5FF' , N'#316395')
alter table [jcms_normal_template] add [SkinId] [int] NULL
GO
UPDATE [jcms_normal_template] SET [SkinId]=1
GO
[责任编辑：jumbot]