think_province.sql
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50617
Source Host : localhost:3306
Source Database : qdnt
Target Server Type : MYSQL
Target Server Version : 50617
File Encoding : 65001
Date: 2016-07-26 11:53:45
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `think_province`
-- ----------------------------
DROP TABLE IF EXISTS `think_province`;
CREATE TABLE `think_province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) DEFAULT NULL COMMENT '省区名',
`alias` varchar(64) DEFAULT NULL COMMENT '简称',
`resource` tinyint(4) DEFAULT '0' COMMENT '标注是否资源的城市:1为是,0为否',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='省参考';
-- ----------------------------
-- Records of think_province
-- ----------------------------
INSERT INTO `think_province` VALUES ('1', '北京', '北京', '1');
INSERT INTO `think_province` VALUES ('2', '上海', '上海', '1');
INSERT INTO `think_province` VALUES ('3', '天津', '天津', '1');
INSERT INTO `think_province` VALUES ('4', '重庆', '重庆', '1');
INSERT INTO `think_province` VALUES ('5', '河北', '河北', '1');
INSERT INTO `think_province` VALUES ('6', '河南', '河南', '1');
INSERT INTO `think_province` VALUES ('7', '湖北', '湖北', '1');
INSERT INTO `think_province` VALUES ('8', '湖南', '湖南', '1');
INSERT INTO `think_province` VALUES ('9', '江苏', '江苏', '1');
INSERT INTO `think_province` VALUES ('10', '江西', '江西', '1');
INSERT INTO `think_province` VALUES ('11', '辽宁', '辽宁', '1');
INSERT INTO `think_province` VALUES ('12', '吉林', '吉林', '1');
INSERT INTO `think_province` VALUES ('13', '黑龙江', '黑龙江', '1');
INSERT INTO `think_province` VALUES ('14', '陕西', '陕西', '1');
INSERT INTO `think_province` VALUES ('15', '山东', '山东', '1');
INSERT INTO `think_province` VALUES ('16', '山西', '山西', '1');
INSERT INTO `think_province` VALUES ('17', '四川', '四川', '1');
INSERT INTO `think_province` VALUES ('18', '青海', '青海', '1');
INSERT INTO `think_province` VALUES ('19', '安徽', '安徽', '1');
INSERT INTO `think_province` VALUES ('20', '海南', '海南', '1');
INSERT INTO `think_province` VALUES ('21', '广东', '广东', '1');
INSERT INTO `think_province` VALUES ('22', '广西', '广西', '1');
INSERT INTO `think_province` VALUES ('23', '贵州', '贵州', '1');
INSERT INTO `think_province` VALUES ('24', '浙江', '浙江', '1');
INSERT INTO `think_province` VALUES ('25', '福建', '福建', '1');
INSERT INTO `think_province` VALUES ('26', '甘肃', '甘肃', '1');
INSERT INTO `think_province` VALUES ('27', '云南', '云南', '1');
INSERT INTO `think_province` VALUES ('28', '内蒙古', '内蒙古', '1');
INSERT INTO `think_province` VALUES ('29', '宁夏', '宁夏', '1');
INSERT INTO `think_province` VALUES ('30', '新疆', '新疆', '1');
INSERT INTO `think_province` VALUES ('31', '西藏', '西藏', '1');
INSERT INTO `think_province` VALUES ('32', '香港', '香港', '0');
INSERT INTO `think_province` VALUES ('33', '澳门', '澳门', '0');
INSERT INTO `think_province` VALUES ('34', '台湾', '台湾', '0');
INSERT INTO `think_province` VALUES ('35', '海外', '海外', '0');
think_location.sql
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50617
Source Host : localhost:3306
Source Database : ihaier20160721
Target Server Type : MYSQL
Target Server Version : 50617
File Encoding : 65001
Date: 2016-07-25 17:28:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `hai_location`
-- ----------------------------
DROP TABLE IF EXISTS `hai_location`;
CREATE TABLE `hai_location` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`country` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '国家',
`province_id` bigint(20) DEFAULT NULL COMMENT '省ID',
`state` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '省份',
`city` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '城市',
`cityASCII` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '城市编码',
`resource` int(1) DEFAULT '0' COMMENT '标注是否资源的城市:1为是,0为否',
`sort` int(11) DEFAULT NULL COMMENT '排序值',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=567 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='省市参考';
-- ----------------------------
-- Records of hai_location
-- ----------------------------
INSERT INTO `hai_location` VALUES ('390', 'CN', '4', '重庆', '重庆市', '390', '1', '0');
INSERT INTO `hai_location` VALUES ('389', 'CN', '24', '浙江', '衢州市', '389', '1', '8');
INSERT INTO `hai_location` VALUES ('388', 'CN', '24', '浙江', '舟山市', '388', '1', '9');
INSERT INTO `hai_location` VALUES ('387', 'CN', '24', '浙江', '温州市', '387', '1', '3');
INSERT INTO `hai_location` VALUES ('386', 'CN', '24', '浙江', '台州市', '386', '1', '10');
INSERT INTO `hai_location` VALUES ('385', 'CN', '24', '浙江', '绍兴市', '385', '1', '6');
INSERT INTO `hai_location` VALUES ('384', 'CN', '24', '浙江', '宁波市', '384', '1', '2');
INSERT INTO `hai_location` VALUES ('383', 'CN', '24', '浙江', '丽水市', '383', '1', '11');
INSERT INTO `hai_location` VALUES ('382', 'CN', '24', '浙江', '金华市', '382', '1', '7');
INSERT INTO `hai_location` VALUES ('381', 'CN', '24', '浙江', '嘉兴市', '381', '1', '4');
INSERT INTO `hai_location` VALUES ('380', 'CN', '24', '浙江', '湖州市', '380', '1', '5');
INSERT INTO `hai_location` VALUES ('379', 'CN', '24', '浙江', '杭州市', '379', '1', '1');
INSERT INTO `hai_location` VALUES ('378', 'CN', '27', '云南', '昭通市', '378', '1', '6');
INSERT INTO `hai_location` VALUES ('377', 'CN', '27', '云南', '玉溪市', '377', '1', '4');
INSERT INTO `hai_location` VALUES ('376', 'CN', '27', '云南', '西双版纳傣族自治州', '376', '1', '28');
INSERT INTO `hai_location` VALUES ('375', 'CN', '27', '云南', '文山壮族苗族自治州', '375', '1', '26');
INSERT INTO `hai_location` VALUES ('374', 'CN', '27', '云南', '思茅市', '374', '1', '27');
INSERT INTO `hai_location` VALUES ('373', 'CN', '27', '云南', '曲靖市', '373', '1', '3');
INSERT INTO `hai_location` VALUES ('372', 'CN', '27', '云南', '怒江傈僳族自治州', '372', '1', '33');
INSERT INTO `hai_location` VALUES ('371', 'CN', '27', '云南', '临沧市', '371', '1', '35');
INSERT INTO `hai_location` VALUES ('370', 'CN', '27', '云南', '丽江市', '370', '1', '32');
INSERT INTO `hai_location` VALUES ('369', 'CN', '27', '云南', '昆明市', '369', '1', '1');
INSERT INTO `hai_location` VALUES ('368', 'CN', '27', '云南', '红河哈尼族彝族自治州', '368', '1', '25');
INSERT INTO `hai_location` VALUES ('367', 'CN', '27', '云南', '迪庆藏族自治州', '367', '1', '34');
INSERT INTO `hai_location` VALUES ('366', 'CN', '27', '云南', '德宏傣族景颇族自治州', '366', '1', '31');
INSERT INTO `hai_location` VALUES ('365', 'CN', '27', '云南', '大理白族自治州', '365', '1', '29');
INSERT INTO `hai_location` VALUES ('364', 'CN', '27', '云南', '楚雄彝族自治州', '364', '1', '23');
INSERT INTO `hai_location` VALUES ('363', 'CN', '27', '云南', '保山市', '363', '1', '5');
INSERT INTO `hai_location` VALUES ('362', 'CN', '30', '新疆', '伊犁哈萨克自治州', '362', '1', '40');
INSERT INTO `hai_location` VALUES ('361', 'CN', '30', '新疆', '乌鲁木齐市', '361', '1', '1');
INSERT INTO `hai_location` VALUES ('360', 'CN', '30', '新疆', '吐鲁番地区', '360', '1', '21');
INSERT INTO `hai_location` VALUES ('359', 'CN', '30', '新疆', '塔城地区', '359', '1', '42');
INSERT INTO `hai_location` VALUES ('358', 'CN', '30', '新疆', '石河子市', '358', '1', '45');
INSERT INTO `hai_location` VALUES ('357', 'CN', '30', '新疆', '克孜勒苏柯尔克孜自治州', '357', '1', '30');
INSERT INTO `hai_location` VALUES ('356', 'CN', '30', '新疆', '克拉玛依市', '356', '1', '2');
INSERT INTO `hai_location` VALUES ('355', 'CN', '30', '新疆', '喀什地区', '355', '1', '31');
INSERT INTO `hai_location` VALUES ('354', 'CN', '30', '新疆', '和田地区', '354', '1', '32');
INSERT INTO `hai_location` VALUES ('353', 'CN', '30', '新疆', '哈密地区', '353', '1', '22');
INSERT INTO `hai_location` VALUES ('352', 'CN', '30', '新疆', '昌吉回族自治州', '352', '1', '23');
INSERT INTO `hai_location` VALUES ('351', 'CN', '30', '新疆', '博尔塔拉蒙古自治州', '351', '1', '27');
INSERT INTO `hai_location` VALUES ('350', 'CN', '30', '新疆', '巴音郭楞蒙古自治州', '350', '1', '28');
INSERT INTO `hai_location` VALUES ('349', 'CN', '30', '新疆', '阿勒泰地区', '349', '1', '43');
INSERT INTO `hai_location` VALUES ('348', 'CN', '30', '新疆', '阿克苏地区', '348', '1', '29');
INSERT INTO `hai_location` VALUES ('347', 'CN', '31', '西藏', '山南地区', '347', '1', '22');
INSERT INTO `hai_location` VALUES ('346', 'CN', '31', '西藏', '日喀则地区', '346', '1', '23');
INSERT INTO `hai_location` VALUES ('345', 'CN', '31', '西藏', '那曲地区', '345', '1', '24');
INSERT INTO `hai_location` VALUES ('344', 'CN', '31', '西藏', '林芝地区', '344', '1', '26');
INSERT INTO `hai_location` VALUES ('343', 'CN', '31', '西藏', '拉萨市', '343', '1', '1');
INSERT INTO `hai_location` VALUES ('342', 'CN', '31', '西藏', '昌都地区', '342', '1', '21');
INSERT INTO `hai_location` VALUES ('341', 'CN', '31', '西藏', '阿里地区', '341', '1', '25');
INSERT INTO `hai_location` VALUES ('323', 'CN', '3', '天津', '天津市', '323', '1', '1');
INSERT INTO `hai_location` VALUES ('322', 'CN', '17', '四川', '泸州市', '322', '1', '5');
INSERT INTO `hai_location` VALUES ('321', 'CN', '17', '四川', '自贡市', '321', '1', '3');
INSERT INTO `hai_location` VALUES ('320', 'CN', '17', '四川', '资阳市', '320', '1', '20');
INSERT INTO `hai_location` VALUES ('319', 'CN', '17', '四川', '宜宾市', '319', '1', '15');
INSERT INTO `hai_location` VALUES ('318', 'CN', '17', '四川', '雅安市', '318', '1', '18');
INSERT INTO `hai_location` VALUES ('317', 'CN', '17', '四川', '遂宁市', '317', '1', '9');
INSERT INTO `hai_location` VALUES ('316', 'CN', '17', '四川', '攀枝花市', '316', '1', '4');
INSERT INTO `hai_location` VALUES ('315', 'CN', '17', '四川', '内江市', '315', '1', '10');
INSERT INTO `hai_location` VALUES ('314', 'CN', '17', '四川', '南充市', '314', '1', '13');
INSERT INTO `hai_location` VALUES ('313', 'CN', '17', '四川', '绵阳市', '313', '1', '7');
INSERT INTO `hai_location` VALUES ('312', 'CN', '17', '四川', '眉山市', '312', '1', '14');
INSERT INTO `hai_location` VALUES