ALTER TABLE `yohood`.`tbl_prod` ADD COLUMN `sort` INT(10) DEFAULT '0' AFTER `pic`;
ALTER TABLE `yohood`.`tbl_brand` ADD COLUMN `link` VARCHAR(255) NULL AFTER `news_ids`;
ALTER TABLE `yohood`.`tbl_index` CHANGE `type` `type` TINYINT(2) DEFAULT '0' NOT NULL COMMENT '1:首页banner,2:广告,3:品牌广告, 4:详情页广告位';
ALTER TABLE `yohood`.`tbl_partner` ADD COLUMN `type` TINYINT(2) NULL AFTER `id`;
ALTER TABLE `yohood`.`tbl_activity_plan` ADD COLUMN `parent_id` INT(10) DEFAULT '0' NULL AFTER `id`;
ALTER TABLE `yohood`.`tbl_index`     ADD COLUMN `res_size` VARCHAR(100) NULL AFTER `sort`;
ALTER TABLE `yohood`.`tbl_news` ADD COLUMN `pics` VARCHAR(1000) NULL COMMENT '图片列表' AFTER `content`;
/**现场主题**/
CREATE TABLE `tbl_activity_topic` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `title` varchar(50) DEFAULT NULL,
   `place` varchar(200) DEFAULT NULL,
   `start_time` int(10) DEFAULT NULL,
   `end_time` int(10) DEFAULT NULL,
   `create_time` int(10) DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 ALTER TABLE `yohood`.`tbl_partner` ADD INDEX `idx_type` (`type`);
 /**
  * 对应关系表
  */
 CREATE TABLE `tbl_news_brand_rela` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `news_id` int(10) unsigned NOT NULL,
   `brand_id` int(10) unsigned NOT NULL,
   `create_time` int(10) DEFAULT NULL,
   PRIMARY KEY (`id`,`news_id`,`brand_id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/**
 * 更新表记录
 */
INSERT INTO tbl_activity_topic(title,place,start_time,end_time, create_time) SELECT title,place,start_time,end_time,UNIX_TIMESTAMP() FROM tbl_activity_plan;
UPDATE  tbl_activity_plan a,tbl_activity_topic b SET a.parent_id = b.id WHERE a.start_time=b.start_time AND a.end_time = b.end_time