alter table [ArticleCategory] ADD [SEOTitle] string;

alter table [ArticleInfo] ADD [SEOTitle] string;
alter table [ArticleInfo] ADD [ArticlePicture] string;
alter table [ArticleInfo] ADD [Address] string;
alter table [ArticleInfo] drop [ParentName];

alter table [CaseInfo] ADD [IsRom] int;
alter table [CaseInfo] drop [ParentName];
alter table [CaseInfo] ADD [articleid] int;
alter table [CaseInfo] ADD [CaseName] string;

alter table [DownLoadInfo] drop [ParentName];

alter table [FQAInfo] ADD [AccessNumber] int;
alter table [FQAInfo] ADD [Description] string;

alter table [JobInfo] ADD [Keywords] string;
alter table [JobInfo] ADD [OrderNumber] int;

alter table [LinkInfo] ADD [OrderNumber] int;
CREATE TABLE Message
    (ID AUTOINCREMENT,
    [Name] string,
    [Status] int,
    [Expend1] string,
    [Expend2] string,
    [Expend3] string,
    [Expend4] string,
    [Expend5] string,
    [Expend6] string,
    [Expend7] string,
    [Expend8] string,
    [Expend9] string,
    [Expend10] string,
    [Expend11] string,
    [Expend12] string,
    [Expend13] string,
    [Expend14] string,
    [Expend15] string,
    [Expend16] string,
    [Expend17] string,
    [Expend18] string,
    [Expend19] string,
    [Expend20] string,
    [Expend21] string,
    [Expend22] string,
    [Expend23] string,
    [CreateDate] date);

alter table [NewsCategory] ADD [SEOTitle] string;

alter table [NewsInfo] ADD [SEOTitle] string;
alter table [NewsInfo] drop [ParentName];


CREATE TABLE Notice
    (ID AUTOINCREMENT,
    [SysID] INTEGER,
    [Title] string,
    [Status] INTEGER);

alter table [PictureInfo] ADD [EnTitle] string;
alter table [PictureInfo] drop  [ParentName] string;

alter table [ProductCategory] ADD [CategoryIcon2] nvarchar(100);
alter table [ProductCategory] ADD [SEOTitle] string;
alter table [ProductCategory] ADD [Content] string;
alter table [ProductCategory] ADD [IsRom] int;
alter table [ProductCategory] ADD [SonNumber] int;
alter table [ProductCategory] ADD [SonCategory] int;
alter table [ProductCategory] ADD [Keywords] nvarchar(100);
alter table [JobCategory] ADD [Keywords] nvarchar(100);
alter table [CaseCategory] ADD [Keywords] nvarchar(100);
alter table [NewsCategory] ADD [Keywords] nvarchar(100);
alter table [ArticleCategory] ADD [Keywords] nvarchar(100);

alter table [ProductInfo] ADD [ProductContent1] Text;
alter table [ProductInfo] ADD [ProductContent2] Text;
alter table [ProductInfo] ADD [ProductContent3] Text;
alter table [ProductInfo] ADD [ProductContent4] Text;
alter table [ProductInfo] ADD [ProductContent5] Text;
alter table [ProductInfo] ADD [ProductContent6] Text;
alter table [ProductInfo] ADD [ProductContent7] Text;
alter table [ProductInfo] ADD [ProductContent8] Text;
alter table [ProductInfo] ADD [ProductPicTure6] Text;
alter table [ProductInfo] ADD [ProductPicTure7] Text;
alter table [ProductInfo] ADD [ProductPicTure8] Text;
alter table [ProductInfo] ADD [ProductPicTure9] Text;
alter table [ProductInfo] ADD [ProductPicTure10] Text;
alter table [ProductInfo] ADD [SEOTitle] string;
alter table [ProductInfo] ADD [TextBox] string;
alter table [ProductInfo] ADD [TextBox1] string;
alter table [ProductInfo] ADD [TextBox2] string;
alter table [ProductInfo] ADD [Address] string;
alter table [ProductInfo] drop [Categoryid];
alter table [ProductInfo] drop [CategoryName];

CREATE TABLE ProductHotWords
    (ID AUTOINCREMENT,
    [ParentID] int,
    [LevelID] int,
    [Status] int,
    [Name] string,
    [OrderNumber] int,
    [CateID] int);

CREATE TABLE Property
    (ID AUTOINCREMENT,
    [ProID] int,
    [HotID] int,
    [HotName] string);

alter table [VideoInfo] ADD [IsHot] int;
alter table [VideoInfo] ADD [IsNew] int;
Alter TABLE [JobInfo] Alter COLUMN Salary string;
Alter TABLE [JobInfo] Alter COLUMN OrderNumber int;
update [JobInfo] set [OrderNumber]=0;
Alter TABLE [ProductInfo] Alter COLUMN Areaid int;
Alter TABLE [ProductInfo] Alter COLUMN Brandid int;

alter table [ArticleCategory] ADD [ModifyDate] date;
update [ArticleCategory] set [ModifyDate]=date();
alter table [ArticleCategory] ADD [ModifyName] string;

alter table [ArticleInfo] ADD [ModifyDate] date;
update [ArticleInfo] set [ModifyDate]=date();
alter table [ArticleInfo] ADD [ModifyName] string;

alter table [NewsCategory] ADD [ModifyDate] date;
update [NewsCategory] set [ModifyDate]=date();
alter table [NewsCategory] ADD [ModifyName] string;

alter table [NewsInfo] ADD [ModifyDate] date;
update [NewsInfo] set [ModifyDate]=date();
alter table [NewsInfo] ADD [ModifyName] string;

alter table [ProductCategory] ADD [ModifyDate] date;
update [ProductCategory] set [ModifyDate]=date();
alter table [ProductCategory] ADD [ModifyName] string;

alter table [ProductInfo] ADD [ModifyDate] date;
update [ProductInfo] set [ModifyDate]=date();
alter table [ProductInfo] ADD [ModifyName] string;

alter table [CaseCategory] ADD [ModifyDate] date;
update [CaseCategory] set [ModifyDate]=date();
alter table [CaseCategory] ADD [ModifyName] string;

alter table [CaseInfo] ADD [ModifyDate] date;
update [CaseInfo] set [ModifyDate]=date();
alter table [CaseInfo] ADD [ModifyName] string;

alter table [VideoInfo] ADD [videoid] string;
alter table [CaseCategory] ADD [CategoryIcon2] string;