/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 80013
Source Host : localhost:3306
Source Database : ctrip_hotel_city
Target Server Type : MYSQL
Target Server Version : 80013
File Encoding : 65001
Date: 2018-11-21 17:18:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for metro_station
-- ----------------------------
DROP TABLE IF EXISTS `metro_station`;
CREATE TABLE `metro_station` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`metro_station_name` varchar(100) NOT NULL DEFAULT '' COMMENT '地铁站名称',
`metro_line_id` int(11) NOT NULL DEFAULT '0' COMMENT '地铁线ID',
`metro_station_lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0.000000' COMMENT '地铁站经度',
`metro_station_lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0.000000' COMMENT '站点纬度',
`metro_station_seq` int(11) NOT NULL DEFAULT '0' COMMENT '地铁站序号',
`insert_uid` varchar(50) NOT NULL DEFAULT 'system' COMMENT '创建用户ID',
`insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_uid` varchar(50) NOT NULL DEFAULT 'system' COMMENT '变更用户ID',
`update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '变更时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7336 DEFAULT CHARSET=utf8 COMMENT='地铁站';
-- ----------------------------
-- Records of metro_station
-- ----------------------------
INSERT INTO `metro_station` VALUES ('1', '西苑', '1', '40.004726', '116.298094', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:41');
INSERT INTO `metro_station` VALUES ('2', '农大南路', '1', '40.027823', '116.288702', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:42');
INSERT INTO `metro_station` VALUES ('3', '马连洼', '1', '40.038769', '116.279261', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:42');
INSERT INTO `metro_station` VALUES ('4', '西北旺', '1', '40.055297', '116.264078', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:42');
INSERT INTO `metro_station` VALUES ('5', '永丰南', '1', '40.071669', '116.254611', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:42');
INSERT INTO `metro_station` VALUES ('6', '永丰', '1', '40.077644', '116.244766', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:42');
INSERT INTO `metro_station` VALUES ('7', '屯佃', '1', '40.074106', '116.222442', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:43');
INSERT INTO `metro_station` VALUES ('8', '稻香湖路', '1', '40.074788', '116.194753', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:43');
INSERT INTO `metro_station` VALUES ('9', '温阳路', '1', '40.074892', '116.167825', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:43');
INSERT INTO `metro_station` VALUES ('10', '北安河', '1', '40.073863', '116.136825', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:03:43');
INSERT INTO `metro_station` VALUES ('11', '石厂', '2', '39.895137', '116.106975', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:15');
INSERT INTO `metro_station` VALUES ('12', '小园', '2', '39.896146', '116.121303', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('13', '栗园庄', '2', '39.901771', '116.129827', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('14', '上岸', '2', '39.911139', '116.128714', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('15', '桥户营', '2', '39.918355', '116.132271', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('16', '四道桥', '2', '39.922119', '116.140356', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('17', '金安桥', '2', '39.930086', '116.169398', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('18', '阎村东', '3', '39.734677', '116.107001', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:16');
INSERT INTO `metro_station` VALUES ('19', '紫草坞', '3', '39.730266', '116.093276', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('20', '阎村', '3', '39.722483', '116.086807', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('21', '星城', '3', '39.719734', '116.067772', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('22', '大石河东', '3', '39.716115', '116.046084', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('23', '马各庄', '3', '39.711154', '116.023054', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('24', '饶乐府', '3', '39.707343', '116.012607', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('25', '房山城关', '3', '39.711685', '115.996258', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:17');
INSERT INTO `metro_station` VALUES ('26', '燕山', '3', '39.725203', '115.980152', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:43:52');
INSERT INTO `metro_station` VALUES ('27', '香山', '4', '39.999821', '116.211114', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:44:08');
INSERT INTO `metro_station` VALUES ('28', '植物园', '4', '39.999254', '116.221373', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:44:26');
INSERT INTO `metro_station` VALUES ('29', '万安', '4', '39.989737', '116.238603', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:44:52');
INSERT INTO `metro_station` VALUES ('30', '茶棚', '4', '39.988011', '116.25461', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:45:16');
INSERT INTO `metro_station` VALUES ('31', '颐和园西门', '4', '39.991999', '116.269675', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:45:31');
INSERT INTO `metro_station` VALUES ('32', '巴沟', '4', '39.980389', '116.30051', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:04:10');
INSERT INTO `metro_station` VALUES ('33', '金安桥', '5', '39.930086', '116.169398', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:45:52');
INSERT INTO `metro_station` VALUES ('34', '四道桥', '5', '39.922119', '116.140356', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:46:06');
INSERT INTO `metro_station` VALUES ('35', '桥户营', '5', '39.918355', '116.132271', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:46:20');
INSERT INTO `metro_station` VALUES ('36', '上岸', '5', '39.911139', '116.128714', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:46:42');
INSERT INTO `metro_station` VALUES ('37', '栗园庄', '5', '39.901771', '116.129827', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:47:12');
INSERT INTO `metro_station` VALUES ('38', '小园', '5', '39.896146', '116.121303', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:47:27');
INSERT INTO `metro_station` VALUES ('39', '石厂', '5', '39.895137', '116.106975', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:47:41');
INSERT INTO `metro_station` VALUES ('40', '清华东路西口', '6', '40.0063', '116.345527', '0', 'system', '2018-11-12 15:04:40', 'system', '2018-11-20 17:05:50');
INSERT INTO `metro_station