alter table [jcms_normal_user] add [IsWriter] [int] NULL
GO
UPDATE [jcms_normal_user] SET [IsWriter]=0
GO
alter table [jcms_normal_user] add [Languages] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [StudyWay] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [MobileTel] [nvarchar] (11) NULL
GO
alter table [jcms_normal_user] add [CardBank] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [CardNumber] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [AdminId] [int] NULL
GO
UPDATE [jcms_normal_user] SET [AdminId]=0
GO
alter table [jcms_normal_user] add [AdminName] [nvarchar] (20) NULL
GO
alter table [jcms_normal_user] add [AdminPass] [nvarchar] (32) NULL
GO
alter table [jcms_normal_user] add [AdminFolder] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [Setting] [nvarchar] (3000) NULL
GO
alter table [jcms_normal_user] add [LastTime2] [datetime] NULL
GO
alter table [jcms_normal_user] add [LastIp2] [nvarchar] (15) NULL
GO
alter table [jcms_normal_user] add [Cookiess] [nvarchar] (10) NULL
GO
alter table [jcms_normal_user] add [AdminState] [int] NULL
GO
UPDATE [jcms_normal_user] SET [AdminState]=0
GO

INSERT INTO [jcms_normal_usergroup] (GroupName,setting,IsLogin,UserTotal) Values('管理用户','1,1,1,0|23,1,10,10,1,0,1,1,100,1,1,100,1,1,100,',1,0)

DELETE FROM [jcms_normal_user] WHERE UserName='jumbot'
INSERT INTO [jcms_normal_user] (UserName,UserPass,Sex,Email,[Group],QQ,BirthDay,Login,Points,IsWriter,AdminId,AdminName,AdminPass,AdminFolder,AdminState,Question,Answer,Setting,State) values('jumbot','a07728f35499635b',0,'jumbot114@126.com',5,'4259024','1979-11-04',1,50000,0,1,'jumbot','469e80d32c0559f8','/',1,'初始答案为123','123',',,',1)

---------2009-5-9
alter table [jcms_normal_user] add [IDType] [int] NULL
GO
alter table [jcms_normal_user] add [IDCard] [nvarchar] (30) NULL
GO
alter table [jcms_normal_user] add [WorkUnit] [nvarchar] (100) NULL
GO
alter table [jcms_normal_user] add [Address] [nvarchar] (100) NULL
GO
alter table [jcms_normal_user] add [ZipCode] [nvarchar] (10) NULL
GO
alter table [jcms_normal_user] add [Telephone] [nvarchar] (20) NULL
GO
alter table [jcms_normal_user] add [IsVIP] [int] NULL
GO
UPDATE [jcms_normal_user] SET [IsVIP]=0
GO
alter table [jcms_normal_user] add [VIPTime] [datetime] NULL
GO
alter table [jcms_normal_user] add [Integral] [int] NULL
GO
UPDATE [jcms_normal_user] SET [Integral]=0
GO
alter table [jcms_normal_user] add [MailSign] [nvarchar] (64) NULL
GO
alter table [jcms_normal_user] add [GraduateFrom] [nvarchar] (50) NULL
GO
alter table [jcms_normal_user] add [CardUserName] [nvarchar] (20) NULL
GO

CREATE TABLE [jcms_normal_user_logs] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [UserId] [int] NOT NULL ,
 [OperInfo] [nvarchar] (200) NULL ,
 [OperType] [int] NULL ,
 [OperTime] [datetime] NULL ,
 [OperIP] [nvarchar] (15) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_logs] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_logs] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_user_apply] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [UserId] [int] NOT NULL ,
 [ApplyInfo] [nvarchar] (200) NULL ,
 [ApplyType] [int] NULL ,
 [ApplyTime] [datetime] NULL ,
 [ApplyIP] [nvarchar] (15) NULL ,
 [ApplyNumber] [int] NULL,
 [MailSign] [nvarchar] (64) NULL,
 [Checked] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_apply] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_apply] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_user_friends] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [UserId] [int] NOT NULL ,
 [AddDate] [datetime] NULL ,
 [FriendId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_friends] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_friends] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_user_message] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (50) NULL ,
 [Content] [ntext] NULL ,
 [SendIP] [nvarchar] (15) NULL ,
 [SendUserId] [int] NOT NULL ,
 [ReceiveUserId] [int] NOT NULL ,
 [ReceiveUserName] [nvarchar] (20) NULL ,
 [AddDate] [datetime] NULL ,
 [State] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_message] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_message] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

alter table [jcms_normal_channel] add [DefaultThumbs] [int] NULL
GO
UPDATE [jcms_normal_channel] SET [DefaultThumbs]=0
GO

alter table [jcms_normal_channel] add [IsPost] [int] NULL
GO
UPDATE [jcms_normal_channel] SET [IsPost]=0
GO

CREATE TABLE [jcms_normal_user_favorite] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (150) NULL ,
 [ModuleType] [nvarchar] (20) NULL ,
 [ChannelId] [int] NOT NULL ,
 [ContentId] [int] NOT NULL ,
 [AddDate] [datetime] NULL ,
 [UserId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_favorite] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_favorite] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (50) NULL ,
 [Img] [nvarchar] (150) NULL ,
 [Proclaim] [nvarchar] (200) NULL ,
 [JoinPower] [int] NULL ,
 [ViewPower] [int] NULL ,
 [CloseApply] [int] NULL ,
 [SortId] [int] NULL ,
 [MemberTotal] [int] NULL ,
 [UpdateTime] [datetime] NULL ,
 [UserId] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag_member] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [UserId] [int] NOT NULL ,
 [MTagId] [int] NOT NULL ,
 [Power] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag_member] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag_member] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag_thread] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (100) NULL ,
 [Content] [ntext] NULL ,
 [MTagId] [int] NOT NULL ,
 [IsGood] [int] NULL ,
 [IsHead] [int] NULL ,
 [AddTime] [datetime] NULL ,
 [ReplyCount] [int] NULL ,
 [UserId] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag_thread] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag_thread] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag_thread_reply] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [Content] [nvarchar] (1000) NULL ,
 [MTagId] [int] NOT NULL ,
 [ThreadId] [int] NOT NULL ,
 [AddTime] [datetime] NULL ,
 [UserId] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag_thread_reply] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag_thread_reply] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag_sort] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (100) NULL ,
 [Info] [nvarchar] (200) NULL ,
 [State] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag_sort] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag_sort] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

INSERT INTO [jcms_normal_mtag_sort] (Title,Info,State) values('自由联盟','自由联盟',1)
INSERT INTO [jcms_normal_mtag_sort] (Title,Info,State) values('兴趣联盟','兴趣联盟',1)
INSERT INTO [jcms_normal_mtag_sort] (Title,Info,State) values('技术交流','技术交流',1)
INSERT INTO [jcms_normal_mtag_sort] (Title,Info,State) values('协同合作','协同合作',1)

CREATE TABLE [jcms_normal_user_notice] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (50) NULL ,
 [Content] [nvarchar] (250) NULL ,
 [NoticeType] [nvarchar] (16) NULL ,
 [UserId] [int] NOT NULL ,
 [AddDate] [datetime] NULL ,
 [State] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_user_notice] WITH NOCHECK ADD CONSTRAINT [PK__normal_user_notice] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_mtag_thread_reply] (
 [Id] [bigint] IDENTITY (1, 1) NOT NULL ,
 [Content] [nvarchar] (1000) NULL ,
 [MTagId] [int] NOT NULL ,
 [ThreadId] [int] NOT NULL ,
 [AddTime] [datetime] NULL ,
 [UserId] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_mtag_thread_reply] WITH NOCHECK ADD CONSTRAINT [PK__normal_mtag_thread_reply] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_page] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (20) NULL ,
 [SId] [int] NULL ,
 [Source] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_page] WITH NOCHECK ADD CONSTRAINT [PK__normal_page] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

INSERT INTO [jcms_normal_page] (Title,SId,Source) values('关于我们',1,'index.html')
INSERT INTO [jcms_normal_page] (Title,SId,Source) values('本站服务',1,'service.html')
INSERT INTO [jcms_normal_page] (Title,SId,Source) values('广告合作',1,'adver.html')
INSERT INTO [jcms_normal_page] (Title,SId,Source) values('联系方式',1,'contactus.html')
INSERT INTO [jcms_normal_page] (Title,SId,Source) values('支付方式',1,'payment.html')

CREATE TABLE [jcms_normal_page_sort] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (20) NULL ,
 [Info] [nvarchar] (200) NULL ,
 [Dir] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_page_sort] WITH NOCHECK ADD CONSTRAINT [PK__normal_page_sort] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

INSERT INTO [jcms_normal_page_sort] (Title,Info,Dir) values('本站介绍','','about')

CREATE TABLE [jcms_normal_pointscard] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [CardNumber] [nvarchar] (16) NULL ,
 [CardPassword] [nvarchar] (32) NULL ,
 [UserId] [int] NULL ,
 [Points] [int] NOT NULL,
 [LimitedDate] [datetime] NULL ,
 [ActiveTime] [datetime] NULL ,
 [ActiveIP] [nvarchar] (15) NULL ,
 [State] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_pointscard] WITH NOCHECK ADD CONSTRAINT [PK__normal_pointscard] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

CREATE TABLE [jcms_normal_pointscard_sort] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (50) NULL ,
 [Points] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [jcms_normal_pointscard_sort] WITH NOCHECK ADD CONSTRAINT [PK__normal_pointscard_sort] PRIMARY KEY  CLUSTERED ([Id])  ON [PRIMARY]
GO

INSERT INTO [jcms_normal_pointscard_sort] (Title,Points) values('50元=>50点',50)
INSERT INTO [jcms_normal_pointscard_sort] (Title,Points) values('100元=>100点',100)
INSERT INTO [jcms_normal_pointscard_sort] (Title,Points) values('200元=>200点',200)
INSERT INTO [jcms_normal_pointscard_sort] (Title,Points) values('500元=>500点',500)
INSERT INTO [jcms_normal_pointscard_sort] (Title,Points) values('1000元=>1000点',1000)

alter table [jcms_normal_extends] add [BaseTable] [nvarchar] (50) NULL
GO
CREATE TABLE [jcms_normal_templatecontentli] (
 [Id] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [nvarchar] (50) NOT NULL ,
 [Code] [varchar] (30) NOT NULL DEFAULT (''),
 [Fields] [text] NOT NULL DEFAULT ('') ,
 [OrderBy] [varchar] (20) NOT NULL DEFAULT (''),
 [IsTop] [int] NOT NULL DEFAULT(0) ,
 [IsImg] [int] NOT NULL DEFAULT(0) ,
 [TitleLen] [int] NOT NULL DEFAULT(0) ,
 [SummaryLen] [int] NOT NULL DEFAULT(0) ,
 [DateFormat] [varchar] (20) NOT NULL DEFAULT (''),
 [Repeat] [text] NOT NULL DEFAULT ('') ,
 [Content] [text] NOT NULL DEFAULT ('') ,
 CONSTRAINT [PK_normal_templatecontentli] PRIMARY KEY CLUSTERED
 (
  [Id]
 ) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO