生产数据库dw 创建表broker_dailystatistic_shop

mysql> CREATE TABLE `broker_dailystatistic_shop` (
    ->   `id` int(13) NOT NULL AUTO_INCREMENT COMMENT '自增id',
    ->   `date` date NOT NULL COMMENT '日期',
    ->   `shopid` int(13) NOT NULL COMMENT '门店id',
    ->   `shop_name` varchar(255) DEFAULT NULL COMMENT '门店名字',
    ->   `shop_address` varchar(255) DEFAULT NULL COMMENT '门店地址',
    ->   `companyid` int(13) NOT NULL COMMENT '公司id',
    ->   `shop_district` int(13) DEFAULT NULL COMMENT '区域',
    ->   `shop_sector` int(13) DEFAULT NULL COMMENT '板块',
    ->   `shop_visable` int(6) DEFAULT NULL COMMENT '门店_验证与否  1为验证 -1为不验证',
    ->   `shop_logintime` int(11) DEFAULT NULL COMMENT '门店最后登陆时间',
    ->   PRIMARY KEY (`id`),
    ->   KEY `shopid` (`shopid`),
    ->   KEY `companyid` (`companyid`),
    ->   KEY `date` (`date`)
    -> ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.07 sec)