CREATE TABLE yh_shops.`hot_search_brand` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  
  `brand_name` VARCHAR(255) DEFAULT NULL COMMENT '品牌名称',
  `brand_id` INT(11) COMMENT '品牌id',
  `order_by` INT(11) COMMENT '排序',
  `status` SMALLINT(5) UNSIGNED DEFAULT '1' COMMENT '状态 0停用 1 启用',  
  `creator_id` INT(10) UNSIGNED DEFAULT '0',
  `creator_name` VARCHAR(255) DEFAULT NULL,
  `create_time` INT(11) DEFAULT '0',
  `modify_id` INT(10) UNSIGNED DEFAULT '0',
  `modify_name` VARCHAR(255) DEFAULT NULL,
  `modify_time` INT(10) UNSIGNED DEFAULT '0',  
  PRIMARY KEY `id` (`id`) 
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;