sql

-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2019-09-12 17:44:33
-- 服务器版本： 5.6.38
-- PHP 版本： 7.2.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `newproject`
--

-- --------------------------------------------------------

--
-- 表的结构 `admin`
--

CREATE TABLE `admin` (
`id` int(10) UNSIGNED NOT NULL,
`account` varchar(20) NOT NULL COMMENT ‘后台用户‘,
`passwd` char(32) NOT NULL,
`group_name` varchar(20) NOT NULL COMMENT ‘用户分组‘,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT ‘1‘ COMMENT ‘状态，1为正常0为禁用‘,
`log_last_time` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘ COMMENT ‘最后登陆时间戳‘,
`log_last_ip` varchar(32) DEFAULT NULL COMMENT ‘最后登陆ip地址‘,
`groups2` varchar(80) DEFAULT NULL,
`log_count` smallint(5) UNSIGNED NOT NULL DEFAULT ‘0‘ COMMENT ‘登陆总次数‘,
`session_id` varchar(80) NOT NULL,
`name` varchar(100) DEFAULT NULL COMMENT ‘管理员姓名‘,
`mobile` varchar(40) DEFAULT NULL COMMENT ‘手机号码‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `admin`
--

INSERT INTO `admin` (`id`, `account`, `passwd`, `group_name`, `status`, `log_last_time`, `log_last_ip`, `groups2`, `log_count`, `session_id`, `name`, `mobile`) VALUES
(1, ‘admin‘, ‘96e79218965eb72c92a549dd5a330112‘, ‘管理员‘, 1, 1568267421, ‘116.226.30.43‘, ‘[\"1\"]‘, 378, ‘e50e36664fbb519937f060186e10f52b‘, ‘严瑞成‘, ‘13621325241‘),
(2, ‘chenjun‘, ‘8cf67f50a2086ecbd07a963c5d8db05c‘, ‘张三‘, 1, 1528945160, ‘101.81.58.234‘, ‘[\"1\"]‘, 1069, ‘h9e1q0m1un028aofhr10mlhuh6‘, NULL, NULL),
(3, ‘limengshi‘, ‘5b892d99136326a6a5832df06546b95f‘, ‘李四‘, 1, 1482131467, ‘211.161.103.56‘, ‘[\"2\"]‘, 7, ‘k0mts2v8jdgbqcrkkv64o9va21‘, NULL, NULL),
(4, ‘yan‘, ‘96e79218965eb72c92a549dd5a330112‘, ‘‘, 1, 1566976559, NULL, ‘[\"1\"]‘, 0, ‘‘, ‘李四‘, NULL),
(14, ‘wc‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567590386, ‘116.226.30.43‘, ‘[\"2\"]‘, 12, ‘10226c625591c1fbc218b7bd5eeffccd‘, ‘旺财‘, NULL),
(15, ‘andy‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567654438, ‘116.226.30.43‘, ‘[\"1\"]‘, 10, ‘d875ac52c6439305207e06d5e35f0170‘, ‘安迪‘, NULL),
(16, ‘是你加衣服哈‘, ‘722226c5803b276df6c8e24e45251686‘, ‘‘, 1, 1567390749, ‘116.226.30.43‘, ‘[\"1\"]‘, 1, ‘40532a921b67d811d12956411e6def42‘, ‘胡欣宇‘, NULL),
(17, ‘Lily‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567391947, NULL, ‘[\"4\",\"3\",\"5\",\"2\",\"1\"]‘, 0, ‘‘, ‘莉莉‘, NULL),
(18, ‘y1‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568018993, ‘116.226.30.43‘, ‘[\"3\"]‘, 2, ‘8af7ed89bfd7cb97530b9c908331c461‘, ‘y y‘, ‘15988877766‘),
(19, ‘17680141761‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567590160, ‘116.226.30.43‘, ‘[\"2\"]‘, 1, ‘10226c625591c1fbc218b7bd5eeffccd‘, ‘+‘, ‘12345678901‘),
(20, ‘wc1‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568011296, ‘116.226.30.43‘, ‘[\"6\",\"4\",\"3\",\"5\",\"2\",\"1\"]‘, 2, ‘c648a335ed5003f3915e4155477e8302‘, ‘wc‘, ‘15988877766‘),
(21, ‘wc2‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567997741, NULL, ‘[\"6\"]‘, 0, ‘‘, ‘wc‘, ‘15988877766‘),
(22, ‘wc3‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567997753, NULL, ‘[\"6\"]‘, 0, ‘‘, ‘wc‘, ‘15988877766‘),
(23, ‘wc4‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1567997829, NULL, ‘[\"6\"]‘, 0, ‘‘, ‘wc‘, ‘12345678901‘),
(24, ‘wing‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 0, 1567998318, NULL, ‘[\"6\",\"4\",\"3\"]‘, 0, ‘‘, ‘y y‘, ‘15988877766‘),
(25, ‘wdl‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568266431, ‘116.230.115.195‘, ‘[\"1\"]‘, 6, ‘ba4eb41c4539fa78ac1ae1b0a972c4e2‘, ‘玩大了‘, ‘15988877766‘),
(26, ‘wangxue‘, ‘39e00f1dc1650e2adef061cdd90d3e85‘, ‘‘, 1, 1568020580, NULL, ‘[\"6\",\"4\",\"3\",\"5\",\"2\",\"1\"]‘, 0, ‘‘, ‘王雪‘, ‘13716152321‘),
(27, ‘jiurong1‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568021347, NULL, ‘[\"4\",\"6\",\"2\",\"7\",\"5\",\"3\"]‘, 0, ‘‘, ‘久融1‘, ‘17680141761‘),
(28, ‘jiurong2‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568021378, NULL, ‘[\"6\"]‘, 0, ‘‘, ‘久融2‘, ‘17680141761‘),
(29, ‘v‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568021736, NULL, ‘[\"4\"]‘, 0, ‘‘, ‘y y‘, ‘17680141761‘),
(30, ‘v1‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568021866, NULL, ‘[\"4\"]‘, 0, ‘‘, ‘y y‘, ‘17680141761‘),
(31, ‘v3‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568083424, ‘116.226.30.43‘, ‘[\"6\"]‘, 1, ‘b4fcedd38fd01188cffd7e526f8aab92‘, ‘v‘, ‘17680141761‘),
(32, ‘admin21‘, ‘96e79218965eb72c92a549dd5a330112‘, ‘‘, 1, 1568021999, NULL, ‘[\"5\"]‘, 0, ‘‘, ‘李丽‘, ‘15988877766‘),
(33, ‘艾蕾娜‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568191704, ‘116.226.30.43‘, ‘[\"4\",\"6\",\"2\",\"7\",\"5\",\"3\"]‘, 1, ‘c6f1c2fc6b14f3c541b1ce1acd89debf‘, ‘艾蕾娜‘, ‘13661629806‘),
(34, ‘xiaotian1‘, ‘e10adc3949ba59abbe56e057f20f883e‘, ‘‘, 1, 1568181640, NULL, ‘[\"6\"]‘, 0, ‘‘, ‘小天‘, ‘15988877760‘);

-- --------------------------------------------------------

--
-- 表的结构 `admin_action`
--

CREATE TABLE `admin_action` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(50) NOT NULL COMMENT ‘模块名‘,
`pid` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘ COMMENT ‘上级模块‘,
`action` varchar(50) NOT NULL,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT ‘1‘ COMMENT ‘是否显示 1 不显示 2 显示‘,
`icon` varchar(80) NOT NULL COMMENT ‘icon class‘,
`sort` tinyint(3) UNSIGNED NOT NULL DEFAULT ‘0‘ COMMENT ‘排序‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `admin_action`
--

INSERT INTO `admin_action` (`id`, `name`, `pid`, `action`, `status`, `icon`, `sort`) VALUES
(1, ‘首页‘, 0, ‘index‘, 1, ‘‘, 0),
(2, ‘广告管理‘, 0, ‘ad‘, 1, ‘‘, 0),
(3, ‘媒体管理‘, 0, ‘media‘, 1, ‘‘, 0);

-- --------------------------------------------------------

--
-- 表的结构 `admin_group`
--

CREATE TABLE `admin_group` (
`name` varchar(20) NOT NULL,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT ‘0‘,
`auth` text NOT NULL COMMENT ‘允许的权限‘,
`update_time` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `admin_group`
--

INSERT INTO `admin_group` (`name`, `status`, `auth`, `update_time`, `id`) VALUES
(‘超级管理员‘, 1, ‘[\"\"]‘, 1566974099, 1),
(‘市场部‘, 1, ‘[\"1\",\"2\",\"6\",\"7\",\"3\",\"8\",\"9\",\"11\",\"4\",\"12\",\"13\",\"5\",\"14\",\"15\",\"16\",\"\",\"2\",\"2\",\"3\",\"3\",\"3\",\"4\",\"4\",\"5\",\"5\",\"5\"]‘, 1568020817, 2),
(‘运营部‘, 1, ‘[\"1\",\"2\",\"6\",\"7\",\"\",\"2\",\"2\"]‘, 1568020785, 3),
(‘商务部‘, 1, ‘[\"1\",\"3\",\"8\",\"9\",\"11\",\"4\",\"12\",\"13\",\"\",\"3\",\"3\",\"3\",\"4\",\"4\"]‘, 1568020765, 4),
(‘财务部‘, 1, ‘[\"1\",\"2\",\"6\",\"7\",\"\",\"2\",\"2\"]‘, 1568020799, 5),
(‘媒介部‘, 1, ‘[\"1\",\"2\",\"6\",\"7\",\"17\",\"3\",\"8\",\"9\",\"11\",\"4\",\"12\",\"13\",\"5\",\"14\",\"15\",\"16\",\"\",\"2\",\"2\",\"2\",\"3\",\"3\",\"3\",\"4\",\"4\",\"5\",\"5\",\"5\"]‘, 1568020754, 6),
(‘技术部‘, 1, ‘[\"1\",\"18\",\"2\",\"6\",\"7\",\"17\",\"3\",\"8\",\"9\",\"11\",\"4\",\"12\",\"13\",\"5\",\"14\",\"15\",\"16\",\"\",\"1\",\"2\",\"2\",\"2\",\"3\",\"3\",\"3\",\"4\",\"4\",\"5\",\"5\",\"5\"]‘, 1568020903, 7);

-- --------------------------------------------------------

--
-- 表的结构 `admin_menu`
--

CREATE TABLE `admin_menu` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(80) NOT NULL,
`pid` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘,
`sort` tinyint(3) UNSIGNED NOT NULL DEFAULT ‘0‘,
`name` varchar(80) NOT NULL,
`hide` tinyint(1) UNSIGNED NOT NULL DEFAULT ‘0‘,
`icon` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `admin_menu`
--

INSERT INTO `admin_menu` (`id`, `title`, `pid`, `sort`, `name`, `hide`, `icon`) VALUES
(1, ‘首页‘, 0, 0, ‘index‘, 0, ‘fa fa-首页‘),
(2, ‘广告管理‘, 0, 0, ‘ad‘, 0, ‘fa fa-files-o‘),
(3, ‘媒体管理‘, 0, 0, ‘media‘, 0, ‘fa fa-pie-chart‘),
(4, ‘报表中心‘, 0, 0, ‘report‘, 0, ‘fa fa-laptop‘),
(5, ‘角色管理‘, 0, 0, ‘system‘, 0, ‘fa fa-edit‘),
(6, ‘广告商管理‘, 2, 0, ‘ad_list‘, 0, ‘‘),
(7, ‘广告素材管理‘, 2, 0, ‘lists‘, 0, ‘‘),
(8, ‘账户管理‘, 3, 0, ‘account_list‘, 0, ‘‘),
(9, ‘应用管理‘, 3, 0, ‘apply‘, 0, ‘‘),
(11, ‘广告位管理‘, 3, 0, ‘address‘, 0, ‘‘),
(12, ‘媒体报表‘, 4, 0, ‘media_lists‘, 0, ‘‘),
(13, ‘财务报表‘, 4, 0, ‘finance‘, 0, ‘‘),
(14, ‘菜单列表‘, 5, 0, ‘index‘, 0, ‘‘),
(15, ‘用户管理‘, 5, 0, ‘user‘, 0, ‘‘),
(16, ‘权限管理‘, 5, 0, ‘group‘, 0, ‘‘);

-- --------------------------------------------------------

--
-- 表的结构 `admin_role`
--

CREATE TABLE `admin_role` (
`id` int(10) UNSIGNED NOT NULL,
`role_name` varchar(30) NOT NULL COMMENT ‘角色名‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `admin_role_action`
--

CREATE TABLE `admin_role_action` (
`id` int(10) UNSIGNED NOT NULL,
`role_id` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘,
`action_id` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `admin_user_role`
--

CREATE TABLE `admin_user_role` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘,
`role_id` int(10) UNSIGNED NOT NULL DEFAULT ‘0‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `advertiser`
--

CREATE TABLE `advertiser` (
`id` int(11) NOT NULL,
`advertising_agency_id` int(11) NOT NULL COMMENT ‘advertising_agency_id‘,
`name` varchar(255) NOT NULL COMMENT ‘广告主名称‘,
`url` varchar(255) DEFAULT NULL COMMENT ‘广告url‘,
`status` int(1) NOT NULL COMMENT ‘广告主审核状态 0 - 待审核 1 - 审核通过 2 - 审核未通过‘,
`reason` varchar(255) NOT NULL COMMENT ‘审核未通过原因‘,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间‘,
`create_time` datetime DEFAULT NULL COMMENT ‘更新时间‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `advertising_agency`
--

CREATE TABLE `advertising_agency` (
`id` int(11) NOT NULL,
`dock_person` varchar(50) NOT NULL COMMENT ‘对接负责人‘,
`company` varchar(50) NOT NULL COMMENT ‘公司全称‘,
`company_short_name` varchar(20) NOT NULL COMMENT ‘公司简称‘,
`company_url` varchar(255) DEFAULT NULL COMMENT ‘公司官网链接‘,
`contact` char(50) NOT NULL COMMENT ‘广告商联系人‘,
`mobile` char(50) NOT NULL COMMENT ‘广告商联系电话‘,
`province_id` int(11) UNSIGNED NOT NULL COMMENT ‘省份id（联系地址）‘,
`city_id` int(11) UNSIGNED NOT NULL COMMENT ‘市id（联系地址）‘,
`contact_address` varchar(255) NOT NULL COMMENT ‘详细的联系地址‘,
`settlement_period` tinyint(1) NOT NULL COMMENT ‘结算周期，1 月结‘,
`status` tinyint(1) NOT NULL COMMENT ‘1运行2 已暂停‘,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间‘,
`start_time` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00‘ COMMENT ‘合作开始时间‘,
`end_time` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00‘ COMMENT ‘合作结束时间‘,
`qps` int(11) NOT NULL DEFAULT ‘0‘ COMMENT ‘qps量‘,
`adx_request_url` varchar(255) NOT NULL COMMENT ‘DSP接口地址‘,
`win_notice_url` varchar(255) DEFAULT NULL COMMENT ‘胜出通知地址‘,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间‘,
`delete_flag` tinyint(1) NOT NULL COMMENT ‘1删除0显示‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘广告商‘;

--
-- 转存表中的数据 `advertising_agency`
--

INSERT INTO `advertising_agency` (`id`, `dock_person`, `company`, `company_short_name`, `company_url`, `contact`, `mobile`, `province_id`, `city_id`, `contact_address`, `settlement_period`, `status`, `create_time`, `start_time`, `end_time`, `qps`, `adx_request_url`, `win_notice_url`, `update_time`, `delete_flag`) VALUES
(1, ‘5‘, ‘杭州阿里巴巴网络信息有限公司‘, ‘阿里巴巴‘, ‘https://github.com‘, ‘张三‘, ‘13621325241‘, 130000, 130500, ‘测试122号‘, 3, 1, ‘2019-09-06 08:37:32‘, ‘2018-09-02 16:00:00‘, ‘2019-09-06 16:00:00‘, 10000, ‘https://www.baidu.com‘, ‘https://www.baidu.com/notice‘, ‘2019-09-12 02:32:30‘, 0),
(2, ‘6‘, ‘百度公司‘, ‘百度‘, ‘https://www.baidu.com‘, ‘王五‘, ‘13621325243‘, 310000, 310600, ‘江浦路199号‘, 3, 2, ‘2019-09-09 02:56:34‘, ‘2019-09-03 16:00:00‘, ‘2019-09-25 16:00:00‘, 100, ‘https://www.baidu.com‘, ‘https://www.baidu.com/nonic‘, ‘2019-09-12 03:46:52‘, 0),
(3, ‘请选择‘, ‘x q s w x q w s‘, ‘百度‘, ‘x w d x w‘, ‘x c d w s w sa‘, ‘13621325241‘, 130000, 130400, ‘x c w d x w‘, 3, 2, ‘2019-09-09 03:00:21‘, ‘2019-09-01 16:00:00‘, ‘2019-09-18 16:00:00‘, 111, ‘https://www.baidu.com‘, ‘https://www.baidu.com/nonic‘, ‘2019-09-12 05:27:12‘, 0),
(4, ‘26‘, ‘xsa‘, ‘1‘, ‘https://github.com‘, ‘张三‘, ‘13621325241‘, 130000, 130300, ‘11‘, 3, 1, ‘2019-09-12 09:01:32‘, ‘2019-09-08 16:00:00‘, ‘2019-09-18 15:59:59‘, 111, ‘https://www.baidu.com‘, ‘https://www.baidu.com/nonic‘, ‘2019-09-12 09:01:32‘, 0),
(5, ‘20‘, ‘成‘, ‘12‘, ‘https://github.com‘, ‘rayson‘, ‘13621325241‘, 140000, 140400, ‘11‘, 3, 2, ‘2019-09-12 09:01:22‘, ‘2019-09-01 16:00:00‘, ‘2019-09-11 15:59:59‘, 110, ‘https://www.baidu.com‘, ‘https://www.baidu.com/nonic‘, ‘2019-09-12 09:01:22‘, 0),
(6, ‘5‘, ‘成e f‘, ‘删除s‘, ‘xas‘, ‘张三‘, ‘13621325241‘, 130000, 130400, ‘xas‘, 3, 1, ‘2019-09-12 05:44:32‘, ‘2019-09-11 16:00:00‘, ‘2019-09-27 15:59:59‘, 122, ‘https://www.baidu.com‘, ‘https://www.baidu.com/nonic‘, ‘2019-09-12 08:24:19‘, 1);

-- --------------------------------------------------------

--
-- 表的结构 `ad_address`
--

CREATE TABLE `ad_address` (
`id` int(11) NOT NULL,
`apply_id` int(11) UNSIGNED NOT NULL COMMENT ‘所属应用id‘,
`ad_address_type` int(11) NOT NULL COMMENT ‘广告位类型1banner2插屏‘,
`spec_id` smallint(5) NOT NULL COMMENT ‘规格，尺寸‘,
`ad_page` varchar(100) NOT NULL COMMENT ‘所在页面‘,
`dock_mode` tinyint(1) UNSIGNED NOT NULL COMMENT ‘1 sdk 2api‘,
`media_type` tinyint(1) UNSIGNED NOT NULL COMMENT ‘媒体类型，1，采卖，2自营，3其他‘,
`ad_min_price` decimal(10,2) NOT NULL COMMENT ‘广告底价‘,
`cooper_mode` tinyint(1) NOT NULL COMMENT ‘1固定价格，2广告分成‘,
`ad_css` varchar(100) DEFAULT NULL COMMENT ‘广告位样式‘,
`gender` tinyint(1) UNSIGNED NOT NULL DEFAULT ‘0‘ COMMENT ‘1男2女0为不限‘,
`user_age_type` tinyint(1) UNSIGNED NOT NULL COMMENT ‘0不限，1特定年龄阶段‘,
`status` tinyint(1) UNSIGNED NOT NULL COMMENT ‘0为删除1为开启2为关闭‘,
`create_time` datetime NOT NULL COMMENT ‘创建时间戳‘,
`apply_type` tinyint(1) UNSIGNED NOT NULL COMMENT ‘1,社区，2工具，3，电商‘,
`ad_name` varchar(255) NOT NULL COMMENT ‘广告位名称‘,
`sdk_key` varchar(255) DEFAULT NULL COMMENT ‘sdk_key‘,
`system` int(2) NOT NULL COMMENT ‘1为IOS 2为安卓‘,
`copper_scale` varchar(100) DEFAULT NULL COMMENT ‘广告分成比例‘,
`ad_width` int(11) DEFAULT ‘0‘ COMMENT ‘广告宽‘,
`ad_height` int(11) DEFAULT ‘0‘ COMMENT ‘广告高‘,
`ad_bc` varchar(100) NOT NULL COMMENT ‘边框颜色‘,
`ad_bw` int(11) NOT NULL COMMENT ‘边框粗细单位px‘,
`ad_min_price2` float(10,2) NOT NULL COMMENT ‘第二底价‘,
`update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
`user_age` varchar(255) DEFAULT NULL COMMENT ‘用户年龄阶段id,对应常量里的年龄‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘广告位‘;

--
-- 转存表中的数据 `ad_address`
--

INSERT INTO `ad_address` (`id`, `apply_id`, `ad_address_type`, `spec_id`, `ad_page`, `dock_mode`, `media_type`, `ad_min_price`, `cooper_mode`, `ad_css`, `gender`, `user_age_type`, `status`, `create_time`, `apply_type`, `ad_name`, `sdk_key`, `system`, `copper_scale`, `ad_width`, `ad_height`, `ad_bc`, `ad_bw`, `ad_min_price2`, `update_time`, `user_age`) VALUES
(1, 1, 1, 1, ‘男性雄风首页‘, 1, 1, ‘11.00‘, 1, ‘xsdxda‘, 1, 1, 1, ‘0000-00-00 00:00:00‘, 1, ‘测试‘, ‘xxbvhjbxk‘, 1, ‘‘, NULL, NULL, ‘‘, 0, 0.00, ‘0000-00-00 00:00:00‘, ‘0‘),
(2, 2, 2, 1, ‘母婴护理首页‘, 2, 2, ‘11.00‘, 2, ‘xsdxda‘, 2, 2, 2, ‘0000-00-00 00:00:00‘, 3, ‘测试2‘, ‘xxsAJKxaxashbjoxdwqj‘, 1, ‘‘, NULL, NULL, ‘‘, 0, 0.00, ‘0000-00-00 00:00:00‘, ‘0‘),
(3, 3, 2, 1, ‘1xdxc‘, 2, 3, ‘11.00‘, 1, ‘xsdxda‘, 2, 3, 2, ‘0000-00-00 00:00:00‘, 2, ‘策四‘, ‘xaxsaok‘, 2, ‘‘, NULL, NULL, ‘‘, 0, 0.00, ‘0000-00-00 00:00:00‘, ‘0‘),
(4, 1, 1, 1, ‘搜索列表首页‘, 1, 1, ‘11.00‘, 2, ‘xsdxda‘, 1, 2, 0, ‘0000-00-00 00:00:00‘, 1, ‘test‘, ‘53536xaskoxsa‘, 1, ‘12%‘, NULL, NULL, ‘‘, 0, 0.00, ‘2019-09-11 17:40:06‘, ‘0‘),
(5, 2, 1, 1, ‘a‘, 1, 3, ‘12.00‘, 2, NULL, 0, 0, 0, ‘2019-09-09 19:18:39‘, 0, ‘xsxa2‘, ‘E4D4FB2F-D736-220A-45C7-4F88FC852B32‘, 0, ‘10‘, 12, 13, ‘11‘, 0, 0.00, ‘2019-09-11 17:39:38‘, NULL),
(6, 1, 1, 1, ‘测试aa‘, 1, 3, ‘11.00‘, 1, NULL, 0, 0, 2, ‘2019-09-12 15:40:23‘, 0, ‘测试·‘, ‘63F24A20-E798-B6FC-8E5A-453EF6B5500F‘, 0, NULL, 11, 11, ‘1‘, 0, 0.00, ‘2019-09-12 15:40:23‘, NULL);

-- --------------------------------------------------------

--
-- 表的结构 `ad_lists`
--

CREATE TABLE `ad_lists` (
`id` int(11) NOT NULL,
`ad_id` varchar(32) NOT NULL,
`sort` int(11) UNSIGNED NOT NULL,
`image_type` tinyint(1) UNSIGNED NOT NULL COMMENT ‘1为banner2为插屏‘,
`status` tinyint(1) NOT NULL COMMENT ‘合作状态0删除，1合作中，2，已暂停，3已结束，4未开始‘,
`ad_image` int(11) NOT NULL COMMENT ‘素材预览，对应image表id‘,
`image_name` char(100) NOT NULL COMMENT ‘素材名称‘,
`ad_name` char(100) NOT NULL COMMENT ‘广告名称‘,
`ad_type` smallint(5) NOT NULL COMMENT ‘广告类型‘,
`apply_name` char(40) NOT NULL COMMENT ‘应用名‘,
`ad_url` varchar(255) NOT NULL COMMENT ‘广告链接‘,
`media_name` char(40) NOT NULL COMMENT ‘媒体名称‘,
`ad_media_address` varchar(255) NOT NULL COMMENT ‘媒体广告位名称‘,
`ad_term` varchar(255) NOT NULL COMMENT ‘广告限制条件‘,
`ad_business` varchar(20) NOT NULL COMMENT ‘广告商平台简称‘,
`contacts` char(20) NOT NULL COMMENT ‘对接负责人‘,
`mobile` char(50) NOT NULL COMMENT ‘对接负责人电话‘,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘创建时间戳‘,
`refuse_msg` varchar(255) DEFAULT NULL COMMENT ‘审核未通过拒绝原因‘,
`audit_time` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00‘ COMMENT ‘审核时间‘,
`delete_flag` tinyint(1) NOT NULL COMMENT ‘0 正常1删除‘
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘广告素材管理‘;

--
-- 转存表中的数据 `ad_lists`
--

INSERT INTO `ad_lists` (`id`, `ad_id`, `sort`, `image_type`, `status`, `ad_image`, `image_name`, `ad_name`, `ad_type`, `apply_name`, `ad_url`, `media_name`, `ad_media_address`, `ad_term`, `ad_business`, `contacts`, `mobile`, `create_time`, `refuse_msg`, `audit_time`, `delete_flag`) VALUES
(1, ‘ceshi‘, 1, 1, 1, 1, ‘1ccxwxca‘, ‘测试数据‘, 1, ‘三剑客app‘, ‘https://github.com‘, ‘微博首页‘, ‘媒体广告位名称‘, ‘黄色，赌博，毒品‘, ‘腾讯DSP‘, ‘张三‘, ‘13601647048‘, ‘0000-00-00 00:00:00‘, NULL, ‘0000-00-00 00:00:00‘, 0),
(2, ‘csdcsda‘, 1, 1, 2, 1, ‘数据‘, ‘三剑客‘, 2, ‘三剑客app‘, ‘https://github.com‘, ‘微博首页‘, ‘媒体广告位名称‘, ‘黄色，赌博，毒品‘, ‘百度‘, ‘张三‘, ‘13601647048‘, ‘0000-00-00 00:00:00‘, NULL, ‘0000-00-00 00:00:00‘, 0),
(3, ‘csdcsda‘, 1, 2, 3, 1, ‘1ccxwxca‘, ‘三剑客‘, 1, ‘三剑客app‘, ‘https://github.com‘, ‘微博首页‘, ‘媒体广告位名称‘, ‘黄色，赌博，毒品‘, ‘腾讯DSP‘, ‘张三‘, ‘13601647048‘, ‘0000-00-00 00:00:00‘, ‘测试拒绝原因‘, ‘0000-00-00 00:00:00‘, 0);

-- --------------------------------------------------------

--
-- 表的结构 `china`
--

CREATE TABLE `china` (
`Id` int(11) NOT NULL,
`Name` varchar(40) DEFAULT NULL,
`Pid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `china`
--

INSERT INTO `china` (`Id`, `Name`, `Pid`) VALUES
(0, ‘中国‘, 0),
(110000, ‘北京市‘, 0),
(110100, ‘东城区‘, 110000),
(110200, ‘西城区‘, 110000),
(110500, ‘朝阳区‘, 110000),
(110600, ‘丰台区‘, 110000),
(110700, ‘石景山区‘, 110000),
(110800, ‘海淀区‘, 110000),
(110900, ‘门头沟区‘, 110000),
(111100, ‘房山区‘, 110000),
(111200, ‘通州区‘, 110000),
(111300, ‘顺义区‘, 110000),
(111400, ‘昌平区‘, 110000),
(111500, ‘大兴区‘, 110000),
(111600, ‘怀柔区‘, 110000),
(111700, ‘平谷区‘, 110000),
(112800, ‘密云县‘, 110000),
(112900, ‘延庆县‘, 110000),
(120000, ‘天津市‘, 0),
(120100, ‘和平区‘, 120000),
(120200, ‘河东区‘, 120000),
(120300, ‘河西区‘, 120000),
(120400, ‘南开区‘, 120000),
(120500, ‘河北区‘, 120000),
(120600, ‘红桥区‘, 120000),
(120900, ‘滨海新区‘, 120000),
(121000, ‘东丽区‘, 120000),
(121100, ‘西青区‘, 120000),
(121200, ‘津南区‘, 120000),
(121300, ‘北辰区‘, 120000),
(121400, ‘武清区‘, 120000),
(121500, ‘宝坻区‘, 120000),
(122100, ‘宁河县‘, 120000),
(122300, ‘静海县‘, 120000),
(122500, ‘蓟县‘, 120000),
(130000, ‘河北省‘, 0),
(130100, ‘石家庄市‘, 130000),
(130101, ‘市辖区‘, 130100),
(130102, ‘长安区‘, 130101),
(130103, ‘桥东区‘, 130101),
(130104, ‘桥西区‘, 130101),
(130105, ‘新华区‘, 130101),
(130107, ‘井陉矿区‘, 130101),
(130108, ‘裕华区‘, 130101),
(130121, ‘井陉县‘, 130100),
(130123, ‘正定县‘, 130100),
(130124, ‘栾城县‘, 130100),
(130125, ‘行唐县‘, 130100),
(130126, ‘灵寿县‘, 130100),
(130127, ‘高邑县‘, 130100),
(130128, ‘深泽县‘, 130100),
(130129, ‘赞皇县‘, 130100),
(130130, ‘无极县‘, 130100),
(130131, ‘平山县‘, 130100),
(130132, ‘元氏县‘, 130100),
(130133, ‘赵县‘, 130100),
(130181, ‘辛集市‘, 130100),
(130182, ‘藁城市‘, 130100),
(130183, ‘晋州市‘, 130100),
(130184, ‘新乐市‘, 130100),
(130185, ‘鹿泉市‘, 130100),
(130200, ‘唐山市‘, 130000),
(130201, ‘市辖区‘, 130200),
(130202, ‘路南区‘, 130201),
(130203, ‘路北区‘, 130201),
(130204, ‘古冶区‘, 130201),
(130205, ‘开平区‘, 130201),
(130207, ‘丰南区‘, 130201),
(130208, ‘丰润区‘, 130201),
(130223, ‘滦县‘, 130200),
(130224, ‘滦南县‘, 130200),
(130225, ‘乐亭县‘, 130200),
(130227, ‘迁西县‘, 130200),
(130229, ‘玉田县‘, 130200),
(130230, ‘唐海县‘, 130200),
(130281, ‘遵化市‘, 130200),
(130283, ‘迁安市‘, 130200),
(130300, ‘秦皇岛市‘, 130000),
(130301, ‘海港区‘, 130300),
(130303, ‘山海关区‘, 130300),
(130304, ‘北戴河区‘, 130300),
(130321, ‘青龙满族自治县‘, 130300),
(130322, ‘昌黎县‘, 130300),
(130323, ‘抚宁县‘, 130300),
(130324, ‘卢龙县‘, 130300),
(130400, ‘邯郸市‘, 130000),
(130401, ‘市辖区‘, 130400),
(130402, ‘邯山区‘, 130401),
(130403, ‘丛台区‘, 130401),
(130404, ‘复兴区‘, 130401),
(130406, ‘峰峰矿区‘, 130401),
(130421, ‘邯郸县‘, 130400),
(130423, ‘临漳县‘, 130400),
(130424, ‘成安县‘, 130400),
(130425, ‘大名县‘, 130400),
(130426, ‘涉县‘, 130400),
(130427, ‘磁县‘, 130400),
(130428, ‘肥乡县‘, 130400),
(130429, ‘永年县‘, 130400),
(130430, ‘邱县‘, 130400),
(130431, ‘鸡泽县‘, 130400),
(130432, ‘广平县‘, 130400),
(130433, ‘馆陶县‘, 130400),
(130434, ‘魏县‘, 130400),
(130435, ‘曲周县‘, 130400),
(130481, ‘武安市‘, 130400),
(130500, ‘邢台市‘, 130000),
(130501, ‘市辖区‘, 130500),
(130502, ‘桥东区‘, 130501),
(130503, ‘桥西区‘, 130501),
(130521, ‘邢台县‘, 130500),
(130522, ‘临城县‘, 130500),
(130523, ‘内丘县‘, 130500),
(130524, ‘柏乡县‘, 130500),
(130525, ‘隆尧县‘, 130500),
(130526, ‘任县‘, 130500),
(130527, ‘南和县‘, 130500),
(130528, ‘宁晋县‘, 130500),
(130529, ‘巨鹿县‘, 130529),
(130530, ‘新河县‘, 130500),
(130531, ‘广宗县‘, 130500),
(130532, ‘平乡县‘, 130500),
(130533, ‘威县‘, 130500),
(130534, ‘清河县‘, 130500),
(130535, ‘临西县‘, 130500),
(130581, ‘南宫市‘, 130500),
(130582, ‘沙河市‘, 130500),
(130600, ‘保定市‘, 130000),
(130601, ‘新市区‘, 130600),
(130603, ‘北市区‘, 130600),
(130604, ‘南市区‘, 130600),
(130621, ‘满城县‘, 130600),
(130622, ‘清苑县‘, 130600),
(130623, ‘涞水县‘, 130600),
(130624, ‘阜平县‘, 130600),
(130625, ‘徐水县‘, 130600),
(130626, ‘定兴县‘, 130600),
(130627, ‘唐县‘, 130600),
(130628, ‘高阳县‘, 130600),
(130629, ‘容城县‘, 130600),
(130630, ‘涞源县‘, 130600),
(130631, ‘望都县‘, 130600),
(130632, ‘安新县‘, 130600),
(130633, ‘易县‘, 130600),
(130634, ‘曲阳县‘, 130600),
(130635, ‘蠡县‘, 130600),
(130636, ‘顺平县‘, 130600),
(130637, ‘博野县‘, 130600),
(130638, ‘雄县‘, 130600),
(130681, ‘涿州市‘, 130600),
(130682, ‘定州市‘, 130600),
(130683, ‘安国市‘, 130600),
(130684, ‘高碑店市‘, 130600),
(130685, ‘白沟新城县‘, 130600),
(130700, ‘张家口市‘, 130000),
(130701, ‘市辖区‘, 130700),
(130702, ‘桥东区‘, 130701),
(130703, ‘桥西区‘, 130701),
(130705, ‘宣化区‘, 130701),
(130706, ‘下花园区‘, 130701),
(130721, ‘宣化县‘, 130700),
(130722, ‘张北县‘, 130700),
(130723, ‘康保县‘, 130700),
(130724, ‘沽源县‘, 130700),
(130725, ‘尚义县‘, 130700),
(130726, ‘蔚县‘, 130700),
(130727, ‘阳原县‘, 130700),
(130728, ‘怀安县‘, 130700),
(130729, ‘万全县‘, 130700),
(130730, ‘怀来县‘, 130700),
(130731, ‘涿鹿县‘, 130700),
(130732, ‘赤城县‘, 130700),
(130733, ‘崇礼县‘, 130700),
(130800, ‘承德市‘, 130000),
(130801, ‘市辖区‘, 130800),
(130802, ‘双桥区‘, 130801),
(130803, ‘双滦区‘, 130801),
(130804, ‘鹰手营子矿区‘, 130801),
(130821, ‘承德县‘, 130800),
(130822, ‘兴隆县‘, 130800),
(130823, ‘平泉县‘, 130800),
(130824, ‘滦平县‘, 130800),
(130825, ‘隆化县‘, 130800),
(130826, ‘丰宁满族自治县‘, 130800),
(130827, ‘宽城满族自治县‘, 130800),
(130828, ‘围场满族蒙古族自治县‘, 130800),
(130900, ‘沧州市‘, 130000),
(130901, ‘市辖区‘, 130900),
(130902, ‘新华区‘, 130901),
(130903, ‘运河区‘, 130901),
(130921, ‘沧县‘, 130900),
(130922, ‘青县‘, 130900),
(130923, ‘东光县‘, 130900),
(130924, ‘海兴县‘, 130900),
(130925, ‘盐山县‘, 130900),
(130926, ‘肃宁县‘, 130900),
(130927, ‘南皮县‘, 130900),
(130928, ‘吴桥县‘, 130900),
(130929, ‘献县‘, 130900),
(130930, ‘孟村回族自治县‘, 130900),
(130981, ‘泊头市‘, 130900),
(130982, ‘任丘市‘, 130900),
(130983, ‘黄骅市‘, 130900),
(130984, ‘河间市‘, 130900),
(131000, ‘廊坊市‘, 130000),
(131001, ‘市辖区‘, 131000),
(131002, ‘安次区‘, 131001),
(131003, ‘广阳区‘, 131001),
(131022, ‘固安县‘, 131000),
(131023, ‘永清县‘, 131000),
(131024, ‘香河县‘, 131000),
(131025, ‘大城县‘, 131000),
(131026, ‘文安县‘, 131000),
(131028, ‘大厂回族自治县‘, 131000),
(131081, ‘霸州市‘, 131000),
(131082, ‘三河市‘, 131000),
(131100, ‘衡水市‘, 130000),
(131101, ‘市辖区‘, 131100),
(131102, ‘桃城区‘, 131101),
(131121, ‘枣强县‘, 131100),
(131122, ‘武邑县‘, 131100),
(131123, ‘武强县‘, 131100),
(131124, ‘饶阳县‘, 131100),
(131125, ‘安平县‘, 131100),
(131126, ‘故城县‘, 131100),
(131127, ‘景县‘, 131100),
(131128, ‘阜城县‘, 131100),
(131181, ‘冀州市‘, 131100),
(131182, ‘深州市‘, 131100),
(140000, ‘山西省‘, 0),
(140100, ‘太原市‘, 140000),
(140101, ‘市辖区‘, 140100),
(140105, ‘小店区‘, 140101),
(140106, ‘迎泽区‘, 140101),
(140107, ‘杏花岭区‘, 140101),
(140108, ‘尖草坪区‘, 140101),
(140109, ‘万柏林区‘, 140101),
(140110, ‘晋源区‘, 140101),
(140121, ‘清徐县‘, 140100),
(140122, ‘阳曲县‘, 140100),
(140123, ‘娄烦县‘, 140100),
(140181, ‘古交市‘, 140100),
(140200, ‘大同市‘, 140000),
(140201, ‘市辖区‘, 140200),
(140202, ‘城区‘, 140201),
(140203, ‘矿区‘, 140201),
(140211, ‘南郊区‘, 140201),
(140212, ‘新荣区‘, 140201),
(140221, ‘阳高县‘, 140200),
(140222, ‘天镇县‘, 140200),
(140223, ‘广灵县‘, 140200),
(140224, ‘灵丘县‘, 140200),
(140225, ‘浑源县‘, 140200),
(140226, ‘左云县‘, 140200),
(140227, ‘大同县‘, 140200),
(140300, ‘阳泉市‘, 140000),
(140301, ‘市辖区‘, 140300),
(140302, ‘城区‘, 140301),
(140303, ‘矿区‘, 140301),
(140311, ‘郊区‘, 140301),
(140321, ‘平定县‘, 140300),
(140322, ‘盂县‘, 140300),
(140400, ‘长治市‘, 140000),
(140401, ‘市辖区‘, 140400),
(140402, ‘城区‘, 140401),
(140411, ‘郊区‘, 140401),
(140421, ‘长治县‘, 140400),
(140423, ‘襄垣县‘, 140400),
(140424, ‘屯留县‘, 140400),
(140425, ‘平顺县‘, 140400),
(140426, ‘黎城县‘, 140400),
(140427, ‘壶关县‘, 140400),
(140428, ‘长子县‘, 140400),
(140429, ‘武乡县‘, 140400),
(140430, ‘沁县‘, 140400),
(140431, ‘沁源县‘, 140400),
(140481, ‘潞城市‘, 140400),
(140500, ‘晋城市‘, 140000),
(140501, ‘市辖区‘, 140500),
(140502, ‘城区‘, 140501),
(140521, ‘沁水县‘, 140500),
(140522, ‘阳城县‘, 140500),
(140524, ‘陵川县‘, 140500),
(140525, ‘泽州县‘, 140500),
(140581, ‘高平市‘, 140500),
(140600, ‘朔州市‘, 140000),
(140601, ‘市辖区‘, 140600),
(140602, ‘朔城区‘, 140601),
(140603, ‘平鲁区‘, 140601),
(140621, ‘山阴县‘, 140600),
(140622, ‘应县‘, 140600),
(140623, ‘右玉县‘, 140600),
(140624, ‘怀仁县‘, 140600),
(140700, ‘晋中市‘, 140000),
(140701, ‘市辖区‘, 140700),
(140702, ‘榆次区‘, 140701),
(140721, ‘榆社县‘, 140700),
(140722, ‘左权县‘, 140700),
(140723, ‘和顺县‘, 140700),
(140724, ‘昔阳县‘, 140700),
(140725, ‘寿阳县‘, 140700),
(140726, ‘太谷县‘, 140700),
(140727, ‘祁县‘, 140700),
(140728, ‘平遥县‘, 140700),
(140729, ‘灵石县‘, 140700),
(140781, ‘介休市‘, 140700),
(140800, ‘运城市‘, 140000),
(140801, ‘市辖区‘, 140800),
(140802, ‘盐湖区‘, 140801),
(140821, ‘临猗县‘, 140800),
(140822, ‘万荣县‘, 140800),
(140823, ‘闻喜县‘, 140800),
(140824, ‘稷山县‘, 140800),
(140825, ‘新绛县‘, 140800),
(140826, ‘绛县‘, 140800),
(140827, ‘垣曲县‘, 140800),
(140828, ‘夏县‘, 140800),
(140829, ‘平陆县‘, 140800),
(140830, ‘芮城县‘, 140800),
(140881, ‘永济市‘, 140800),
(140882, ‘河津市‘, 140800),
(140900, ‘忻州市‘, 140000),
(140901, ‘忻府区‘, 140900),
(140921, ‘定襄县‘, 140900),
(140922, ‘五台县‘, 140900),
(140923, ‘代县‘, 140900),
(140924, ‘繁峙县‘, 140900),
(140925, ‘宁武县‘, 140900),
(140926, ‘静乐县‘, 140900),
(140927, ‘神池县‘, 140900),
(140928, ‘五寨县‘, 140900),
(140929, ‘岢岚县‘, 140900),
(140930, ‘河曲县‘, 140900),
(140931, ‘保德县‘, 140900),
(140932, ‘偏关县‘, 140900),
(140981, ‘原平市‘, 140900),
(141000, ‘临汾市‘, 140000),
(141001, ‘市辖区‘, 141000),
(141002, ‘尧都区‘, 141000),
(141021, ‘曲沃县‘, 141000),
(141022, ‘翼城县‘, 141000),
(141023, ‘襄汾县‘, 141000),
(141024, ‘洪洞县‘, 141000),
(141025, ‘古县‘, 141000),
(141026, ‘安泽县‘, 141000),
(141027, ‘浮山县‘, 141000),
(141028, ‘吉县‘, 141000),
(141029, ‘乡宁县‘, 141000),
(141030, ‘大宁县‘, 141000),
(141031, ‘隰县‘, 141000),
(141032, ‘永和县‘, 141000),
(141033, ‘蒲县‘, 141000),
(141034, ‘汾西县‘, 141000),
(141081, ‘侯马市‘, 141000),
(141082, ‘霍州市‘, 141000),
(141100, ‘吕梁市‘, 140000),
(141101, ‘市辖区‘, 141100),
(141102, ‘离石区‘, 141101),
(141121, ‘文水县‘, 141100),
(141122, ‘交城县‘, 141100),
(141123, ‘兴县‘, 141100),
(141124, ‘临县‘, 141100),
(141125, ‘柳林县‘, 141100),
(141126, ‘石楼县‘, 141100),
(141127, ‘岚县‘, 141100),
(141128, ‘方山县‘, 141100),
(141129, ‘中阳县‘, 141100),
(141130, ‘交口县‘, 141100),
(141181, ‘孝义市‘, 141100),
(141182, ‘汾阳市‘, 141100),
(150000, ‘内蒙古自治区‘, 0),
(150100, ‘呼和浩特市‘, 150000),
(150101, ‘市辖区‘, 150100),
(150102, ‘新城区‘, 150101),
(150103, ‘回民区‘, 150101),
(150104, ‘玉泉区‘, 150101),
(150105, ‘赛罕区‘, 150101),
(150121, ‘土默特左旗‘, 150100),
(150122, ‘托克托县‘, 150100),
(150123, ‘和林格尔县‘, 150100),
(150124, ‘清水河县‘, 150100),
(150125, ‘武川县‘, 150100),
(150200, ‘包头市‘, 150000),
(150201, ‘市辖区‘, 150200),
(150202, ‘东河区‘, 150201),
(150203, ‘昆都仑区‘, 150201),
(150204, ‘青山区‘, 150201),
(150205, ‘石拐区‘, 150201),
(150206, ‘白云矿区‘, 150201),
(150207, ‘九原区‘, 150201),
(150221, ‘土默特右旗‘, 150200),
(150222, ‘固阳县‘, 150200),
(150223, ‘达尔罕茂明安联合旗‘, 150200),
(150300, ‘乌海市‘, 150000),
(150301, ‘市辖区‘, 150300),
(150302, ‘海勃湾区‘, 150301),
(150303, ‘海南区‘, 150301),
(150304, ‘乌达区‘, 150301),
(150400, ‘赤峰市‘, 150000),
(150401, ‘市辖区‘, 150400),
(150402, ‘红山区‘, 150401),
(150403, ‘元宝山区‘, 150401),
(150404, ‘松山区‘, 150401),
(150421, ‘阿鲁科尔沁旗‘, 150400),
(150422, ‘巴林左旗‘, 150400),
(150423, ‘巴林右旗‘, 150400),
(150424, ‘林西县‘, 150400),
(150425, ‘克什克腾旗‘, 150400),
(150426, ‘翁牛特旗‘, 150400),
(150428, ‘喀喇沁旗‘, 150400),
(150429, ‘宁城县‘, 150400),
(150430, ‘敖汉旗‘, 150400),
(150500, ‘通辽市‘, 150000),
(150501, ‘市辖区‘, 150500),
(150502, ‘科尔沁区‘, 150501),
(150521, ‘科尔沁左翼中旗‘, 150500),
(150522, ‘科尔沁左翼后旗‘, 150500),
(150523, ‘开鲁县‘, 150500),
(150524, ‘库伦旗‘, 150500),
(150525, ‘奈曼旗‘, 150500),
(150526, ‘扎鲁特旗‘, 150500),
(150581, ‘霍林郭勒市‘, 150500),
(150600, ‘鄂尔多斯市‘, 150000),
(150602, ‘东胜区‘, 150600),
(150621, ‘达拉特旗‘, 150600),
(150622, ‘准格尔旗‘, 150600),
(150623, ‘鄂托克前旗‘, 150600),
(150624, ‘鄂托克旗‘, 150600),
(150625, ‘杭锦旗‘, 150600),
(150626, ‘乌审旗‘, 150600),
(150627, ‘伊金霍洛旗‘, 150600),
(150700, ‘呼伦贝尔市‘, 150000),
(150701, ‘市辖区‘, 150700),
(150702, ‘海拉尔区‘, 150701),
(150721, ‘阿荣旗‘, 150700),
(150722, ‘莫力达瓦达斡尔族自治旗‘, 150700),
(150723, ‘鄂伦春自治旗‘, 150700),
(150724, ‘鄂温克族自治旗‘, 150700),
(150725, ‘陈巴尔虎旗‘, 150700),
(150726, ‘新巴尔虎左旗‘, 150700),
(150727, ‘新巴尔虎右旗‘, 150700),
(150781, ‘满洲里市‘, 150700),
(150782, ‘牙克石市‘, 150700),
(150783, ‘扎兰屯市‘, 150700),
(150784, ‘额尔古纳市‘, 150700),
(150785, ‘根河市‘, 150700),
(150800, ‘巴彦淖尔市‘, 150000),
(150801, ‘市辖区‘, 150800),
(150802, ‘临河区‘, 150800),
(150821, ‘五原县‘, 150800),
(150822, ‘磴口县‘, 150800),
(150823, ‘乌拉特前旗‘, 150800),
(150824, ‘乌拉特中旗‘, 150800),
(150825, ‘乌拉特后旗‘, 150800),
(150826, ‘杭锦后旗‘, 150800),
(150900, ‘乌兰察布市‘, 150000),
(150901, ‘市辖区‘, 150900),
(150902, ‘集宁区‘, 150901),
(150921, ‘卓资县‘, 150900),
(150922, ‘化德县‘, 150900),
(150923, ‘商都县‘, 150900),
(150924, ‘兴和县‘, 150900),
(150925, ‘凉城县‘, 150900),
(150926, ‘察哈尔右翼前旗‘, 150900),
(150927, ‘察哈尔右翼中旗‘, 150900),
(150928, ‘察哈尔右翼后旗‘, 150900),
(150929, ‘四子王旗‘, 150900),
(150981, ‘丰镇市‘, 150900),
(152200, ‘兴安盟‘, 150000),
(152201, ‘乌兰浩特市‘, 152200),
(152202, ‘阿尔山市‘, 152200),
(152221, ‘科尔沁右翼前旗‘, 152200),
(152222, ‘科尔沁右翼中旗‘, 152200),
(152223, ‘扎赉特旗‘, 152200),
(152224, ‘突泉县‘, 152200),
(152500, ‘锡林郭勒盟‘, 150000),
(152501, ‘二连浩特市‘, 152500),
(152502, ‘锡林浩特市‘, 152500),
(152522, ‘阿巴嘎旗‘, 152500),
(152523, ‘苏尼特左旗‘, 152500),
(152524, ‘苏尼特右旗‘, 152500),
(152525, ‘东乌珠穆沁旗‘, 152500),
(152526, ‘西乌珠穆沁旗‘, 152500),
(152527, ‘太仆寺旗‘, 152500),
(152528, ‘镶黄旗‘, 152500),
(152529, ‘正镶白旗‘, 152500),
(152530, ‘正蓝旗‘, 152500),
(152531, ‘多伦县‘, 152500),
(152900, ‘阿拉善盟‘, 150000),
(152921, ‘阿拉善左旗‘, 152900),
(152922, ‘阿拉善右旗‘, 152900),
(152923, ‘额济纳旗‘, 152900),
(210000, ‘辽宁省‘, 0),
(210100, ‘沈阳市‘, 210000),
(210101, ‘市辖区‘, 210100),
(210102, ‘和平区‘, 210101),
(210103, ‘沈河区‘, 210101),
(210104, ‘大东区‘, 210101),
(210105, ‘皇姑区‘, 210101),
(210106, ‘铁西区‘, 210101),
(210111, ‘苏家屯区‘, 210101),
(210112, ‘东陵区‘, 210101),
(210113, ‘新城子区‘, 210101),
(210114, ‘于洪区‘, 210101),
(210122, ‘辽中县‘, 210100),
(210123, ‘康平县‘, 210100),
(210124, ‘法库县‘, 210100),
(210181, ‘新民市‘, 210100),
(210182, ‘沈北新区‘, 210100),
(210200, ‘大连市‘, 210000),
(210201, ‘市辖区‘, 210200),
(210202, ‘中山区‘, 210201),
(210203, ‘西岗区‘, 210201),
(210204, ‘沙河口区‘, 210201),
(210211, ‘甘井子区‘, 210201),
(210212, ‘旅顺口区‘, 210201),
(210213, ‘金州区‘, 210201),
(210224, ‘长海县‘, 210200),
(210281, ‘瓦房店市‘, 210200),
(210282, ‘普兰店市‘, 210200),
(210283, ‘庄河市‘, 210200),
(210300, ‘鞍山市‘, 210000),
(210301, ‘市辖区‘, 210300),
(210302, ‘铁东区‘, 210301),
(210303, ‘铁西区‘, 210301),
(210304, ‘立山区‘, 210301),
(210311, ‘千山区‘, 210301),
(210321, ‘台安县‘, 210300),
(210323, ‘岫岩满族自治县‘, 210300),
(210381, ‘海城市‘, 210300),
(210400, ‘抚顺市‘, 210000),
(210401, ‘市辖区‘, 210400),
(210402, ‘新抚区‘, 210401),
(210403, ‘东洲区‘, 210401),
(210404, ‘望花区‘, 210401),
(210411, ‘顺城区‘, 210401),
(210421, ‘抚顺县‘, 210400),
(210422, ‘新宾满族自治县‘, 210400),
(210423, ‘清原满族自治县‘, 210400),
(210500, ‘本溪市‘, 210000),
(210501, ‘市辖区‘, 210500),
(210502, ‘平山区‘, 210501),
(210503, ‘溪湖??‘, 210501),
(210504, ‘明山区‘, 210501),
(210505, ‘南芬区‘, 210501),
(210521, ‘本溪满族自治县‘, 210500),
(210522, ‘桓仁满族自治县‘, 210500),
(210600, ‘丹东市‘, 210000),
(210601, ‘市辖区‘, 210600),
(210602, ‘元宝区‘, 210601),
(210603, ‘振兴区‘, 210601),
(210604, ‘振安区‘, 210601),
(210624, ‘宽甸满族自治县‘, 210600),
(210681, ‘东港市‘, 210600),
(210682, ‘凤城市‘, 210600),
(210700, ‘锦州市‘, 210000),
(210701, ‘市辖区‘, 210700),
(210702, ‘古塔区‘, 210701),
(210703, ‘凌河区‘, 210701),
(210711, ‘太和区‘, 210701),
(210726, ‘黑山县‘, 210700),
(210727, ‘义县‘, 210700),
(210781, ‘凌海市‘, 210700),
(210782, ‘北宁市‘, 210700),
(210800, ‘营口市‘, 210000),
(210801, ‘市辖区‘, 210800),
(210802, ‘站前区‘, 210801),
(210803, ‘西市区‘, 210801),
(210804, ‘鲅鱼圈区‘, 210801),
(210811, ‘老边区‘, 210801),
(210881, ‘盖州市‘, 210800),
(210882, ‘大石桥市‘, 210800),
(210900, ‘阜新市‘, 210000),
(210901, ‘市辖区‘, 210900),
(210902, ‘海州区‘, 210901),
(210903, ‘新邱区‘, 210901),
(210904, ‘太平区‘, 210901),
(210905, ‘清河门区‘, 210901),
(210911, ‘细河区‘, 210901),
(210921, ‘阜新蒙古族自治县‘, 210900),
(210922, ‘彰武县‘, 210900),
(211000, ‘辽阳市‘, 210000),
(211001, ‘市辖区‘, 211000),
(211002, ‘白塔区‘, 211001),
(211003, ‘文圣区‘, 211001),
(211004, ‘宏伟区‘, 211001),
(211005, ‘弓长岭区‘, 211001),
(211011, ‘太子河区‘, 211001),
(211021, ‘辽阳县‘, 211000),
(211081, ‘灯塔市‘, 211000),
(211100, ‘盘锦市‘, 210000),
(211101, ‘市辖区‘, 211100),
(211102, ‘双台子区‘, 211101),
(211103, ‘兴隆台区‘, 211101),
(211121, ‘大洼县‘, 211100),
(211122, ‘盘山县‘, 211100),
(211200, ‘铁岭市‘, 210000),
(211201, ‘市辖区‘, 211200),
(211202, ‘银州区‘, 211201),
(211204, ‘清河区‘, 211201),
(211221, ‘铁岭县‘, 211200),
(211223, ‘西丰县‘, 211200),
(211224, ‘昌图县‘, 211200),
(211281, ‘调兵山市‘, 211200),
(211282, ‘开原市‘, 211200),
(211300, ‘朝阳市‘, 210000),
(211301, ‘市辖区‘, 211300),
(211302, ‘双塔区‘, 211301),
(211303, ‘龙城区‘, 211301),
(211321, ‘朝阳县‘, 211300),
(211322, ‘建平县‘, 211300),
(211324, ‘喀喇沁左翼蒙古族自治县‘, 211300),
(211381, ‘北票市‘, 211300),
(211382, ‘凌源市‘, 211300),
(211400, ‘葫芦岛市‘, 210000),
(211401, ‘市辖区‘, 211400),
(211402, ‘连山区‘, 211401),
(211403, ‘龙港区‘, 211401),
(211404, ‘南票区‘, 211401),
(211421, ‘绥中县‘, 211400),
(211422, ‘建昌县‘, 211400),
(211481, ‘兴城市‘, 211400),
(220000, ‘吉林省‘, 0),
(220100, ‘长春市‘, 220000),
(220101, ‘市辖区‘, 220100),
(220102, ‘南关区‘, 220101),
(220103, ‘宽城区‘, 220101),
(220104, ‘朝阳区‘, 220101),
(220105, ‘二道区‘, 220101),
(220106, ‘绿园区‘, 220101),
(220112, ‘双阳区‘, 220101),
(220122, ‘农安县‘, 220100),
(220181, ‘九台市‘, 220100),
(220182, ‘榆树市‘, 220100),
(220183, ‘德惠市‘, 220100),
(220200, ‘吉林市‘, 220000),
(220201, ‘市辖区‘, 220200),
(220202, ‘昌邑区‘, 220201),
(220203, ‘龙潭区‘, 220201),
(220204, ‘船营区‘, 220201),
(220211, ‘丰满区‘, 220201),
(220221, ‘永吉县‘, 220200),
(220281, ‘蛟河市‘, 220200),
(220282, ‘桦甸市‘, 220200),
(220283, ‘舒兰市‘, 220200),
(220284, ‘磐石市‘, 220200),
(220300, ‘四平市‘, 220000),
(220301, ‘市辖区‘, 220300),
(220302, ‘铁西区‘, 220301),
(220303, ‘铁东区‘, 220301),
(220322, ‘梨树县‘, 220300),
(220323, ‘伊通满族自治县‘, 220300),
(220381, ‘公主岭市‘, 220300),
(220382, ‘双辽市‘, 220300),
(220400, ‘辽源市‘, 220000),
(220401, ‘市辖区‘, 220400),
(220402, ‘龙山区‘, 220401),
(220403, ‘西安区‘, 220401),
(220421, ‘东丰县‘, 220400),
(220422, ‘东辽县‘, 220400),
(220500, ‘通化市‘, 220000),
(220501, ‘市辖区‘, 220500),
(220502, ‘东昌区‘, 220501),
(220503, ‘二道江区‘, 220501),
(220521, ‘通化县‘, 220500),
(220523, ‘辉南县‘, 220500),
(220524, ‘柳河县‘, 220500),
(220581, ‘梅河口市‘, 220500),
(220582, ‘集安市‘, 220500),
(220600, ‘白山市‘, 220000),
(220601, ‘市辖区‘, 220600),
(220602, ‘八道江区‘, 220601),
(220621, ‘抚松县‘, 220600),
(220622, ‘靖宇县‘, 220600),
(220623, ‘长白朝鲜族自治县‘, 220600),
(220625, ‘江源区‘, 220600),
(220681, ‘临江市‘, 220600),
(220700, ‘松原市‘, 220000),
(220701, ‘市辖区‘, 220700),
(220702, ‘宁江区‘, 220701),
(220721, ‘前郭尔罗斯蒙古族自治县‘, 220700),
(220722, ‘长岭县‘, 220700),
(220723, ‘乾安县‘, 220700),
(220724, ‘扶余市‘, 220700),
(220800, ‘白城市‘, 220000),
(220801, ‘市辖区‘, 220800),
(220802, ‘洮北区‘, 220800),
(220821, ‘镇赉县‘, 220800),
(220822, ‘通榆县‘, 220800),
(220881, ‘洮南市‘, 220800),
(220882, ‘大安市‘, 220800),
(222400, ‘延边朝鲜族自治州‘, 220000),
(222401, ‘延吉市‘, 222400),
(222402, ‘图们市‘, 222400),
(222403, ‘敦化市‘, 222400),
(222404, ‘珲春市‘, 222400),
(222405, ‘龙井市‘, 222400),
(222406, ‘和龙市‘, 222400),
(222424, ‘汪清县‘, 222400),
(222426, ‘安图县‘, 222400),
(230000, ‘黑龙江省‘, 0),
(230100, ‘哈尔滨市‘, 230000),
(230101, ‘市辖区‘, 230100),
(230102, ‘道里区‘, 230101),
(230103, ‘南岗区‘, 230101),
(230104, ‘道外区‘, 230101),
(230106, ‘香坊区‘, 230101),
(230107, ‘动力区‘, 230101),
(230108, ‘平房区‘, 230101),
(230109, ‘松北区‘, 230101),
(230111, ‘呼兰区‘, 230101),
(230123, ‘依兰县‘, 230100),
(230124, ‘方正县‘, 230100),
(230125, ‘宾县‘, 230100),
(230126, ‘巴彦县‘, 230100),
(230127, ‘木兰县‘, 230100),
(230128, ‘通河县‘, 230100),
(230129, ‘延寿县‘, 230100),
(230181, ‘阿城市‘, 230100),
(230182, ‘双城市‘, 230100),
(230183, ‘尚志市‘, 230100),
(230184, ‘五常市‘, 230100),
(230200, ‘齐齐哈尔市‘, 230000),
(230201, ‘市辖区‘, 230200),
(230202, ‘龙沙区‘, 230201),
(230203, ‘建华区‘, 230201),
(230204, ‘铁锋区‘, 230201),
(230205, ‘昂昂溪区‘, 230201),
(230206, ‘富拉尔基区‘, 230201),
(230207, ‘碾子山区‘, 230201),
(230208, ‘梅里斯达斡尔族区‘, 230201),
(230221, ‘龙江县‘, 230200),
(230223, ‘依安县‘, 230200),
(230224, ‘泰来县‘, 230200),
(230225, ‘甘南县‘, 230200),
(230227, ‘富裕县‘, 230200),
(230229, ‘克山县‘, 230200),
(230230, ‘克东县‘, 230200),
(230231, ‘拜泉县‘, 230200),
(230281, ‘讷河市‘, 230200),
(230300, ‘鸡西市‘, 230000),
(230301, ‘市辖区‘, 230300),
(230302, ‘鸡冠区‘, 230301),
(230303, ‘恒山区‘, 230301),
(230304, ‘滴道区‘, 230301),
(230305, ‘梨树区‘, 230301),
(230306, ‘城子河区‘, 230301),
(230307, ‘麻山区‘, 230301),
(230321, ‘鸡东县‘, 230300),
(230381, ‘虎林市‘, 230300),
(230382, ‘密山市‘, 230300),
(230400, ‘鹤岗市‘, 230000),
(230401, ‘市辖区‘, 230400),
(230402, ‘向阳区‘, 230401),
(230403, ‘工农区‘, 230401),
(230404, ‘南山区‘, 230401),
(230405, ‘兴安区‘, 230401),
(230406, ‘东山区‘, 230401),
(230407, ‘兴山区‘, 230401),
(230421, ‘萝北县‘, 230400),
(230422, ‘绥滨县‘, 230400),
(230500, ‘双鸭山市‘, 230000),
(230501, ‘市辖区‘, 230500),
(230502, ‘尖山区‘, 230501),
(230503, ‘岭东区‘, 230501),
(230505, ‘四方台区‘, 230501),
(230506, ‘宝山区‘, 230501),
(230521, ‘集贤县‘, 230500),
(230522, ‘友谊县‘, 230500),
(230523, ‘宝清县‘, 230500),
(230524, ‘饶河县‘, 230500),
(230600, ‘大庆市‘, 230000),
(230601, ‘市辖区‘, 230600),
(230602, ‘萨尔图区‘, 230601),
(230603, ‘龙凤区‘, 230601),
(230604, ‘让胡路区‘, 230601),
(230605, ‘红岗区‘, 230601),
(230606, ‘大同区‘, 230601),
(230621, ‘肇州县‘, 230600),
(230622, ‘肇源县‘, 230600),
(230623, ‘林甸县‘, 230600),
(230624, ‘杜尔伯特蒙古族自治县‘, 230600),
(230700, ‘伊春市‘, 230000),
(230701, ‘市辖区‘, 230700),
(230702, ‘伊春区‘, 230701),
(230703, ‘南岔区‘, 230701),
(230704, ‘友好区‘, 230701),
(230705, ‘西林区‘, 230701),
(230706, ‘翠峦区‘, 230701),
(230707, ‘新青区‘, 230701),
(230708, ‘美溪区‘, 230701),
(230709, ‘金山屯区‘, 230701),
(230710, ‘五营区‘, 230701),
(230711, ‘乌马河区‘, 230701),
(230712, ‘汤旺河区‘, 230701),
(230713, ‘带岭区‘, 230701),
(230714, ‘乌伊岭区‘, 230701),
(230715, ‘红星区‘, 230701),
(230716, ‘上甘岭区‘, 230701),
(230722, ‘嘉荫县‘, 230700),
(230781, ‘铁力市‘, 230700),
(230800, ‘佳木斯市‘, 230000),
(230801, ‘市辖区‘, 230800),
(230803, ‘向阳区‘, 230801),
(230804, ‘前进区‘, 230801),
(230805, ‘东风区‘, 230801),
(230811, ‘郊区‘, 230801),
(230822, ‘桦南县‘, 230800),
(230826, ‘桦川县‘, 230800),
(230828, ‘汤原县‘, 230800),
(230833, ‘抚远县‘, 230800),
(230881, ‘同江市‘, 230800),
(230882, ‘富锦市‘, 230800),
(230900, ‘七台河市‘, 230000),
(230901, ‘市辖区‘, 230900),
(230902, ‘新兴区‘, 230901),
(230903, ‘桃山区‘, 230901),
(230904, ‘茄子河区‘, 230901),
(230921, ‘勃利县‘, 230900),
(231000, ‘牡丹江市‘, 230000),
(231001, ‘市辖区‘, 231000),
(231002, ‘东安区‘, 231001),
(231003, ‘阳明区‘, 231001),
(231004, ‘爱民区‘, 231001),
(231005, ‘西安区‘, 231001),
(231024, ‘东宁县‘, 231000),
(231025, ‘林口县‘, 231000),
(231081, ‘绥芬河市‘, 231000),
(231083, ‘海林市‘, 231000),
(231084, ‘宁安市‘, 231000),
(231085, ‘穆棱市‘, 231000),
(231100, ‘黑河市‘, 230000),
(231101, ‘市辖区‘, 231100),
(231102, ‘爱辉区‘, 231101),
(231121, ‘嫩江县‘, 231100),
(231123, ‘逊克县‘, 231100),
(231124, ‘孙吴县‘, 231100),
(231181, ‘北安市‘, 231100),
(231182, ‘五大连池市‘, 231100),
(231200, ‘绥化市‘, 230000),
(231201, ‘北林区‘, 231200),
(231221, ‘望奎县‘, 231200),
(231222, ‘兰西县‘, 231200),
(231223, ‘青冈县‘, 231200),
(231224, ‘庆安县‘, 231200),
(231225, ‘明水县‘, 231200),
(231226, ‘绥棱县‘, 231200),
(231281, ‘安达市‘, 231200),
(231282, ‘肇东市‘, 231200),
(231283, ‘海伦市‘, 231200),
(232700, ‘大兴安岭地区‘, 230000),
(232701, ‘加格达奇区‘, 232700),
(232702, ‘松岭区‘, 232700),
(232703, ‘新林区‘, 232700),
(232704, ‘呼中区‘, 232700),
(232721, ‘呼玛县‘, 232700),
(232722, ‘塔河县‘, 232700),
(232723, ‘漠河县‘, 232700),
(310000, ‘上海市‘, 0),
(310100, ‘黄浦区‘, 310000),
(310300, ‘卢湾区‘, 310000),
(310400, ‘徐汇区‘, 310000),
(310500, ‘长宁区‘, 310000),
(310600, ‘静安区‘, 310000),
(310700, ‘普陀区‘, 310000),
(310800, ‘闸北区‘, 310000),
(310900, ‘虹口区‘, 310000),
(311000, ‘杨浦区‘, 310000),
(311200, ‘闵行区‘, 310000),
(311300, ‘宝山区‘, 310000),
(311400, ‘嘉定区‘, 310000),
(311500, ‘浦东新区‘, 310000),
(311600, ‘金山区‘, 310000),
(311700, ‘松江区‘, 310000),
(311800, ‘青浦区‘, 310000),
(311900, ‘南汇区‘, 310000),
(312000, ‘奉贤区‘, 310000),
(313000, ‘崇明县‘, 310000),
(320000, ‘江苏省‘, 0),
(320100, ‘南京市‘, 320000),
(320101, ‘市辖区‘, 320100),
(320102, ‘玄武区‘, 320101),
(320103, ‘白下区‘, 320101),
(320104, ‘秦淮区‘, 320101),
(320105, ‘建邺区‘, 320101),
(320106, ‘鼓楼区‘, 320101),
(320107, ‘下关区‘, 320101),
(320111, ‘浦口区‘, 320101),
(320113, ‘栖霞区‘, 320101),
(320114, ‘雨花台区‘, 320101),
(320115, ‘江宁区‘, 320101),
(320116, ‘六合区‘, 320101),
(320124, ‘溧水区‘, 320100),
(320125, ‘高淳区‘, 320100),
(320200, ‘无锡市‘, 320000),
(320201, ‘市辖区‘, 320200),
(320202, ‘崇安区‘, 320201),
(320203, ‘南长区‘, 320201),
(320204, ‘北塘区‘, 320201),
(320205, ‘锡山区‘, 320201),
(320206, ‘惠山区‘, 320201),
(320211, ‘滨湖区‘, 320201),
(320281, ‘江阴市‘, 320200),
(320282, ‘宜兴市‘, 320200),
(320300, ‘徐州市‘, 320000),
(320301, ‘泉山区‘, 320300),
(320302, ‘鼓楼区‘, 320300),
(320303, ‘云龙区‘, 320300),
(320304, ‘九里区‘, 320301),
(320305, ‘贾汪区‘, 320300),
(320321, ‘丰县‘, 320300),
(320322, ‘沛县‘, 320300),
(320323, ‘铜山县‘, 320300),
(320324, ‘睢宁县‘, 320300),
(320381, ‘新沂市‘, 320300),
(320382, ‘邳州市‘, 320300),
(320400, ‘常州市‘, 320000),
(320401, ‘市辖区‘, 320400),
(320402, ‘天宁区‘, 320401),
(320404, ‘钟楼区‘, 320401),
(320405, ‘戚墅堰区‘, 320401),
(320411, ‘新北区‘, 320401),
(320412, ‘武进区‘, 320401),
(320481, ‘溧阳市‘, 320400),
(320482, ‘金坛市‘, 320400),
(320500, ‘苏州市‘, 320000),
(320501, ‘市辖区‘, 320500),
(320502, ‘沧浪区‘, 320501),
(320503, ‘平江区‘, 320501),
(320504, ‘金阊区‘, 320501),
(320505, ‘虎丘区‘, 320501),
(320506, ‘吴中区‘, 320501),
(320507, ‘相城区‘, 320501),
(320581, ‘常熟市‘, 320500),
(320582, ‘张家港市‘, 320500),
(320583, ‘昆山市‘, 320500),
(320584, ‘吴江市‘, 320500),
(320585, ‘太仓市‘, 320500),
(320600, ‘南通市‘, 320000),
(320601, ‘市辖区‘, 320600),
(320602, ‘崇川区‘, 320601),
(320611, ‘港闸区‘, 320601),
(320621, ‘海安县‘, 320600),
(320623, ‘如东县‘, 320600),
(320681, ‘启东市‘, 320600),
(320682, ‘如皋市‘, 320600),
(320683, ‘通州市‘, 320600),
(320684, ‘海门市‘, 320600),
(320700, ‘连云港市‘, 320000),
(320701, ‘市辖区‘, 320700),
(320703, ‘连云区‘, 320701),
(320705, ‘新浦区‘, 320701),
(320706, ‘海州区‘, 320701),
(320721, ‘赣榆县‘, 320700),
(320722, ‘东海县‘, 320700),
(320723, ‘灌云县‘, 320700),
(320724, ‘灌南县‘, 320700),
(320800, ‘淮安市‘, 320000),
(320801, ‘市辖区‘, 320800),
(320802, ‘清河区‘, 320801),
(320803, ‘楚州区‘, 320801),
(320804, ‘淮阴区‘, 320801),
(320811, ‘清浦区‘, 320801),
(320826, ‘涟水县‘, 320800),
(320829, ‘洪泽县‘, 320800),
(320830, ‘盱眙县‘, 320800),
(320831, ‘金湖县‘, 320800),
(320900, ‘盐城市‘, 320000),
(320901, ‘市辖区‘, 320900),
(320902, ‘亭湖区‘, 320901),
(320903, ‘盐都区‘, 320901),
(320921, ‘响水县‘, 320900),
(320922, ‘滨海县‘, 320900),
(320923, ‘阜宁县‘, 320900),
(320924, ‘射阳县‘, 320900),
(320925, ‘建湖县‘, 320900),
(320981, ‘东台市‘, 320900),
(320982, ‘大丰市‘, 320900),
(321000, ‘扬州市‘, 320000),
(321001, ‘市辖区‘, 321000),
(321002, ‘广陵区‘, 321001),
(321003, ‘邗江区‘, 321001),
(321011, ‘维扬区‘, 321001),
(321023, ‘宝应县‘, 321000),
(321081, ‘仪征市‘, 321000),
(321084, ‘高邮市‘, 321000),
(321088, ‘江都市‘, 321000),
(321100, ‘镇江市‘, 320000),
(321101, ‘市辖区‘, 321100),
(321102, ‘京口区‘, 321101),
(321111, ‘润州区‘, 321101),
(321112, ‘丹徒区‘, 321101),
(321181, ‘丹阳市‘, 321100),
(321182, ‘扬中市‘, 321100),
(321183, ‘句容市‘, 321100),
(321200, ‘泰州市‘, 320000),
(321201, ‘市辖区‘, 321200),
(321202, ‘海陵区‘, 321201),
(321203, ‘高港区‘, 321201),
(321281, ‘兴化市‘, 321200),
(321282, ‘靖江市‘, 321200),
(321283, ‘泰兴市‘, 321200),
(321284, ‘姜堰市‘, 321200),
(321300, ‘宿迁市‘, 320000),
(321301, ‘市辖区‘, 321300),
(321302, ‘宿城区‘, 321301),
(321311, ‘宿豫区‘, 321301),
(321322, ‘沭阳县‘, 321300),
(321323, ‘泗阳县‘, 321300),
(321324, ‘泗洪县‘, 321300),
(330000, ‘浙江省‘, 0),
(330100, ‘杭州市‘, 330000),
(330101, ‘市辖区‘, 330100),
(330