城市商圈/行政区域/地铁沿线数据库

/* SQLyog Ultimate v8.32 MySQL - 5.6.24 ********************************************************************* */ /*!40101 SET NAMES utf8 */; create table `bussiness` ( `bussinessId` double , `areaId` double , `bussinessCircleId` double , `bussinessCircleName` varchar (90), `bussinessCircleType` varchar (30), `cityNo` varchar (60), `hotelNum` double , `loginName` varchar (60), `pageSize` double , `skipResults` double ); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('1','35','112','地铁1号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('2','35','113','地铁2号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('3','35','114','地铁3号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('4','35','115','地铁4号线','2','1101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('5','35','116','地铁5号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('6','35','117','地铁6号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('7','35','118','地铁7号线','2','1101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('8','35','119','地铁8号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('9','35','120','地铁9号线','2','1101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('10','35','121','地铁10号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('11','35','122','地铁11号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('12','35','123','地铁12号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('13','35','124','地铁13号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('14','35','125','地铁14号线','2','1101','0','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('15','37','7','地铁9号线','2','3101','9','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('16','37','126','地铁1号线','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('17','37','127','地铁2号线','2','3101','5','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('18','37','128','地铁3号线','2','3101','2','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('19','37','129','地铁4号线','2','3101','2','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('20','37','130','地铁5号线','2','3101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('21','37','131','地铁6号线','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('22','37','132','地铁7号线','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('23','37','133','地铁8号线','2','3101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('24','37','134','地铁10号线','2','3101','2','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('25','37','135','地铁11号线','2','3101','6','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('26','37','136','地铁12号线','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('27','37','371','地铁16号线','2','3101','7','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('28','37','373','野生动物园站','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('29','37','2285','滴水湖','2','3101','1','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `loginName`, `pageSize`, `skipResults`) values('30','37','2673','磁悬浮','2','3101','3','','0','0'); insert into `bussiness` (`bussinessId`, `areaId`, `bussinessCircleId`, `bussinessCircleName`, `bussinessCircleType`, `cityNo`, `hotelNum`, `log