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_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;