CREATE TABLE [jcms_normal_javascript] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (50) NOT NULL ,
[Code] [varchar] (64) NOT NULL DEFAULT (''),
[ChannelId] [int] NOT NULL DEFAULT(0) ,
[ClassId] [int] NOT NULL DEFAULT(0) ,
[SelectNumber] [int] NOT NULL DEFAULT(0) ,
[TitleLen] [int] NOT NULL DEFAULT(0) ,
[JumbotLiCode] [varchar] (30) NOT NULL DEFAULT (''),
CONSTRAINT [PK_normal_javascript] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
alter table [jcms_module_soft] add [Points] [int] NULL
GO
UPDATE [jcms_module_soft] SET [Points]=0
GO
alter table [jcms_module_soft] add [SSize] [varchar] (20) NULL
GO
UPDATE [jcms_module_soft] SET [SSize]='未知'
GO
CREATE TABLE [jcms_module_soft_downlogs] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[ChannelId] [int] NOT NULL DEFAULT(0) ,
[UserId] [int] NOT NULL DEFAULT(0) ,
[SoftId] [int] NOT NULL DEFAULT(0) ,
[Points] [int] NOT NULL DEFAULT(0) ,
[DownTime] [datetime] NOT NULL DEFAULT (getdate()),
[DownIP] [nvarchar] (16) NULL ,
[DownDegree] [int] NOT NULL DEFAULT(0) ,
CONSTRAINT [PK_module_soft_downlogs] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
update [jcms_normal_user] set Sex=2 Where Sex=1
GO
update [jcms_normal_user] set Sex=1 Where Sex=0
GO
alter table [jcms_normal_user] add [ForumName] [nvarchar] (20) NULL
GO
alter table [jcms_normal_user] add [ForumPass] [nvarchar] (32) NULL
GO
CREATE TABLE [jcms_module_article_collitem] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (50) NOT NULL ,
[ChannelId] [int] NOT NULL DEFAULT(0) ,
[ClassId] [int] NOT NULL DEFAULT(0) ,
[WebName] [nvarchar] (50) NULL ,
[WebUrl] [nvarchar] (100) NULL ,
[ItemDemo] [nvarchar] (200) NULL ,
[ListStr] [nvarchar] (200) NULL ,
[LsString] [ntext] NULL ,
[LoString] [ntext] NULL ,
[HsString] [ntext] NULL ,
[HoString] [ntext] NULL ,
[TsString] [ntext] NULL ,
[ToString] [ntext] NULL ,
[CsString] [ntext] NULL ,
[CoString] [ntext] NULL ,
[NPsString] [ntext] NULL ,
[NPoString] [ntext] NULL ,
[AuthorStr] [nvarchar] (50) NULL ,
[SourceFrom] [nvarchar] (30) NOT NULL DEFAULT (''),
[Flag] [int] NOT NULL DEFAULT(0) ,
[Script_Iframe] [int] NOT NULL DEFAULT(0) ,
[Script_Object] [int] NOT NULL DEFAULT(0) ,
[Script_Script] [int] NOT NULL DEFAULT(0) ,
[Script_Div] [int] NOT NULL DEFAULT(0) ,
[Script_Table] [int] NOT NULL DEFAULT(0) ,
[Script_Span] [int] NOT NULL DEFAULT(0) ,
[Script_Img] [int] NOT NULL DEFAULT(0) ,
[Script_Font] [int] NOT NULL DEFAULT(0) ,
[Script_A] [int] NOT NULL DEFAULT(0) ,
[Script_Html] [int] NOT NULL DEFAULT(0) ,
[CollecNewsNum] [int] NOT NULL DEFAULT(0) ,
[SaveFiles] [int] NOT NULL DEFAULT(0) ,
[CollecOrder] [int] NOT NULL DEFAULT(0) ,
[ListWebEncode] [nvarchar] (50) NULL ,
[ContentWebEncode] [nvarchar] (50) NULL ,
CONSTRAINT [PK_module_article_collitem] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [jcms_module_article_collfilters] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[ChannelId] [int] NOT NULL DEFAULT(0) ,
[ItemId] [int] NOT NULL DEFAULT(0) ,
[Title] [nvarchar] (50) NULL ,
[Filter_Object] [int] NOT NULL DEFAULT(0) ,
[Filter_Type] [int] NOT NULL DEFAULT(0) ,
[Filter_Content] [ntext] NULL ,
[FisString] [ntext] NULL ,
[FioString] [ntext] NULL ,
[Filter_Rep] [ntext] NULL ,
[Flag] [int] NOT NULL DEFAULT(0) ,
[PublicTf] [int] NOT NULL DEFAULT(0) ,
CONSTRAINT [PK_module_article_collfilters] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [jcms_module_article_collhistory] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[ChannelId] [int] NOT NULL DEFAULT(0) ,
[ItemId] [int] NOT NULL DEFAULT(0) ,
[Title] [nvarchar] (100) NULL ,
[CollectDate] [datetime] NULL ,
[NewsUrl] [nvarchar] (200) NULL ,
[ResultStr] [nvarchar] (200) NULL ,
[Result] [int] NOT NULL DEFAULT(0) ,
CONSTRAINT [PK_module_article_collhistory] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
alter table [jcms_extends_placard] add [ForumName] [State] [int] NULL
GO
update [jcms_extends_placard] set [State]=1
GO
[责任编辑：jumbot]