# 增加表
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 ;

# 增加字段
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` 

# 其他 query 操作
ALTER TABLE `ls_revolvingpics` COMMENT = '主页流动图 片 '
ALTER TABLE `ls_config` CHANGE `bottomMenu` `bottomMenu` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL 


