# 增加表 带 . 的表名语句 被忽略
CREATE TABLE `ls_revolvingpics` (		`ID` int( 4 ) NOT NULL AUTO_INCREMENT ,		`Pic` varchar( 120 ) DEFAULT NULL ,		`Text` text,	`Num` int( 4 ) DEFAULT NULL ,		`enable` int( 1 ) NOT NULL ,		PRIMARY KEY ( `ID` ) 		) ENGINE = MYISAM DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC ;

CREATE TABLE `ls_mantain` (`ID` int( 4 ) NOT NULL AUTO_INCREMENT ,`adminName` varchar( 16 ) NOT NULL ,`adminPwd` char( 32 ) NOT NULL ,`adminTime` date NOT NULL ,`userName` varchar( 20 ) DEFAULT NULL ,PRIMARY KEY ( `ID` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 ROW_FORMAT = DYNAMIC ;

CREATE TABLE `ls_4fix`.`ls_ver` (`ID` INT( 8 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`lastVerdate` INT( 26 ) NULL ,`verDateTime` DATETIME NULL ,`ver` VARCHAR( 16 ) NULL ,`memo` VARCHAR( 36 ) NULL ,INDEX ( `lastVerdate` , `verDateTime` ) ) ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `ls_prospec` (  `ID` int(11) NOT NULL AUTO_INCREMENT,  `productID` int(11) NOT NULL,  `specName` varchar(36) NOT NULL,  `specValue` varchar(256) DEFAULT NULL,  `Num` int(11) NOT NULL,  `enable` tinyint(1) NOT NULL,  PRIMARY KEY (`ID`),  UNIQUE KEY `ID` (`ID`),  KEY `productID` (`productID`)) ENGINE=MyISAM  DEFAULT CHARSET=utf32 AUTO_INCREMENT=19 ;


# 增加字段
ALTER TABLE `ls_products` ADD `automationGif` TINYINT( 1 ) NULL COMMENT '动画GIF标志，1代表动画GIF' AFTER `productID` 
ALTER TABLE `ls_products` ADD `showOnHome` TINYINT( 1 ) NULL COMMENT '显示在首页' AFTER `productID`
ALTER TABLE `ls_products` ADD `AdditionalAttributes` TINYINT( 4 ) NULL DEFAULT '0' COMMENT '组合属性' AFTER `productID` 
ALTER TABLE `ls_products` ADD `No` TINYINT( 3 ) NULL DEFAULT '0' AFTER `productID`
ALTER TABLE `ls_products` ADD `addProLink` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '主菜单中的Products链接' AFTER `productID` 
ALTER TABLE `ls_products` ADD `addNewProLink` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '主菜单中的NewProducts链接' AFTER `productID` 
ALTER TABLE `ls_products` ADD `canshu` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '参数' AFTER `productID` 
ALTER TABLE `ls_products` ADD `productTitle` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '产品title' AFTER `productID` 
ALTER TABLE `ls_products` ADD `productKeywords` VARCHAR( 170 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '产品mate Keywords' AFTER `productID`
ALTER TABLE `ls_products` ADD `productDescription` VARCHAR( 240 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '产品mateDescription' AFTER `productID` 
ALTER TABLE `ls_products` ADD `hits` INT( 12 ) NULL COMMENT '点击次数' AFTER `Num` 
ALTER TABLE `ls_config` ADD `tel2` VARCHAR( 24 ) NULL AFTER `tel` ,ADD `tel3` VARCHAR( 24 ) NULL AFTER `tel2` ,ADD `tel4` VARCHAR( 24 ) NULL AFTER `tel3` 
ALTER TABLE `ls_config` ADD `email2` VARCHAR( 32 ) NULL AFTER `email` ,ADD `email3` VARCHAR( 36 ) NULL AFTER `email2` ,ADD `email4` VARCHAR( 36 ) NULL AFTER `email3` 
ALTER TABLE `ls_config` ADD `MSN2` VARCHAR( 36 ) NULL AFTER `MSN` ,ADD `MSN3` VARCHAR( 36 ) NULL  AFTER `MSN2` ,ADD `MSN4` VARCHAR( 36 ) NULL AFTER `MSN3` 
ALTER TABLE `ls_config` ADD `skype` VARCHAR( 36 ) NULL AFTER `website` ,ADD `skype2` VARCHAR( 36 ) NULL AFTER `skype` ,ADD `skype3` VARCHAR( 36 ) NULL AFTER `skype2` ,ADD `skype4` VARCHAR( 36 ) NULL AFTER `skype3` 
ALTER TABLE `ls_config` ADD `templates` VARCHAR( 20 ) NULL COMMENT '模板文件' AFTER `bottomMenu` 
ALTER TABLE `ls_menu` ADD `subjectPic` VARCHAR( 46 ) NULL COMMENT '本页主题图' AFTER `argument` 
ALTER TABLE `ls_menu` ADD `description` TEXT NULL COMMENT '页面描述' AFTER `menuLink` 
ALTER TABLE `ls_article` ADD `subCateName` VARCHAR( 36 ) NULL COMMENT '类别，三级' AFTER `cateName` 
ALTER TABLE `ls_download` ADD `cateName` VARCHAR( 36 ) NOT NULL COMMENT '分类，默认空' AFTER `ID` 
ALTER TABLE `ls_users` ADD `userWeb` VARCHAR( 48 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'http://' AFTER `userEmail` ;
ALTER TABLE `ls_links` ADD `cateName` VARCHAR( 24 ) NULL COMMENT '分类' AFTER `linkTitle` 
ALTER TABLE `ls_users` ADD `usercompany` VARCHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `userRealName` ;
ALTER TABLE `ls_products` ADD `AdditionalAttributesClassPro` TINYINT( 1 ) NOT NULL COMMENT 'ClassPro标志' AFTER `AdditionalAttributes` 
ALTER TABLE `ls_products` ADD `reserve1` INT( 8 ) NULL COMMENT '备用1' AFTER `waterMark` ,
ADD `reserve2` VARCHAR( 48 ) NULL COMMENT '备用2' AFTER `reserve1` ,
ADD `reserve3` TEXT NULL COMMENT '备用3' AFTER `reserve2` 




# 其他 query 操作, 忽略 insert into  from
ALTER TABLE `ls_revolvingpics` COMMENT = '主页流动图 片 '
ALTER TABLE `ls_config` CHANGE `bottomMenu` `bottomMenu` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
INSERT INTO `ls_mantain` SELECT * FROM `ls_admin` ;
ALTER TABLE `ls_ver` CHANGE `memo` `memo` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

ALTER TABLE `ls_management` ADD `name` VARCHAR( 16 ) NULL COMMENT '姓名' AFTER `Text` ,ADD `title` VARCHAR( 16 ) NULL COMMENT '职务' AFTER `name` ,ADD `department` VARCHAR( 16 ) NULL COMMENT '部门' AFTER `title` ,ADD `tel` VARCHAR( 16 ) NULL AFTER `department` ,ADD `mobile` VARCHAR( 16 ) NULL AFTER `tel` ,ADD `email` VARCHAR( 24 ) NULL AFTER `mobile` ,ADD `qq` VARCHAR( 24 ) NULL AFTER `email` 
ALTER TABLE `ls_article` CHANGE `cate` `cateName` VARCHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类别名 二级'
ALTER TABLE `ls_news` CHANGE `newsText` `newsText` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_article` CHANGE `articleText` `articleText` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
ALTER TABLE `ls_singlepages` CHANGE `articleText` `articleText` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_products` CHANGE `productSpecification` `productSpecification` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_project` CHANGE `projectDetails` `projectDetails` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目内容' 
ALTER TABLE `ls_products` CHANGE `midcateDetail` `midcateDetail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_products` CHANGE `subcateDetail` `subcateDetail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_watermark` CHANGE `wtImage` `wtImage` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_products` CHANGE `productSpecification` `productSpecification` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_products` CHANGE `cateDetail` `cateDetail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_products` CHANGE `subcateDetail` `subcateDetail` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_config` CHANGE `aboutus` `aboutus` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_news` CHANGE `newsText` `newsText` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
ALTER TABLE `ls_article` CHANGE `articleText` `articleText` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
