/*

Navicat MySQL Data Transfer

Source Server : 本地

Source Server Version : 50520

Source Host : localhost:3306

Source Database : cmswing

Target Server Type : MYSQL

Target Server Version : 50520

File Encoding : 65001

Date: 2016-04-09 16:28:13

*/

SET FOREIGN_KEY_CHECKS=0;

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

-- Table structure for cmswing_action

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

DROP TABLE IF EXISTS `cmswing_action`;

CREATE TABLE `cmswing_action` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',

`name` char(30) NOT NULL DEFAULT '' COMMENT '行为唯一标识',

`title` char(80) NOT NULL DEFAULT '' COMMENT '行为说明',

`remark` char(140) NOT NULL DEFAULT '' COMMENT '行为描述',

`rule` text COMMENT '行为规则',

`log` text COMMENT '日志规则',

`type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型',

`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',

`update_time` bigint(13) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统行为表';

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

-- Records of cmswing_action

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

INSERT INTO `cmswing_action` VALUES ('1', 'user_login', '用户登录', '积分+10，每天一次', 'table:member|field:score|condition:id=${self} AND status>-1|rule:10|cycle:24|max:1;', '[user|get_nickname]在[time|time_format]登录了后台', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('2', 'add_article', '发布文章', '积分+5，每天上限5次', 'table:member|field:score|condition:id=${self}|rule:5|cycle:24|max:5', '', '2', '0', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('3', 'review', '评论', '评论积分+1，无限制', 'table:member|field:score|condition:id=${self}|rule:1', '', '2', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('4', 'add_document', '发表文档', '积分+10，每天上限5次', 'table:member|field:score|condition:id=${self}|rule:10|cycle:24|max:5', '[user|get_nickname]在[time|time_format]发表了一篇文章。\r\n表[model]，记录编号[record]。', '2', '1', '1458985259863');

INSERT INTO `cmswing_action` VALUES ('5', 'add_document_topic', '发表讨论', '积分+5，每天上限10次', 'table:member|field:score|condition:id=${self}|rule:5|cycle:24|max:10', '', '2', '0', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('6', 'update_config', '更新配置', '新增或修改或删除配置', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('7', 'update_model', '更新模型', '新增或修改模型', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('8', 'update_attribute', '更新属性', '新增或更新或删除属性', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('9', 'update_channel', '更新导航', '新增或修改或删除导航', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('10', 'update_menu', '更新菜单', '新增或修改或删除菜单', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('11', 'update_category', '更新分类', '新增或修改或删除分类', '', '', '1', '1', '1452591992289');

INSERT INTO `cmswing_action` VALUES ('13', 'testaction', '测试行为日志', '积分+10，每天一次1111', 'table:member|field:score|condition:id=${self} AND status>-1|rule:10|cycle:24|max:1;', '[user|get_nickname]在[time|time_format]测试了日志[model]和[record]和[data]', '2', '1', '1452594160564');

INSERT INTO `cmswing_action` VALUES ('14', 'order', '订单日志', '修改订单时记录', '', '[user|get_nickname]在[time|time_format],[record]', '2', '1', '1458986486185');

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

-- Table structure for cmswing_action_log

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

DROP TABLE IF EXISTS `cmswing_action_log`;

CREATE TABLE `cmswing_action_log` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',

`action_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',

`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',

`action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',

`model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',

`record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',

`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',

`status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',

`create_time` bigint(13) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',

PRIMARY KEY (`id`),

KEY `action_ip_ix` (`action_ip`),

KEY `action_id_ix` (`action_id`),

KEY `user_id_ix` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=490 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

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

-- Records of cmswing_action_log

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

INSERT INTO `cmswing_action_log` VALUES ('311', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-07 17:00:34登录了后台', '1', '1457341234073');

INSERT INTO `cmswing_action_log` VALUES ('312', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-07 17:02:32登录了后台', '1', '1457341352889');

INSERT INTO `cmswing_action_log` VALUES ('313', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-07 18:35:51登录了后台', '1', '1457346951575');

INSERT INTO `cmswing_action_log` VALUES ('314', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-07 18:45:29登录了后台', '1', '1457347529369');

INSERT INTO `cmswing_action_log` VALUES ('315', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-08 09:32:36登录了后台', '1', '1457400756170');

INSERT INTO `cmswing_action_log` VALUES ('316', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-08 13:11:29登录了后台', '1', '1457413889573');

INSERT INTO `cmswing_action_log` VALUES ('317', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-08 14:33:11登录了后台', '1', '1457418791494');

INSERT INTO `cmswing_action_log` VALUES ('318', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-08 14:36:26登录了后台', '1', '1457418986623');

INSERT INTO `cmswing_action_log` VALUES ('319', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-08 20:21:57登录了后台', '1', '1457439717461');

INSERT INTO `cmswing_action_log` VALUES ('320', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 09:02:29登录了后台', '1', '1457485349516');

INSERT INTO `cmswing_action_log` VALUES ('321', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 09:27:01登录了后台', '1', '1457486821263');

INSERT INTO `cmswing_action_log` VALUES ('322', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 09:48:27登录了后台', '1', '1457488107006');

INSERT INTO `cmswing_action_log` VALUES ('323', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 11:06:54登录了后台', '1', '1457492814389');

INSERT INTO `cmswing_action_log` VALUES ('324', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 15:32:41登录了后台', '1', '1457508761367');

INSERT INTO `cmswing_action_log` VALUES ('325', '4', '1', '2130706433', 'document', '71', 'admin在2016-03-09 16:05:24发表了一篇文章。\r\n表document，记录编号71。fdsfsa', '1', '1457510724126');

INSERT INTO `cmswing_action_log` VALUES ('326', '4', '1', '2130706433', 'document', '72', 'admin在2016-03-09 16:12:04发表了一篇文章。\r\n表document，记录编号72。fdsfsa', '1', '1457511124158');

INSERT INTO `cmswing_action_log` VALUES ('327', '4', '1', '2130706433', 'document', '73', 'admin在2016-03-09 16:14:09发表了一篇文章。\r\n表document，记录编号73。fdsfsa', '1', '1457511249204');

INSERT INTO `cmswing_action_log` VALUES ('328', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 16:23:24登录了后台', '1', '1457511804632');

INSERT INTO `cmswing_action_log` VALUES ('329', '4', '1', '2130706433', 'document', '74', 'admin在2016-03-09 16:20:53发表了一篇文章。\r\n表document，记录编号74。fdsfsa', '1', '1457511653858');

INSERT INTO `cmswing_action_log` VALUES ('330', '4', '1', '2130706433', 'document', '75', 'admin在2016-03-09 16:28:13发表了一篇文章。\r\n表document，记录编号75。fdsfsa', '1', '1457512093518');

INSERT INTO `cmswing_action_log` VALUES ('331', '4', '1', '2130706433', 'document', '76', 'admin在2016-03-09 16:41:01发表了一篇文章。\r\n表document，记录编号76。fdsfsa', '1', '1457512861966');

INSERT INTO `cmswing_action_log` VALUES ('332', '4', '1', '2130706433', 'document', '77', 'admin在2016-03-09 16:42:30发表了一篇文章。\r\n表document，记录编号77。fdsfsa', '1', '1457512950829');

INSERT INTO `cmswing_action_log` VALUES ('333', '4', '1', '2130706433', 'document', '78', 'admin在2016-03-09 17:01:24发表了一篇文章。\r\n表document，记录编号78。fdsfsa', '1', '1457514084933');

INSERT INTO `cmswing_action_log` VALUES ('334', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-09 18:04:13登录了后台', '1', '1457517853502');

INSERT INTO `cmswing_action_log` VALUES ('335', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-10 09:08:47登录了后台', '1', '1457572127039');

INSERT INTO `cmswing_action_log` VALUES ('336', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-10 09:18:06登录了后台', '1', '1457572686636');

INSERT INTO `cmswing_action_log` VALUES ('337', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-10 09:59:36登录了后台', '1', '1457575176049');

INSERT INTO `cmswing_action_log` VALUES ('338', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-10 11:12:55登录了后台', '1', '1457579575257');

INSERT INTO `cmswing_action_log` VALUES ('339', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-10 13:59:23登录了后台', '1', '1457589563668');

INSERT INTO `cmswing_action_log` VALUES ('340', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 08:36:58登录了后台', '1', '1457656618181');

INSERT INTO `cmswing_action_log` VALUES ('341', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 09:09:35登录了后台', '1', '1457658575385');

INSERT INTO `cmswing_action_log` VALUES ('342', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 08:58:06登录了后台', '1', '1457657886433');

INSERT INTO `cmswing_action_log` VALUES ('343', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 08:58:06登录了后台', '1', '1457657886436');

INSERT INTO `cmswing_action_log` VALUES ('344', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 11:35:20登录了后台', '1', '1457667320286');

INSERT INTO `cmswing_action_log` VALUES ('345', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 18:03:53登录了后台', '1', '1457690633435');

INSERT INTO `cmswing_action_log` VALUES ('346', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-11 18:03:53登录了后台', '1', '1457690633860');

INSERT INTO `cmswing_action_log` VALUES ('347', '4', '1', '2130706433', 'document', '79', 'admin在2016-03-11 20:26:34发表了一篇文章。\r\n表document，记录编号79。fdsfsa', '1', '1457699194360');

INSERT INTO `cmswing_action_log` VALUES ('348', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-12 09:01:33登录了后台', '1', '1457744493895');

INSERT INTO `cmswing_action_log` VALUES ('349', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-12 09:07:18登录了后台', '1', '1457744838182');

INSERT INTO `cmswing_action_log` VALUES ('350', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-12 11:22:29登录了后台', '1', '1457752949925');

INSERT INTO `cmswing_action_log` VALUES ('351', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-12 14:06:15登录了后台', '1', '1457762775844');

INSERT INTO `cmswing_action_log` VALUES ('352', '4', '1', '2130706433', 'document', '80', 'admin在2016-03-12 19:01:14发表了一篇文章。\r\n表document，记录编号80。fdsfsa', '1', '1457780474273');

INSERT INTO `cmswing_action_log` VALUES ('353', '4', '1', '2130706433', 'document', '81', 'admin在2016-03-12 19:06:17发表了一篇文章。\r\n表document，记录编号81。fdsfsa', '1', '1457780777344');

INSERT INTO `cmswing_action_log` VALUES ('354', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-12 19:19:37登录了后台', '1', '1457781577831');

INSERT INTO `cmswing_action_log` VALUES ('355', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 08:55:05登录了后台', '1', '1457916905814');

INSERT INTO `cmswing_action_log` VALUES ('356', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 10:31:32登录了后台', '1', '1457922692333');

INSERT INTO `cmswing_action_log` VALUES ('357', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:08:25登录了后台', '1', '1457924905294');

INSERT INTO `cmswing_action_log` VALUES ('358', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:08:25登录了后台', '1', '1457924905297');

INSERT INTO `cmswing_action_log` VALUES ('359', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:20:28登录了后台', '1', '1457925628386');

INSERT INTO `cmswing_action_log` VALUES ('360', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:23:08登录了后台', '1', '1457925788062');

INSERT INTO `cmswing_action_log` VALUES ('361', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:27:38登录了后台', '1', '1457926058245');

INSERT INTO `cmswing_action_log` VALUES ('362', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:33:21登录了后台', '1', '1457926401392');

INSERT INTO `cmswing_action_log` VALUES ('363', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 11:35:15登录了后台', '1', '1457926515031');

INSERT INTO `cmswing_action_log` VALUES ('364', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:01:14登录了后台', '1', '1457938874935');

INSERT INTO `cmswing_action_log` VALUES ('365', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:04:05登录了后台', '1', '1457939045448');

INSERT INTO `cmswing_action_log` VALUES ('366', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:16:40登录了后台', '1', '1457939800912');

INSERT INTO `cmswing_action_log` VALUES ('367', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:24:20登录了后台', '1', '1457940260810');

INSERT INTO `cmswing_action_log` VALUES ('368', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:27:01登录了后台', '1', '1457940421492');

INSERT INTO `cmswing_action_log` VALUES ('369', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:28:14登录了后台', '1', '1457940494513');

INSERT INTO `cmswing_action_log` VALUES ('370', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:29:04登录了后台', '1', '1457940544803');

INSERT INTO `cmswing_action_log` VALUES ('371', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:29:51登录了后台', '1', '1457940591553');

INSERT INTO `cmswing_action_log` VALUES ('372', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:31:13登录了后台', '1', '1457940673714');

INSERT INTO `cmswing_action_log` VALUES ('373', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:32:51登录了后台', '1', '1457940771270');

INSERT INTO `cmswing_action_log` VALUES ('374', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:33:08登录了后台', '1', '1457940788885');

INSERT INTO `cmswing_action_log` VALUES ('375', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:38:50登录了后台', '1', '1457941130836');

INSERT INTO `cmswing_action_log` VALUES ('376', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-14 15:42:00登录了后台', '1', '1457941320591');

INSERT INTO `cmswing_action_log` VALUES ('377', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-15 09:01:36登录了后台', '1', '1458003696354');

INSERT INTO `cmswing_action_log` VALUES ('378', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-16 08:52:22登录了后台', '1', '1458089542473');

INSERT INTO `cmswing_action_log` VALUES ('379', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-16 14:52:27登录了后台', '1', '1458111147397');

INSERT INTO `cmswing_action_log` VALUES ('380', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-18 13:56:31登录了后台', '1', '1458280591124');

INSERT INTO `cmswing_action_log` VALUES ('381', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-18 19:36:08登录了后台', '1', '1458300968414');

INSERT INTO `cmswing_action_log` VALUES ('382', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-18 20:23:21登录了后台', '1', '1458303801739');

INSERT INTO `cmswing_action_log` VALUES ('383', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-18 22:27:34登录了后台', '1', '1458311254160');

INSERT INTO `cmswing_action_log` VALUES ('384', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-19 09:31:48登录了后台', '1', '1458351108940');

INSERT INTO `cmswing_action_log` VALUES ('385', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-19 10:17:39登录了后台', '1', '1458353859977');

INSERT INTO `cmswing_action_log` VALUES ('386', '4', '1', '2130706433', 'document', '82', 'admin在2016-03-19 21:35:50发表了一篇文章。\r\n表document，记录编号82。fdsfsa', '1', '1458394550734');

INSERT INTO `cmswing_action_log` VALUES ('387', '4', '1', '2130706433', 'document', '83', 'admin在2016-03-19 21:59:36发表了一篇文章。\r\n表document，记录编号83。fdsfsa', '1', '1458395976760');

INSERT INTO `cmswing_action_log` VALUES ('388', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-21 13:58:52登录了后台', '1', '1458539932241');

INSERT INTO `cmswing_action_log` VALUES ('389', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-21 18:28:25登录了后台', '1', '1458556105740');

INSERT INTO `cmswing_action_log` VALUES ('390', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-22 10:02:18登录了后台', '1', '1458612138962');

INSERT INTO `cmswing_action_log` VALUES ('391', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-22 14:48:59登录了后台', '1', '1458629339460');

INSERT INTO `cmswing_action_log` VALUES ('392', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-22 17:43:29登录了后台', '1', '1458639809274');

INSERT INTO `cmswing_action_log` VALUES ('393', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-23 11:01:41登录了后台', '1', '1458702101987');

INSERT INTO `cmswing_action_log` VALUES ('394', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-23 11:56:43登录了后台', '1', '1458705403283');

INSERT INTO `cmswing_action_log` VALUES ('395', '4', '1', '2130706433', 'document', '84', 'admin在2016-03-23 19:00:59发表了一篇文章。\r\n表document，记录编号84。fdsfsa', '1', '1458730859605');

INSERT INTO `cmswing_action_log` VALUES ('396', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-24 11:03:01登录了后台', '1', '1458788581037');

INSERT INTO `cmswing_action_log` VALUES ('397', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-24 11:06:19登录了后台', '1', '1458788779006');

INSERT INTO `cmswing_action_log` VALUES ('398', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-25 16:26:23登录了后台', '1', '1458894383721');

INSERT INTO `cmswing_action_log` VALUES ('399', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-25 16:28:05登录了后台', '1', '1458894485925');

INSERT INTO `cmswing_action_log` VALUES ('400', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-25 20:28:24登录了后台', '1', '1458908904449');

INSERT INTO `cmswing_action_log` VALUES ('401', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-26 15:42:18登录了后台', '1', '1458978138961');

INSERT INTO `cmswing_action_log` VALUES ('402', '14', '1', '2130706433', 'fdsf', '222', 'admin在2016-03-26 17:50:27测试了日志fdsf和222和[object Object]', '1', '1458985827988');

INSERT INTO `cmswing_action_log` VALUES ('403', '14', '1', '2130706433', '1458725553803', '222', 'admin在2016-03-26 17:51:30测试了日志1458725553803和222和[object Object]', '1', '1458985890720');

INSERT INTO `cmswing_action_log` VALUES ('404', '14', '1', '2130706433', 'order', '0', 'admin在2016-03-26 17:57:52,修改了订单，订单编号：1458722092073，并调整订单金额5', '1', '1458986272319');

INSERT INTO `cmswing_action_log` VALUES ('405', '14', '1', '2130706433', 'order', '0', 'admin在2016-03-26 18:00:21,修改了订单，订单编号：1458721606032，并调整订单金额 6 元，原订单金额：120 元，调整后订单金额：126 元', '1', '1458986421638');

INSERT INTO `cmswing_action_log` VALUES ('406', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-26 20:16:21登录了后台', '1', '1458994581646');

INSERT INTO `cmswing_action_log` VALUES ('407', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-26 20:17:54登录了后台', '1', '1458994674652');

INSERT INTO `cmswing_action_log` VALUES ('408', '1', '8', '2130706433', 'member', '8', 'arterli在2016-03-26 20:22:10登录了后台', '1', '1458994930196');

INSERT INTO `cmswing_action_log` VALUES ('409', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-26 20:36:49登录了后台', '1', '1458995809868');

INSERT INTO `cmswing_action_log` VALUES ('410', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-26 20:54:11登录了后台', '1', '1458996851145');

INSERT INTO `cmswing_action_log` VALUES ('411', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-27 11:02:53登录了后台', '1', '1459047773055');

INSERT INTO `cmswing_action_log` VALUES ('412', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-27 11:03:56登录了后台', '1', '1459047836426');

INSERT INTO `cmswing_action_log` VALUES ('413', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-28 02:33:20登录了后台', '1', '1459103600875');

INSERT INTO `cmswing_action_log` VALUES ('414', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-28 03:00:08登录了后台', '1', '1459105208802');

INSERT INTO `cmswing_action_log` VALUES ('415', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-28 03:42:55登录了后台', '1', '1459107775836');

INSERT INTO `cmswing_action_log` VALUES ('416', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-28 05:47:12登录了后台', '1', '1459115232473');

INSERT INTO `cmswing_action_log` VALUES ('417', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-29 21:46:40登录了后台', '1', '1459259200759');

INSERT INTO `cmswing_action_log` VALUES ('418', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-30 00:55:11登录了后台', '1', '1459270511656');

INSERT INTO `cmswing_action_log` VALUES ('419', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-30 03:41:47登录了后台', '1', '1459280507935');

INSERT INTO `cmswing_action_log` VALUES ('420', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-30 22:49:19登录了后台', '1', '1459349359295');

INSERT INTO `cmswing_action_log` VALUES ('421', '4', '1', '2130706433', 'document', '85', 'admin在2016-03-31 00:49:44发表了一篇文章。\r\n表document，记录编号85。', '1', '1459356584730');

INSERT INTO `cmswing_action_log` VALUES ('422', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-31 04:25:53登录了后台', '1', '1459369553439');

INSERT INTO `cmswing_action_log` VALUES ('423', '4', '1', '2130706433', 'document', '86', 'admin在2016-03-31 04:45:39发表了一篇文章。\r\n表document，记录编号86。', '1', '1459370739824');

INSERT INTO `cmswing_action_log` VALUES ('424', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-31 12:37:59登录了后台', '1', '1459399079806');

INSERT INTO `cmswing_action_log` VALUES ('425', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-31 12:43:51登录了后台', '1', '1459399431528');

INSERT INTO `cmswing_action_log` VALUES ('426', '4', '1', '2130706433', 'document', '87', 'admin在2016-03-31 13:01:57发表了一篇文章。\r\n表document，记录编号87。', '1', '1459400517644');

INSERT INTO `cmswing_action_log` VALUES ('427', '4', '1', '2130706433', 'document', '88', 'admin在2016-03-31 14:14:17发表了一篇文章。\r\n表document，记录编号88。', '1', '1459404857252');

INSERT INTO `cmswing_action_log` VALUES ('428', '1', '1', '2130706433', 'member', '1', 'admin在2016-03-31 16:40:38登录了后台', '1', '1459413638632');

INSERT INTO `cmswing_action_log` VALUES ('429', '9', '1', '2130706433', 'channel', '0', '操作url:/admin/channel/updates', '1', '1459417061206');

INSERT INTO `cmswing_action_log` VALUES ('430', '9', '1', '2130706433', 'channel', '0', '操作url:/admin/channel/updates', '1', '1459417083533');

INSERT INTO `cmswing_action_log` VALUES ('431', '9', '1', '2130706433', 'channel', '0', '操作url:/admin/channel/updates', '1', '1459417120026');

INSERT INTO `cmswing_action_log` VALUES ('432', '9', '1', '2130706433', 'channel', '0', '操作url:/admin/channel/updates', '1', '1459417153820');

INSERT INTO `cmswing_action_log` VALUES ('433', '9', '1', '2130706433', 'channel', '0', '操作url:/admin/channel/updates', '1', '1459417183649');

INSERT INTO `cmswing_action_log` VALUES ('434', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-03-31 17:58:10登录了后台', '1', '1459418290687');

INSERT INTO `cmswing_action_log` VALUES ('435', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-01 01:30:59登录了后台', '1', '1459445459321');

INSERT INTO `cmswing_action_log` VALUES ('436', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-01 04:38:13登录了后台', '1', '1459456693023');

INSERT INTO `cmswing_action_log` VALUES ('437', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-02 21:40:29登录了后台', '1', '1459604429229');

INSERT INTO `cmswing_action_log` VALUES ('438', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-03 00:18:29登录了后台', '1', '1459613909591');

INSERT INTO `cmswing_action_log` VALUES ('439', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-03 00:59:26登录了后台', '1', '1459616366604');

INSERT INTO `cmswing_action_log` VALUES ('440', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-03 00:59:40登录了后台', '1', '1459616380661');

INSERT INTO `cmswing_action_log` VALUES ('441', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-04 02:12:19登录了后台', '1', '1459707139208');

INSERT INTO `cmswing_action_log` VALUES ('442', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 03:34:18登录了后台', '1', '1459712058463');

INSERT INTO `cmswing_action_log` VALUES ('443', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 04:27:27登录了后台', '1', '1459715247541');

INSERT INTO `cmswing_action_log` VALUES ('444', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 15:41:07登录了后台', '1', '1459755667274');

INSERT INTO `cmswing_action_log` VALUES ('445', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 15:51:24登录了后台', '1', '1459756284073');

INSERT INTO `cmswing_action_log` VALUES ('446', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 19:46:29登录了后台', '1', '1459770389026');

INSERT INTO `cmswing_action_log` VALUES ('447', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-04 22:02:41登录了后台', '1', '1459778561055');

INSERT INTO `cmswing_action_log` VALUES ('448', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-05 22:54:16登录了后台', '1', '1459868056889');

INSERT INTO `cmswing_action_log` VALUES ('449', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-05 23:46:23登录了后台', '1', '1459871183091');

INSERT INTO `cmswing_action_log` VALUES ('450', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-05 23:47:42登录了后台', '1', '1459871262112');

INSERT INTO `cmswing_action_log` VALUES ('451', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-05 23:48:48登录了后台', '1', '1459871328991');

INSERT INTO `cmswing_action_log` VALUES ('452', '1', '1', '3232235878', 'member', '1', 'admin在2016-04-05 23:57:51登录了后台', '1', '1459871871787');

INSERT INTO `cmswing_action_log` VALUES ('453', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-06 00:41:40登录了后台', '1', '1459874500974');

INSERT INTO `cmswing_action_log` VALUES ('454', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-06 00:53:36登录了后台', '1', '1459875216284');

INSERT INTO `cmswing_action_log` VALUES ('455', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-06 01:48:59登录了后台', '1', '1459878539770');

INSERT INTO `cmswing_action_log` VALUES ('456', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-06 11:16:58登录了后台', '1', '1459912618741');

INSERT INTO `cmswing_action_log` VALUES ('457', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-06 11:26:10登录了后台', '1', '1459913170525');

INSERT INTO `cmswing_action_log` VALUES ('458', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 12:46:33登录了后台', '1', '1459917993485');

INSERT INTO `cmswing_action_log` VALUES ('459', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 12:46:41登录了后台', '1', '1459918001214');

INSERT INTO `cmswing_action_log` VALUES ('460', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 12:46:50登录了后台', '1', '1459918010186');

INSERT INTO `cmswing_action_log` VALUES ('461', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 12:47:06登录了后台', '1', '1459918026798');

INSERT INTO `cmswing_action_log` VALUES ('462', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-06 12:48:17登录了后台', '1', '1459918097854');

INSERT INTO `cmswing_action_log` VALUES ('463', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 14:24:27登录了后台', '1', '1459923867801');

INSERT INTO `cmswing_action_log` VALUES ('464', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-06 15:15:54登录了后台', '1', '1459926954307');

INSERT INTO `cmswing_action_log` VALUES ('465', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-06 15:16:40登录了后台', '1', '1459927000976');

INSERT INTO `cmswing_action_log` VALUES ('466', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-06 15:39:47登录了后台', '1', '1459928387774');

INSERT INTO `cmswing_action_log` VALUES ('467', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-06 18:48:50登录了后台', '1', '1459939730200');

INSERT INTO `cmswing_action_log` VALUES ('468', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-06 22:59:49登录了后台', '1', '1459954789608');

INSERT INTO `cmswing_action_log` VALUES ('469', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-07 00:28:08登录了后台', '1', '1459960088862');

INSERT INTO `cmswing_action_log` VALUES ('470', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-07 16:11:28登录了后台', '1', '1460016688125');

INSERT INTO `cmswing_action_log` VALUES ('471', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-07 18:15:07登录了后台', '1', '1460024107267');

INSERT INTO `cmswing_action_log` VALUES ('472', '1', '2', '2130706433', 'member', '2', 'cmswing在2016-04-07 18:15:09登录了后台', '1', '1460024109831');

INSERT INTO `cmswing_action_log` VALUES ('473', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-07 20:23:31登录了后台', '1', '1460031811006');

INSERT INTO `cmswing_action_log` VALUES ('474', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-07 21:29:38登录了后台', '1', '1460035778863');

INSERT INTO `cmswing_action_log` VALUES ('475', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-07 21:51:27登录了后台', '1', '1460037087519');

INSERT INTO `cmswing_action_log` VALUES ('476', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-07 21:56:15登录了后台', '1', '1460037375797');

INSERT INTO `cmswing_action_log` VALUES ('477', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-07 21:56:43登录了后台', '1', '1460037403213');

INSERT INTO `cmswing_action_log` VALUES ('478', '1', '2', '3232235879', 'member', '2', 'cmswing在2016-04-07 22:02:39登录了后台', '1', '1460037759670');

INSERT INTO `cmswing_action_log` VALUES ('479', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-07 22:19:44登录了后台', '1', '1460038784007');

INSERT INTO `cmswing_action_log` VALUES ('480', '1', '1', '3232235878', 'member', '1', 'admin在2016-04-07 22:36:17登录了后台', '1', '1460039777214');

INSERT INTO `cmswing_action_log` VALUES ('481', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-08 22:16:41登录了后台', '1', '1460125001834');

INSERT INTO `cmswing_action_log` VALUES ('482', '1', '2', '3232235878', 'member', '2', 'cmswing在2016-04-08 22:23:42登录了后台', '1', '1460125422400');

INSERT INTO `cmswing_action_log` VALUES ('483', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-08 22:54:02登录了后台', '1', '1460127242197');

INSERT INTO `cmswing_action_log` VALUES ('484', '1', '2', '3232235877', 'member', '2', 'cmswing在2016-04-09 00:21:17登录了后台', '1', '1460132477706');

INSERT INTO `cmswing_action_log` VALUES ('485', '1', '2', '3232235892', 'member', '2', 'cmswing在2016-04-09 11:00:59登录了后台', '1', '1460170859600');

INSERT INTO `cmswing_action_log` VALUES ('486', '1', '2', '3232235892', 'member', '2', 'cmswing在2016-04-09 11:53:30登录了后台', '1', '1460174010465');

INSERT INTO `cmswing_action_log` VALUES ('487', '1', '2', '3232235892', 'member', '2', 'cmswing在2016-04-09 11:55:07登录了后台', '1', '1460174107263');

INSERT INTO `cmswing_action_log` VALUES ('488', '1', '1', '3232235892', 'member', '1', 'admin在2016-04-09 13:07:27登录了后台', '1', '1460178447706');

INSERT INTO `cmswing_action_log` VALUES ('489', '1', '1', '2130706433', 'member', '1', 'admin在2016-04-09 16:07:44登录了后台', '1', '1460189264948');

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

-- Table structure for cmswing_address

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

DROP TABLE IF EXISTS `cmswing_address`;

CREATE TABLE `cmswing_address` (

`id` bigint(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`accept_name` varchar(20) NOT NULL,

`mobile` varchar(20) DEFAULT NULL,

`phone` varchar(20) DEFAULT NULL,

`province` bigint(20) NOT NULL,

`city` bigint(20) NOT NULL,

`county` bigint(20) NOT NULL,

`zip` varchar(6) DEFAULT NULL,

`addr` varchar(250) DEFAULT NULL,

`is_default` tinyint(1) DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

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

-- Records of cmswing_address

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

INSERT INTO `cmswing_address` VALUES ('1', '1', '晓飞 宁', '13589100333', '13589100475', '370000', '370100', '370102', '250000', '山东省ddddddd', '1');

INSERT INTO `cmswing_address` VALUES ('2', '3', 'hgfhfgh', '18681851637', '8688854', '310000', '310100', '310104', '822225', 'htgfhfghgfhgfhgfhfg', '1');

INSERT INTO `cmswing_address` VALUES ('3', '1', '天津帅小伙', '18651569374', '', '120000', '120100', '120107', '300021', '六大街72号', '0');

INSERT INTO `cmswing_address` VALUES ('4', '1', '路人丁', '18681851637', '', '110000', '110100', '110101', '710065', '东花市北里20号楼6单元501室 ', '0');

INSERT INTO `cmswing_address` VALUES ('37', '2', '12313', '3213', null, '120000', '120100', '120101', '3213', '232132131', '0');

INSERT INTO `cmswing_address` VALUES ('32', '2', '郭德纲', '18688888888', null, '110000', '110100', '110102', '10001', '北京德云社吗一路金子一号', '1');

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

-- Table structure for cmswing_area

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

DROP TABLE IF EXISTS `cmswing_area`;

CREATE TABLE `cmswing_area` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`parent_id` bigint(20) NOT NULL DEFAULT '0',

`sort` int(11) NOT NULL,

PRIMARY KEY (`id`),

KEY `pid` (`parent_id`)

) ENGINE=MyISAM AUTO_INCREMENT=910011 DEFAULT CHARSET=utf8;

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

-- Records of cmswing_area

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

INSERT INTO `cmswing_area` VALUES ('110000', '北京市', '0', '1');

INSERT INTO `cmswing_area` VALUES ('120000', '天津市', '0', '2');

INSERT INTO `cmswing_area` VALUES ('130000', '河北省', '0', '3');

INSERT INTO `cmswing_area` VALUES ('140000', '山西省', '0', '4');

INSERT INTO `cmswing_area` VALUES ('150000', '内蒙古', '0', '5');

INSERT INTO `cmswing_area` VALUES ('210000', '辽宁省', '0', '6');

INSERT INTO `cmswing_area` VALUES ('220000', '吉林省', '0', '7');

INSERT INTO `cmswing_area` VALUES ('230000', '黑龙江', '0', '8');

INSERT INTO `cmswing_area` VALUES ('310000', '上海市', '0', '9');

INSERT INTO `cmswing_area` VALUES ('320000', '江苏省', '0', '10');

INSERT INTO `cmswing_area` VALUES ('330000', '浙江省', '0', '11');

INSERT INTO `cmswing_area` VALUES ('340000', '安徽省', '0', '12');

INSERT INTO `cmswing_area` VALUES ('350000', '福建省', '0', '13');

INSERT INTO `cmswing_area` VALUES ('360000', '江西省', '0', '14');

INSERT INTO `cmswing_area` VALUES ('370000', '山东省', '0', '15');

INSERT INTO `cmswing_area` VALUES ('410000', '河南省', '0', '16');

INSERT INTO `cmswing_area` VALUES ('420000', '湖北省', '0', '17');

INSERT INTO `cmswing_area` VALUES ('430000', '湖南省', '0', '18');

INSERT INTO `cmswing_area` VALUES ('440000', '广东省', '0', '19');

INSERT INTO `cmswing_area` VALUES ('450000', '广西省', '0', '20');

INSERT INTO `cmswing_area` VALUES ('460000', '海南省', '0', '21');

INSERT INTO `cmswing_area` VALUES ('500000', '重庆市', '0', '22');

INSERT INTO `cmswing_area` VALUES ('510000', '四川省', '0', '23');

INSERT INTO `cmswing_area` VALUES ('520000', '贵州省', '0', '24');

INSERT INTO `cmswing_area` VALUES ('530000', '云南省', '0', '25');

INSERT INTO `cmswing_area` VALUES ('540000', '西　藏', '0', '26');

INSERT INTO `cmswing_area` VALUES ('610000', '陕西省', '0', '27');

INSERT INTO `cmswing_area` VALUES ('620000', '甘肃省', '0', '28');

INSERT INTO `cmswing_area` VALUES ('630000', '青海省', '0', '29');

INSERT INTO `cmswing_area` VALUES ('640000', '宁　夏', '0', '30');

INSERT INTO `cmswing_area` VALUES ('650000', '新　疆', '0', '31');

INSERT INTO `cmswing_area` VALUES ('710000', '台湾省', '0', '32');

INSERT INTO `cmswing_area` VALUES ('810000', '香　港', '0', '33');

INSERT INTO `cmswing_area` VALUES ('820000', '澳　门', '0', '34');

INSERT INTO `cmswing_area` VALUES ('110100', '北京市', '110000', '1');

INSERT INTO `cmswing_area` VALUES ('110200', '县', '110000', '2');

INSERT INTO `cmswing_area` VALUES ('120100', '市辖区', '120000', '1');

INSERT INTO `cmswing_area` VALUES ('120200', '县', '120000', '2');

INSERT INTO `cmswing_area` VALUES ('130100', '石家庄市', '130000', '1');

INSERT INTO `cmswing_area` VALUES ('130200', '唐山市', '130000', '2');

INSERT INTO `cmswing_area` VALUES ('130300', '秦皇岛市', '130000', '3');

INSERT INTO `cmswing_area` VALUES ('130400', '邯郸市', '130000', '4');

INSERT INTO `cmswing_area` VALUES ('130500', '邢台市', '130000', '5');

INSERT INTO `cmswing_area` VALUES ('130600', '保定市', '130000', '6');

INSERT INTO `cmswing_area` VALUES ('130700', '张家口市', '130000', '7');

INSERT INTO `cmswing_area` VALUES ('130800', '承德市', '130000', '8');

INSERT INTO `cmswing_area` VALUES ('130900', '沧州市', '130000', '9');

INSERT INTO `cmswing_area` VALUES ('131000', '廊坊市', '130000', '10');

INSERT INTO `cmswing_area` VALUES ('131100', '衡水市', '130000', '11');

INSERT INTO `cmswing_area` VALUES ('140100', '太原市', '140000', '1');

INSERT INTO `cmswing_area` VALUES ('140200', '大同市', '140000', '2');

INSERT INTO `cmswing_area` VALUES ('140300', '阳泉市', '140000', '3');

INSERT INTO `cmswing_area` VALUES ('140400', '长治市', '140000', '4');

INSERT INTO `cmswing_area` VALUES ('140500', '晋城市', '140000', '5');

INSERT INTO `cmswing_area` VALUES ('140600', '朔州市', '140000', '6');

INSERT INTO `cmswing_area` VALUES ('140700', '晋中市', '140000', '7');

INSERT INTO `cmswing_area` VALUES ('140800', '运城市', '140000', '8');

INSERT INTO `cmswing_area` VALUES ('140900', '忻州市', '140000', '9');

INSERT INTO `cmswing_area` VALUES ('141000', '临汾市', '140000', '10');

INSERT INTO `cmswing_area` VALUES ('141100', '吕梁市', '140000', '11');

INSERT INTO `cmswing_area` VALUES ('150100', '呼和浩特市', '150000', '1');

INSERT INTO `cmswing_area` VALUES ('150200', '包头市', '150000', '2');

INSERT INTO `cmswing_area` VALUES ('150300', '乌海市', '150000', '3');

INSERT INTO `cmswing_area` VALUES ('150400', '赤峰市', '150000', '4');

INSERT INTO `cmswing_area` VALUES ('150500', '通辽市', '150000', '5');

INSERT INTO `cmswing_area` VALUES ('150600', '鄂尔多斯市', '150000', '6');

INSERT INTO `cmswing_area` VALUES ('150700', '呼伦贝尔市', '150000', '7');

INSERT INTO `cmswing_area` VALUES ('150800', '巴彦淖尔市', '150000', '8');

INSERT INTO `cmswing_area` VALUES ('150900', '乌兰察布市', '150000', '9');

INSERT INTO `cmswing_area` VALUES ('152200', '兴安盟', '150000', '10');

INSERT INTO `cmswing_area` VALUES ('152500', '锡林郭勒盟', '150000', '11');

INSERT INTO `cmswing_area` VALUES ('152900', '阿拉善盟', '150000', '12');

INSERT INTO `cmswing_area` VALUES ('210100', '沈阳市', '210000', '1');

INSERT INTO `cmswing_area` VALUES ('210200', '大连市', '210000', '2');

INSERT INTO `cmswing_area` VALUES ('210300', '鞍山市', '210000', '3');

INSERT INTO `cmswing_area` VALUES ('210400', '抚顺市', '210000', '4');

INSERT INTO `cmswing_area` VALUES ('210500', '本溪市', '210000', '5');

INSERT INTO `cmswing_area` VALUES ('210600', '丹东市', '210000', '6');

INSERT INTO `cmswing_area` VALUES ('210700', '锦州市', '210000', '7');

INSERT INTO `cmswing_area` VALUES ('210800', '营口市', '210000', '8');

INSERT INTO `cmswing_area` VALUES ('210900', '阜新市', '210000', '9');

INSERT INTO `cmswing_area` VALUES ('211000', '辽阳市', '210000', '10');

INSERT INTO `cmswing_area` VALUES ('211100', '盘锦市', '210000', '11');

INSERT INTO `cmswing_area` VALUES ('211200', '铁岭市', '210000', '12');

INSERT INTO `cmswing_area` VALUES ('211300', '朝阳市', '210000', '13');

INSERT INTO `cmswing_area` VALUES ('211400', '葫芦岛市', '210000', '14');

INSERT INTO `cmswing_area` VALUES ('220100', '长春市', '220000', '1');

INSERT INTO `cmswing_area` VALUES ('220200', '吉林市', '220000', '2');

INSERT INTO `cmswing_area` VALUES ('220300', '四平市', '220000', '3');

INSERT INTO `cmswing_area` VALUES ('220400', '辽源市', '220000', '4');

INSERT INTO `cmswing_area` VALUES ('220500', '通化市', '220000', '5');

INSERT INTO `cmswing_area` VALUES ('220600', '白山市', '220000', '6');

INSERT INTO `cmswing_area` VALUES ('220700', '松原市', '220000', '7');

INSERT INTO `cmswing_area` VALUES ('220800', '白城市', '220000', '8');

INSERT INTO `cmswing_area` VALUES ('222400', '延边朝鲜族自治州', '220000', '9');

INSERT INTO `cmswing_area` VALUES ('230100', '哈尔滨市', '230000', '1');

INSERT INTO `cmswing_area` VALUES ('230200', '齐齐哈尔市', '230000', '2');

INSERT INTO `cmswing_area` VALUES ('230300', '鸡西市', '230000', '3');

INSERT INTO `cmswing_area` VALUES ('230400', '鹤岗市', '230000', '4');

INSERT INTO `cmswing_area` VALUES ('230500', '双鸭山市', '230000', '5');

INSERT INTO `cmswing_area` VALUES ('230600', '大庆市', '230000', '6');

INSERT INTO `cmswing_area` VALUES ('230700', '伊春市', '230000', '7');

INSERT INTO `cmswing_area` VALUES ('230800', '佳木斯市', '230000', '8');

INSERT INTO `cmswing_area` VALUES ('230900', '七台河市', '230000', '9');

INSERT INTO `cmswing_area` VALUES ('231000', '牡丹江市', '230000', '10');

INSERT INTO `cmswing_area` VALUES ('231100', '黑河市', '230000', '11');

INSERT INTO `cmswing_area` VALUES ('231200', '绥化市', '230000', '12');

INSERT INTO `cmswing_area` VALUES ('232700', '大兴安岭地区', '230000', '13');

INSERT INTO `cmswing_area` VALUES ('310100', '市辖区', '310000', '1');

INSERT INTO `cmswing_area` VALUES ('310200', '县', '310000', '2');

INSERT INTO `cmswing_area` VALUES ('320100', '南京市', '320000', '1');

INSERT INTO `cmswing_area` VALUES ('320200', '无锡市', '320000', '2');

INSERT INTO `cmswing_area` VALUES ('320300', '徐州市', '320000', '3');

INSERT INTO `cmswing_area` VALUES ('320400', '常州市', '320000', '4');

INSERT INTO `cmswing_area` VALUES ('320500', '苏州市', '320000', '5');

INSERT INTO `cmswing_area` VALUES ('320600', '南通市', '320000', '6');

INSERT INTO `cmswing_area` VALUES ('320700', '连云港市', '320000', '7');

INSERT INTO `cmswing_area` VALUES ('320800', '淮安市', '320000', '8');

INSERT INTO `cmswing_area` VALUES ('320900', '盐城市', '320000', '9');

INSERT INTO `cmswing_area` VALUES ('321000', '扬州市', '320000', '10');

INSERT INTO `cmswing_area` VALUES ('321100', '镇江市', '320000', '11');

INSERT INTO `cmswing_area` VALUES ('321200', '泰州市', '320000', '12');

INSERT INTO `cmswing_area` VALUES ('321300', '宿迁市', '320000', '13');

INSERT INTO `cmswing_area` VALUES ('330100', '杭州市', '330000', '1');

INSERT INTO `cmswing_area` VALUES ('330200', '宁波市', '330000', '2');

INSERT INTO `cmswing_area` VALUES ('330300', '温州市', '330000', '3');

INSERT INTO `cmswing_area` VALUES ('330400', '嘉兴市', '330000', '4');

INSERT INTO `cmswing_area` VALUES ('330500', '湖州市', '330000', '5');

INSERT INTO `cmswing_area` VALUES ('330600', '绍兴市', '330000', '6');

INSERT INTO `cmswing_area` VALUES ('330700', '金华市', '330000', '7');

INSERT INTO `cmswing_area` VALUES ('330800', '衢州市', '330000', '8');

INSERT INTO `cmswing_area` VALUES ('330900', '舟山市', '330000', '9');

INSERT INTO `cmswing_area` VALUES ('331000', '台州市', '330000', '10');

INSERT INTO `cmswing_area` VALUES ('331100', '丽水市', '330000', '11');

INSERT INTO `cmswing_area` VALUES ('340100', '合肥市', '340000', '1');

INSERT INTO `cmswing_area` VALUES ('340200', '芜湖市', '340000', '2');

INSERT INTO `cmswing_area` VALUES ('340300', '蚌埠市', '340000', '3');

INSERT INTO `cmswing_area` VALUES ('340400', '淮南市', '340000', '4');

INSERT INTO `cmswing_area` VALUES ('340500', '马鞍山市', '340000', '5');

INSERT INTO `cmswing_area` VALUES ('340600', '淮北市', '340000', '6');

INSERT INTO `cmswing_area` VALUES ('340700', '铜陵市', '340000', '7');

INSERT INTO `cmswing_area` VALUES ('340800', '安庆市', '340000', '8');

INSERT INTO `cmswing_area` VALUES ('341000', '黄山市', '340000', '9');

INSERT INTO `cmswing_area` VALUES ('341100', '滁州市', '340000', '10');

INSERT INTO `cmswing_area` VALUES ('341200', '阜阳市', '340000', '11');

INSERT INTO `cmswing_area` VALUES ('341300', '宿州市', '340000', '12');

INSERT INTO `cmswing_area` VALUES ('341500', '六安市', '340000', '13');

INSERT INTO `cmswing_area` VALUES ('341600', '亳州市', '340000', '14');

INSERT INTO `cmswing_area` VALUES ('341700', '池州市', '340000', '15');

INSERT INTO `cmswing_area` VALUES ('341800', '宣城市', '340000', '16');

INSERT INTO `cmswing_area` VALUES ('350100', '福州市', '350000', '1');

INSERT INTO `cmswing_area` VALUES ('350200', '厦门市', '350000', '2');

INSERT INTO `cmswing_area` VALUES ('350300', '莆田市', '350000', '3');

INSERT INTO `cmswing_area` VALUES ('350400', '三明市', '350000', '4');

INSERT INTO `cmswing_area` VALUES ('350500', '泉州市', '350000', '5');

INSERT INTO `cmswing_area` VALUES ('350600', '漳州市', '350000', '6');

INSERT INTO `cmswing_area` VALUES ('350700', '南平市', '350000', '7');

INSERT INTO `cmswing_area` VALUES ('350800', '龙岩市', '350000', '8');

INSERT INTO `cmswing_area` VALUES ('350900', '宁德市', '350000', '9');

INSERT INTO `cmswing_area` VALUES ('360100', '南昌市', '360000', '1');

INSERT INTO `cmswing_area` VALUES ('360200', '景德镇市', '360000', '2');

INSERT INTO `cmswing_area` VALUES ('360300', '萍乡市', '360000', '3');

INSERT INTO `cmswing_area` VALUES ('360400', '九江市', '360000', '4');

INSERT INTO `cmswing_area` VALUES ('360500', '新余市', '360000', '5');

INSERT INTO `cmswing_area` VALUES ('360600', '鹰潭市', '360000', '6');

INSERT INTO `cmswing_area` VALUES ('360700', '赣州市', '360000', '7');

INSERT INTO `cmswing_area` VALUES ('360800', '吉安市', '360000', '8');

INSERT INTO `cmswing_area` VALUES ('360900', '宜春市', '360000', '9');

INSERT INTO `cmswing_area` VALUES ('361000', '抚州市', '360000', '10');

INSERT INTO `cmswing_area` VALUES ('361100', '上饶市', '360000', '11');

INSERT INTO `cmswing_area` VALUES ('370100', '济南市', '370000', '1');

INSERT INTO `cmswing_area` VALUES ('370200', '青岛市', '370000', '2');

INSERT INTO `cmswing_area` VALUES ('370300', '淄博市', '370000', '3');

INSERT INTO `cmswing_area` VALUES ('370400', '枣庄市', '370000', '4');

INSERT INTO `cmswing_area` VALUES ('370500', '东营市', '370000', '5');

INSERT INTO `cmswing_area` VALUES ('370600', '烟台市', '370000', '6');

INSERT INTO `cmswing_area` VALUES ('370700', '潍坊市', '370000', '7');

INSERT INTO `cmswing_area` VALUES ('370800', '济宁市', '370000', '8');

INSERT INTO `cmswing_area` VALUES ('370900', '泰安市', '370000', '9');

INSERT INTO `cmswing_area` VALUES ('371000', '威海市', '370000', '10');

INSERT INTO `cmswing_area` VALUES ('371100', '日照市', '370000', '11');

INSERT INTO `cmswing_area` VALUES ('371200', '莱芜市', '370000', '12');

INSERT INTO `cmswing_area` VALUES ('371300', '临沂市', '370000', '13');

INSERT INTO `cmswing_area` VALUES ('371400', '德州市', '370000', '14');

INSERT INTO `cmswing_area` VALUES ('371500', '聊城市', '370000', '15');

INSERT INTO `cmswing_area` VALUES ('371600', '滨州市', '370000', '16');

INSERT INTO `cmswing_area` VALUES ('371700', '菏泽市', '370000', '17');

INSERT INTO `cmswing_area` VALUES ('410100', '郑州市', '410000', '1');

INSERT INTO `cmswing_area` VALUES ('410200', '开封市', '410000', '2');

INSERT INTO `cmswing_area` VALUES ('410300', '洛阳市', '410000', '3');

INSERT INTO `cmswing_area` VALUES ('410400', '平顶山市', '410000', '4');

INSERT INTO `cmswing_area` VALUES ('410500', '安阳市', '410000', '5');

INSERT INTO `cmswing_area` VALUES ('410600', '鹤壁市', '410000', '6');

INSERT INTO `cmswing_area` VALUES ('410700', '新乡市', '410000', '7');

INSERT INTO `cmswing_area` VALUES ('410800', '焦作市', '410000', '8');

INSERT INTO `cmswing_area` VALUES ('410900', '濮阳市', '410000', '9');

INSERT INTO `cmswing_area` VALUES ('411000', '许昌市', '410000', '10');

INSERT INTO `cmswing_area` VALUES ('411100', '漯河市', '410000', '11');

INSERT INTO `cmswing_area` VALUES ('411200', '三门峡市', '410000', '12');

INSERT INTO `cmswing_area` VALUES ('411300', '南阳市', '410000', '13');

INSERT INTO `cmswing_area` VALUES ('411400', '商丘市', '410000', '14');

INSERT INTO `cmswing_area` VALUES ('411500', '信阳市', '410000', '15');

INSERT INTO `cmswing_area` VALUES ('411600', '周口市', '410000', '16');

INSERT INTO `cmswing_area` VALUES ('411700', '驻马店市', '410000', '17');

INSERT INTO `cmswing_area` VALUES ('420100', '武汉市', '420000', '1');

INSERT INTO `cmswing_area` VALUES ('420200', '黄石市', '420000', '2');

INSERT INTO `cmswing_area` VALUES ('420300', '十堰市', '420000', '3');

INSERT INTO `cmswing_area` VALUES ('420500', '宜昌市', '420000', '4');

INSERT INTO `cmswing_area` VALUES ('420600', '襄樊市', '420000', '5');

INSERT INTO `cmswing_area` VALUES ('420700', '鄂州市', '420000', '6');

INSERT INTO `cmswing_area` VALUES ('420800', '荆门市', '420000', '7');

INSERT INTO `cmswing_area` VALUES ('420900', '孝感市', '420000', '8');

INSERT INTO `cmswing_area` VALUES ('421000', '荆州市', '420000', '9');

INSERT INTO `cmswing_area` VALUES ('421100', '黄冈市', '420000', '10');

INSERT INTO `cmswing_area` VALUES ('421200', '咸宁市', '420000', '11');

INSERT INTO `cmswing_area` VALUES ('421300', '随州市', '420000', '12');

INSERT INTO `cmswing_area` VALUES ('422800', '恩施土家族苗族自治州', '420000', '13');

INSERT INTO `cmswing_area` VALUES ('429000', '省直辖行政单位', '420000', '14');

INSERT INTO `cmswing_area` VALUES ('430100', '长沙市', '430000', '1');

INSERT INTO `cmswing_area` VALUES ('430200', '株洲市', '430000', '2');

INSERT INTO `cmswing_area` VALUES ('430300', '湘潭市', '430000', '3');

INSERT INTO `cmswing_area` VALUES ('430400', '衡阳市', '430000', '4');

INSERT INTO `cmswing_area` VALUES ('430500', '邵阳市', '430000', '5');

INSERT INTO `cmswing_area` VALUES ('430600', '岳阳市', '430000', '6');

INSERT INTO `cmswing_area` VALUES ('430700', '常德市', '430000', '7');

INSERT INTO `cmswing_area` VALUES ('430800', '张家界市', '430000', '8');

INSERT INTO `cmswing_area` VALUES ('430900', '益阳市', '430000', '9');

INSERT INTO `cmswing_area` VALUES ('431000', '郴州市', '430000', '10');

INSERT INTO `cmswing_area` VALUES ('431100', '永州市', '430000', '11');

INSERT INTO `cmswing_area` VALUES ('431200', '怀化市', '430000', '12');

INSERT INTO `cmswing_area` VALUES ('431300', '娄底市', '430000', '13');

INSERT INTO `cmswing_area` VALUES ('433100', '湘西土家族苗族自治州', '430000', '14');

INSERT INTO `cmswing_area` VALUES ('440100', '广州市', '440000', '1');

INSERT INTO `cmswing_area` VALUES ('440200', '韶关市', '440000', '2');

INSERT INTO `cmswing_area` VALUES ('440300', '深圳市', '440000', '3');

INSERT INTO `cmswing_area` VALUES ('440400', '珠海市', '440000', '4');

INSERT INTO `cmswing_area` VALUES ('440500', '汕头市', '440000', '5');

INSERT INTO `cmswing_area` VALUES ('440600', '佛山市', '440000', '6');

INSERT INTO `cmswing_area` VALUES ('440700', '江门市', '440000', '7');

INSERT INTO `cmswing_area` VALUES ('440800', '湛江市', '440000', '8');

INSERT INTO `cmswing_area` VALUES ('440900', '茂名市', '440000', '9');

INSERT INTO `cmswing_area` VALUES ('441200', '肇庆市', '440000', '10');

INSERT INTO `cmswing_area` VALUES ('441300', '惠州市', '440000', '11');

INSERT INTO `cmswing_area` VALUES ('441400', '梅州市', '440000', '12');

INSERT INTO `cmswing_area` VALUES ('441500', '汕尾市', '440000', '13');

INSERT INTO `cmswing_area` VALUES ('441600', '河源市', '440000', '14');

INSERT INTO `cmswing_area` VALUES ('441700', '阳江市', '440000', '15');

INSERT INTO `cmswing_area` VALUES ('441800', '清远市', '440000', '16');

INSERT INTO `cmswing_area` VALUES ('441900', '东莞市', '440000', '17');

INSERT INTO `cmswing_area` VALUES ('442000', '中山市', '440000', '18');

INSERT INTO `cmswing_area` VALUES ('445100', '潮州市', '440000', '19');

INSERT INTO `cmswing_area` VALUES ('445200', '揭阳市', '440000', '20');

INSERT INTO `cmswing_area` VALUES ('445300', '云浮市', '440000', '21');

INSERT INTO `cmswing_area` VALUES ('450100', '南宁市', '450000', '1');

INSERT INTO `cmswing_area` VALUES ('450200', '柳州市', '450000', '2');

INSERT INTO `cmswing_area` VALUES ('450300', '桂林市', '450000', '3');

INSERT INTO `cmswing_area` VALUES ('450400', '梧州市', '450000', '4');

INSERT INTO `cmswing_area` VALUES ('450500', '北海市', '450000', '5');

INSERT INTO `cmswing_area` VALUES ('450600', '防城港市', '450000', '6');

INSERT INTO `cmswing_area` VALUES ('450700', '钦州市', '450000', '7');

INSERT INTO `cmswing_area` VALUES ('450800', '贵港市', '450000', '8');

INSERT INTO `cmswing_area` VALUES ('450900', '玉林市', '450000', '9');

INSERT INTO `cmswing_area` VALUES ('451000', '百色市', '450000', '10');

INSERT INTO `cmswing_area` VALUES ('451100', '贺州市', '450000', '11');

INSERT INTO `cmswing_area` VALUES ('451200', '河池市', '450000', '12');

INSERT INTO `cmswing_area` VALUES ('451300', '来宾市', '450000', '13');

INSERT INTO `cmswing_area` VALUES ('451400', '崇左市', '450000', '14');

INSERT INTO `cmswing_area` VALUES ('460100', '海口市', '460000', '1');

INSERT INTO `cmswing_area` VALUES ('460200', '三亚市', '460000', '2');

INSERT INTO `cmswing_area` VALUES ('469000', '省直辖县级行政单位', '460000', '3');

INSERT INTO `cmswing_area` VALUES ('500100', '市辖区', '500000', '1');

INSERT INTO `cmswing_area` VALUES ('500200', '县', '500000', '2');

INSERT INTO `cmswing_area` VALUES ('500300', '市', '500000', '3');

INSERT INTO `cmswing_area` VALUES ('510100', '成都市', '510000', '1');

INSERT INTO `cmswing_area` VALUES ('510300', '自贡市', '510000', '2');

INSERT INTO `cmswing_area` VALUES ('510400', '攀枝花市', '510000', '3');

INSERT INTO `cmswing_area` VALUES ('510500', '泸州市', '510000', '4');

INSERT INTO `cmswing_area` VALUES ('510600', '德阳市', '510000', '5');

INSERT INTO `cmswing_area` VALUES ('510700', '绵阳市', '510000', '6');

INSERT INTO `cmswing_area` VALUES ('510800', '广元市', '510000', '7');

INSERT INTO `cmswing_area` VALUES ('510900', '遂宁市', '510000', '8');

INSERT INTO `cmswing_area` VALUES ('511000', '内江市', '510000', '9');

INSERT INTO `cmswing_area` VALUES ('511100', '乐山市', '510000', '10');

INSERT INTO `cmswing_area` VALUES ('511300', '南充市', '510000', '11');

INSERT INTO `cmswing_area` VALUES ('511400', '眉山市', '510000', '12');

INSERT INTO `cmswing_area` VALUES ('511500', '宜宾市', '510000', '13');

INSERT INTO `cmswing_area` VALUES ('511600', '广安市', '510000', '14');

INSERT INTO `cmswing_area` VALUES ('511700', '达州市', '510000', '15');

INSERT INTO `cmswing_area` VALUES ('511800', '雅安市', '510000', '16');

INSERT INTO `cmswing_area` VALUES ('511900', '巴中市', '510000', '17');

INSERT INTO `cmswing_area` VALUES ('512000', '资阳市', '510000', '18');

INSERT INTO `cmswing_area` VALUES ('513200', '阿坝藏族羌族自治州', '510000', '19');

INSERT INTO `cmswing_area` VALUES ('513300', '甘孜藏族自治州', '510000', '20');

INSERT INTO `cmswing_area` VALUES ('513400', '凉山彝族自治州', '510000', '21');

INSERT INTO `cmswing_area` VALUES ('520100', '贵阳市', '520000', '1');

INSERT INTO `cmswing_area` VALUES ('520200', '六盘水市', '520000', '2');

INSERT INTO `cmswing_area` VALUES ('520300', '遵义市', '520000', '3');

INSERT INTO `cmswing_area` VALUES ('520400', '安顺市', '520000', '4');

INSERT INTO `cmswing_area` VALUES ('522200', '铜仁地区', '520000', '5');

INSERT INTO `cmswing_area` VALUES ('522300', '黔西南布依族苗族自治州', '520000', '6');

INSERT INTO `cmswing_area` VALUES ('522400', '毕节地区', '520000', '7');

INSERT INTO `cmswing_area` VALUES ('522600', '黔东南苗族侗族自治州', '520000', '8');

INSERT INTO `cmswing_area` VALUES ('522700', '黔南布依族苗族自治州', '520000', '9');

INSERT INTO `cmswing_area` VALUES ('530100', '昆明市', '530000', '1');

INSERT INTO `cmswing_area` VALUES ('530300', '曲靖市', '530000', '2');

INSERT INTO `cmswing_area` VALUES ('530400', '玉溪市', '530000', '3');

INSERT INTO `cmswing_area` VALUES ('530500', '保山市', '530000', '4');

INSERT INTO `cmswing_area` VALUES ('530600', '昭通市', '530000', '5');

INSERT INTO `cmswing_area` VALUES ('530700', '丽江市', '530000', '6');

INSERT INTO `cmswing_area` VALUES ('530800', '思茅市', '530000', '7');

INSERT INTO `cmswing_area` VALUES ('530900', '临沧市', '530000', '8');

INSERT INTO `cmswing_area` VALUES ('532300', '楚雄彝族自治州', '530000', '9');

INSERT INTO `cmswing_area` VALUES ('532500', '红河哈尼族彝族自治州', '530000', '10');

INSERT INTO `cmswing_area` VALUES ('532600', '文山壮族苗族自治州', '530000', '11');

INSERT INTO `cmswing_area` VALUES ('532800', '西双版纳傣族自治州', '530000', '12');

INSERT INTO `cmswing_area` VALUES ('532900', '大理白族自治州', '530000', '13');

INSERT INTO `cmswing_area` VALUES ('533100', '德宏傣族景颇族自治州', '530000', '14');

INSERT INTO `cmswing_area` VALUES ('533300', '怒江傈僳族自治州', '530000', '15');

INSERT INTO `cmswing_area` VALUES ('533400', '迪庆藏族自治州', '530000', '16');

INSERT INTO `cmswing_area` VALUES ('540100', '拉萨市', '540000', '1');

INSERT INTO `cmswing_area` VALUES ('542100', '昌都地区', '540000', '2');

INSERT INTO `cmswing_area` VALUES ('542200', '山南地区', '540000', '3');

INSERT INTO `cmswing_area` VALUES ('542300', '日喀则地区', '540000', '4');

INSERT INTO `cmswing_area` VALUES ('542400', '那曲地区', '540000', '5');

INSERT INTO `cmswing_area` VALUES ('542500', '阿里地区', '540000', '6');

INSERT INTO `cmswing_area` VALUES ('542600', '林芝地区', '540000', '7');

INSERT INTO `cmswing_area` VALUES ('610100', '西安市', '610000', '1');

INSERT INTO `cmswing_area` VALUES ('610200', '铜川市', '610000', '2');

INSERT INTO `cmswing_area` VALUES ('610300', '宝鸡市', '610000', '3');

INSERT INTO `cmswing_area` VALUES ('610400', '咸阳市', '610000', '4');

INSERT INTO `cmswing_area` VALUES ('610500', '渭南市', '610000', '5');

INSERT INTO `cmswing_area` VALUES ('610600', '延安市', '610000', '6');

INSERT INTO `cmswing_area` VALUES ('610700', '汉中市', '610000', '7');

INSERT INTO `cmswing_area` VALUES ('610800', '榆林市', '610000', '8');

INSERT INTO `cmswing_area` VALUES ('610900', '安康市', '610000', '9');

INSERT INTO `cmswing_area` VALUES ('611000', '商洛市', '610000', '10');

INSERT INTO `cmswing_area` VALUES ('620100', '兰州市', '620000', '1');

INSERT INTO `cmswing_area` VALUES ('620200', '嘉峪关市', '620000', '2');

INSERT INTO `cmswing_area` VALUES ('620300', '金昌市', '620000', '3');

INSERT INTO `cmswing_area` VALUES ('620400', '白银市', '620000', '4');

INSERT INTO `cmswing_area` VALUES ('620500', '天水市', '620000', '5');

INSERT INTO `cmswing_area` VALUES ('620600', '武威市', '620000', '6');

INSERT INTO `cmswing_area` VALUES ('620700', '张掖市', '620000', '7');

INSERT INTO `cmswing_area` VALUES ('620800', '平凉市', '620000', '8');

INSERT INTO `cmswing_area` VALUES ('620900', '酒泉市', '620000', '9');

INSERT INTO `cmswing_area` VALUES ('621000', '庆阳市', '620000', '10');

INSERT INTO `cmswing_area` VALUES ('621100', '定西市', '620000', '11');

INSERT INTO `cmswing_area` VALUES ('621200', '陇南市', '620000', '12');

INSERT INTO `cmswing_area` VALUES ('622900', '临夏回族自治州', '620000', '13');

INSERT INTO `cmswing_area` VALUES ('623000', '甘南藏族自治州', '620000', '14');

INSERT INTO `cmswing_area` VALUES ('630100', '西宁市', '630000', '1');

INSERT INTO `cmswing_area` VALUES ('632100', '海东地区', '630000', '2');

INSERT INTO `cmswing_area` VALUES ('632200', '海北藏族自治州', '630000', '3');

INSERT INTO `cmswing_area` VALUES ('632300', '黄南藏族自治州', '630000', '4');

INSERT INTO `cmswing_area` VALUES ('632500', '海南藏族自治州', '630000', '5');

INSERT INTO `cmswing_area` VALUES ('632600', '果洛藏族自治州', '630000', '6');

INSERT INTO `cmswing_area` VALUES ('632700', '玉树藏族自治州', '630000', '7');

INSERT INTO `cmswing_area` VALUES ('632800', '海西蒙古族藏族自治州', '630000', '8');

INSERT INTO `cmswing_area` VALUES ('640100', '银川市', '640000', '1');

INSERT INTO `cmswing_area` VALUES ('640200', '石嘴山市', '640000', '2');

INSERT INTO `cmswing_area` VALUES ('640300', '吴忠市', '640000', '3');

INSERT INTO `cmswing_area` VALUES ('640400', '固原市', '640000', '4');

INSERT INTO `cmswing_area` VALUES ('640500', '中卫市', '640000', '5');

INSERT INTO `cmswing_area` VALUES ('650100', '乌鲁木齐市', '650000', '1');

INSERT INTO `cmswing_area` VALUES ('650200', '克拉玛依市', '650000', '2');

INSERT INTO `cmswing_area` VALUES ('652100', '吐鲁番地区', '650000', '3');

INSERT INTO `cmswing_area` VALUES ('652200', '哈密地区', '650000', '4');

INSERT INTO `cmswing_area` VALUES ('652300', '昌吉回族自治州', '650000', '5');

INSERT INTO `cmswing_area` VALUES ('652700', '博尔塔拉蒙古自治州', '650000', '6');

INSERT INTO `cmswing_area` VALUES ('652800', '巴音郭楞蒙古自治州', '650000', '7');

INSERT INTO `cmswing_area` VALUES ('652900', '阿克苏地区', '650000', '8');

INSERT INTO `cmswing_area` VALUES ('653000', '克孜勒苏柯尔克孜自治州', '650000', '9');

INSERT INTO `cmswing_area` VALUES ('653100', '喀什地区', '650000', '10');

INSERT INTO `cmswing_area` VALUES ('653200', '和田地区', '650000', '11');

INSERT INTO `cmswing_area` VALUES ('654000', '伊犁哈萨克自治州', '650000', '12');

INSERT INTO `cmswing_area` VALUES ('654200', '塔城地区', '650000', '13');

INSERT INTO `cmswing_area` VALUES ('654300', '阿勒泰地区', '650000', '14');

INSERT INTO `cmswing_area` VALUES ('659000', '省直辖行政单位', '650000', '15');

INSERT INTO `cmswing_area` VALUES ('110101', '东城区', '110100', '1');

INSERT INTO `cmswing_area` VALUES ('110102', '西城区', '110100', '2');

INSERT INTO `cmswing_area` VALUES ('110103', '崇文区', '110100', '3');

INSERT INTO `cmswing_area` VALUES ('110104', '宣武区', '110100', '4');

INSERT INTO `cmswing_area` VALUES ('110105', '朝阳区', '110100', '5');

INSERT INTO `cmswing_area` VALUES ('110106', '丰台区', '110100', '6');

INSERT INTO `cmswing_area` VALUES ('110107', '石景山区', '110100', '7');

INSERT INTO `cmswing_area` VALUES ('110108', '海淀区', '110100', '8');

INSERT INTO `cmswing_area` VALUES ('110109', '门头沟区', '110100', '9');

INSERT INTO `cmswing_area` VALUES ('110111', '房山区', '110100', '10');

INSERT INTO `cmswing_area` VALUES ('110112', '通州区', '110100', '11');

INSERT INTO `cmswing_area` VALUES ('110113', '顺义区', '110100', '12');

INSERT INTO `cmswing_area` VALUES ('110114', '昌平区', '110100', '13');

INSERT INTO `cmswing_area` VALUES ('110115', '大兴区', '110100', '14');

INSERT INTO `cmswing_area` VALUES ('110116', '怀柔区', '110100', '15');

INSERT INTO `cmswing_area` VALUES ('110117', '平谷区', '110100', '16');

INSERT INTO `cmswing_area` VALUES ('110228', '密云县', '110200', '1');

INSERT INTO `cmswing_area` VALUES ('110229', '延庆县', '110200', '2');

INSERT INTO `cmswing_area` VALUES ('120101', '和平区', '120100', '1');

INSERT INTO `cmswing_area` VALUES ('120102', '河东区', '120100', '2');

INSERT INTO `cmswing_area` VALUES ('120103', '河西区', '120100', '3');

INSERT INTO `cmswing_area` VALUES ('120104', '南开区', '120100', '4');

INSERT INTO `cmswing_area` VALUES ('120105', '河北区', '120100', '5');

INSERT INTO `cmswing_area` VALUES ('120106', '红桥区', '120100', '6');

INSERT INTO `cmswing_area` VALUES ('120107', '塘沽区', '120100', '7');

INSERT INTO `cmswing_area` VALUES ('120108', '汉沽区', '120100', '8');

INSERT INTO `cmswing_area` VALUES ('120109', '大港区', '120100', '9');

INSERT INTO `cmswing_area` VALUES ('120110', '东丽区', '120100', '10');

INSERT INTO `cmswing_area` VALUES ('120111', '西青区', '120100', '11');

INSERT INTO `cmswing_area` VALUES ('120112', '津南区', '120100', '12');

INSERT INTO `cmswing_area` VALUES ('120113', '北辰区', '120100', '13');

INSERT INTO `cmswing_area` VALUES ('120114', '武清区', '120100', '14');

INSERT INTO `cmswing_area` VALUES ('120115', '宝坻区', '120100', '15');

INSERT INTO `cmswing_area` VALUES ('120221', '宁河县', '120200', '1');

INSERT INTO `cmswing_area` VALUES ('120223', '静海县', '120200', '2');

INSERT INTO `cmswing_area` VALUES ('120225', '蓟　县', '120200', '3');

INSERT INTO `cmswing_area` VALUES ('130101', '市辖区', '130100', '1');

INSERT INTO `cmswing_area` VALUES ('130102', '长安区', '130100', '2');

INSERT INTO `cmswing_area` VALUES ('130103', '桥东区', '130100', '3');

INSERT INTO `cmswing_area` VALUES ('130104', '桥西区', '130100', '4');

INSERT INTO `cmswing_area` VALUES ('130105', '新华区', '130100', '5');

INSERT INTO `cmswing_area` VALUES ('130107', '井陉矿区', '130100', '6');

INSERT INTO `cmswing_area` VALUES ('130108', '裕华区', '130100', '7');

INSERT INTO `cmswing_area` VALUES ('130121', '井陉县', '130100', '8');

INSERT INTO `cmswing_area` VALUES ('130123', '正定县', '130100', '9');

INSERT INTO `cmswing_area` VALUES ('130124', '栾城县', '130100', '10');

INSERT INTO `cmswing_area` VALUES ('130125', '行唐县', '130100', '11');

INSERT INTO `cmswing_area` VALUES ('130126', '灵寿县', '130100', '12');

INSERT INTO `cmswing_area` VALUES ('130127', '高邑县', '130100', '13');

INSERT INTO `cmswing_area` VALUES ('130128', '深泽县', '130100', '14');

INSERT INTO `cmswing_area` VALUES ('130129', '赞皇县', '130100', '15');

INSERT INTO `cmswing_area` VALUES ('130130', '无极县', '130100', '16');

INSERT INTO `cmswing_area` VALUES ('130131', '平山县', '130100', '17');

INSERT INTO `cmswing_area` VALUES ('130132', '元氏县', '130100', '18');

INSERT INTO `cmswing_area` VALUES ('130133', '赵　县', '130100', '19');

INSERT INTO `cmswing_area` VALUES ('130181', '辛集市', '130100', '20');

INSERT INTO `cmswing_area` VALUES ('130182', '藁城市', '130100', '21');

INSERT INTO `cmswing_area` VALUES ('130183', '晋州市', '130100', '22');

INSERT INTO `cmswing_area` VALUES ('130184', '新乐市', '130100', '23');

INSERT INTO `cmswing_area` VALUES ('130185', '鹿泉市', '130100', '24');

INSERT INTO `cmswing_area` VALUES ('130201', '市辖区', '130200', '1');

INSERT INTO `cmswing_area` VALUES ('130202', '路南区', '130200', '2');

INSERT INTO `cmswing_area` VALUES ('130203', '路北区', '130200', '3');

INSERT INTO `cmswing_area` VALUES ('130204', '古冶区', '130200', '4');

INSERT INTO `cmswing_area` VALUES ('130205', '开平区', '130200', '5');

INSERT INTO `cmswing_area` VALUES ('130207', '丰南区', '130200', '6');

INSERT INTO `cmswing_area` VALUES ('130208', '丰润区', '130200', '7');

INSERT INTO `cmswing_area` VALUES ('130223', '滦　县', '130200', '8');

INSERT INTO `cmswing_area` VALUES ('130224', '滦南县', '130200', '9');

INSERT INTO `cmswing_area` VALUES ('130225', '乐亭县', '130200', '10');

INSERT INTO `cmswing_area` VALUES ('130227', '迁西县', '130200', '11');

INSERT INTO `cmswing_area` VALUES ('130229', '玉田县', '130200', '12');

INSERT INTO `cmswing_area` VALUES ('130230', '唐海县', '130200', '13');

INSERT INTO `cmswing_area` VALUES ('130281', '遵化市', '130200', '14');

INSERT INTO `cmswing_area` VALUES ('130283', '迁安市', '130200', '15');

INSERT INTO `cmswing_area` VALUES ('130301', '市辖区', '130300', '1');

INSERT INTO `cmswing_area` VALUES ('130302', '海港区', '130300', '2');

INSERT INTO `cmswing_area` VALUES ('130303', '山海关区', '130300', '3');

INSERT INTO `cmswing_area` VALUES ('130304', '北戴河区', '130300', '4');

INSERT INTO `cmswing_area` VALUES ('130321', '青龙满族自治县', '130300', '5');

INSERT INTO `cmswing_area` VALUES ('130322', '昌黎县', '130300', '6');

INSERT INTO `cmswing_area` VALUES ('130323', '抚宁县', '130300', '7');

INSERT INTO `cmswing_area` VALUES ('130324', '卢龙县', '130300', '8');

INSERT INTO `cmswing_area` VALUES ('130401', '市辖区', '130400', '1');

INSERT INTO `cmswing_area` VALUES ('130402', '邯山区', '130400', '2');

INSERT INTO `cmswing_area` VALUES ('130403', '丛台区', '130400', '3');

INSERT INTO `cmswing_area` VALUES ('130404', '复兴区', '130400', '4');

INSERT INTO `cmswing_area` VALUES ('130406', '峰峰矿区', '130400', '5');

INSERT INTO `cmswing_area` VALUES ('130421', '邯郸县', '130400', '6');

INSERT INTO `cmswing_area` VALUES ('130423', '临漳县', '130400', '7');

INSERT INTO `cmswing_area` VALUES ('130424', '成安县', '130400', '8');

INSERT INTO `cmswing_area` VALUES ('130425', '大名县', '130400', '9');

INSERT INTO `cmswing_area` VALUES ('130426', '涉　县', '130400', '10');

INSERT INTO `cmswing_area` VALUES ('130427', '磁　县', '130400', '11');

INSERT INTO `cmswing_area` VALUES ('130428', '肥乡县', '130400', '12');

INSERT INTO `cmswing_area` VALUES ('130429', '永年县', '130400', '13');

INSERT INTO `cmswing_area` VALUES ('130430', '邱　县', '130400', '14');

INSERT INTO `cmswing_area` VALUES ('130431', '鸡泽县', '130400', '15');

INSERT INTO `cmswing_area` VALUES ('130432', '广平县', '130400', '16');

INSERT INTO `cmswing_area` VALUES ('130433', '馆陶县', '130400', '17');

INSERT INTO `cmswing_area` VALUES ('130434', '魏　县', '130400', '18');

INSERT INTO `cmswing_area` VALUES ('130435', '曲周县', '130400', '19');

INSERT INTO `cmswing_area` VALUES ('130481', '武安市', '130400', '20');

INSERT INTO `cmswing_area` VALUES ('130501', '市辖区', '130500', '1');

INSERT INTO `cmswing_area` VALUES ('130502', '桥东区', '130500', '2');

INSERT INTO `cmswing_area` VALUES ('130503', '桥西区', '130500', '3');

INSERT INTO `cmswing_area` VALUES ('130521', '邢台县', '130500', '4');

INSERT INTO `cmswing_area` VALUES ('130522', '临城县', '130500', '5');

INSERT INTO `cmswing_area` VALUES ('130523', '内丘县', '130500', '6');

INSERT INTO `cmswing_area` VALUES ('130524', '柏乡县', '130500', '7');

INSERT INTO `cmswing_area` VALUES ('130525', '隆尧县', '130500', '8');

INSERT INTO `cmswing_area` VALUES ('130526', '任　县', '130500', '9');

INSERT INTO `cmswing_area` VALUES ('130527', '南和县', '130500', '10');

INSERT INTO `cmswing_area` VALUES ('130528', '宁晋县', '130500', '11');

INSERT INTO `cmswing_area` VALUES ('130529', '巨鹿县', '130500', '12');

INSERT INTO `cmswing_area` VALUES ('130530', '新河县', '130500', '13');

INSERT INTO `cmswing_area` VALUES ('130531', '广宗县', '130500', '14');

INSERT INTO `cmswing_area` VALUES ('130532', '平乡县', '130500', '15');

INSERT INTO `cmswing_area` VALUES ('130533', '威　县', '130500', '16');

INSERT INTO `cmswing_area` VALUES ('130534', '清河县', '130500', '17');

INSERT INTO `cmswing_area` VALUES ('130535', '临西县', '130500', '18');

INSERT INTO `cmswing_area` VALUES ('130581', '南宫市', '130500', '19');

INSERT INTO `cmswing_area` VALUES ('130582', '沙河市', '130500', '20');

INSERT INTO `cmswing_area` VALUES ('130601', '市辖区', '130600', '1');

INSERT INTO `cmswing_area` VALUES ('130602', '新市区', '130600', '2');

INSERT INTO `cmswing_area` VALUES ('130603', '北市区', '130600', '3');

INSERT INTO `cmswing_area` VALUES ('130604', '南市区', '130600', '4');

INSERT INTO `cmswing_area` VALUES ('130621', '满城县', '130600', '5');

INSERT INTO `cmswing_area` VALUES ('130622', '清苑县', '130600', '6');

INSERT INTO `cmswing_area` VALUES ('130623', '涞水县', '130600', '7');

INSERT INTO `cmswing_area` VALUES ('130624', '阜平县', '130600', '8');

INSERT INTO `cmswing_area` VALUES ('130625', '徐水县', '130600', '9');

INSERT INTO `cmswing_area` VALUES ('130626', '定兴县', '130600', '10');

INSERT INTO `cmswing_area` VALUES ('130627', '唐　县', '130600', '11');

INSERT INTO `cmswing_area` VALUES ('130628', '高阳县', '130600', '12');

INSERT INTO `cmswing_area` VALUES ('130629', '容城县', '130600', '13');

INSERT INTO `cmswing_area` VALUES ('130630', '涞源县', '130600', '14');

INSERT INTO `cmswing_area` VALUES ('130631', '望都县', '130600', '15');

INSERT INTO `cmswing_area` VALUES ('130632', '安新县', '130600', '16');

INSERT INTO `cmswing_area` VALUES ('130633', '易　县', '130600', '17');

INSERT INTO `cmswing_area` VALUES ('130634', '曲阳县', '130600', '18');

INSERT INTO `cmswing_area` VALUES ('130635', '蠡　县', '130600', '19');

INSERT INTO `cmswing_area` VALUES ('130636', '顺平县', '130600', '20');

INSERT INTO `cmswing_area` VALUES ('130637', '博野县', '130600', '21');

INSERT INTO `cmswing_area` VALUES ('130638', '雄　县', '130600', '22');

INSERT INTO `cmswing_area` VALUES ('130681', '涿州市', '130600', '23');

INSERT INTO `cmswing_area` VALUES ('130682', '定州市', '130600', '24');

INSERT INTO `cmswing_area` VALUES ('130683', '安国市', '130600', '25');

INSERT INTO `cmswing_area` VALUES ('130684', '高碑店市', '130600', '26');

INSERT INTO `cmswing_area` VALUES ('130701', '市辖区', '130700', '1');

INSERT INTO `cmswing_area` VALUES ('130702', '桥东区', '130700', '2');

INSERT INTO `cmswing_area` VALUES ('130703', '桥西区', '130700', '3');

INSERT INTO `cmswing_area` VALUES ('130705', '宣化区', '130700', '4');

INSERT INTO `cmswing_area` VALUES ('130706', '下花园区', '130700', '5');

INSERT INTO `cmswing_area` VALUES ('130721', '宣化县', '130700', '6');

INSERT INTO `cmswing_area` VALUES ('130722', '张北县', '130700', '7');

INSERT INTO `cmswing_area` VALUES ('130723', '康保县', '130700', '8');

INSERT INTO `cmswing_area` VALUES ('130724', '沽源县', '130700', '9');

INSERT INTO `cmswing_area` VALUES ('130725', '尚义县', '130700', '10');

INSERT INTO `cmswing_area` VALUES ('130726', '蔚　县', '130700', '11');

INSERT INTO `cmswing_area` VALUES ('130727', '阳原县', '130700', '12');

INSERT INTO `cmswing_area` VALUES ('130728', '怀安县', '130700', '13');

INSERT INTO `cmswing_area` VALUES ('130729', '万全县', '130700', '14');

INSERT INTO `cmswing_area` VALUES ('130730', '怀来县', '130700', '15');

INSERT INTO `cmswing_area` VALUES ('130731', '涿鹿县', '130700', '16');

INSERT INTO `cmswing_area` VALUES ('130732', '赤城县', '130700', '17');

INSERT INTO `cmswing_area` VALUES ('130733', '崇礼县', '130700', '18');

INSERT INTO `cmswing_area` VALUES ('130801', '市辖区', '130800', '1');

INSERT INTO `cmswing_area` VALUES ('130802', '双桥区', '130800', '2');

INSERT INTO `cmswing_area` VALUES ('130803', '双滦区', '130800', '3');

INSERT INTO `cmswing_area` VALUES ('130804', '鹰手营子矿区', '130800', '4');

INSERT INTO `cmswing_area` VALUES ('130821', '承德县', '130800', '5');

INSERT INTO `cmswing_area` VALUES ('130822', '兴隆县', '130800', '6');

INSERT INTO `cmswing_area` VALUES ('130823', '平泉县', '130800', '7');

INSERT INTO `cmswing_area` VALUES ('130824', '滦平县', '130800', '8');

INSERT INTO `cmswing_area` VALUES ('130825', '隆化县', '130800', '9');

INSERT INTO `cmswing_area` VALUES ('130826', '丰宁满族自治县', '130800', '10');

INSERT INTO `cmswing_area` VALUES ('130827', '宽城满族自治县', '130800', '11');

INSERT INTO `cmswing_area` VALUES ('130828', '围场满族蒙古族自治县', '130800', '12');

INSERT INTO `cmswing_area` VALUES ('130901', '市辖区', '130900', '1');

INSERT INTO `cmswing_area` VALUES ('130902', '新华区', '130900', '2');

INSERT INTO `cmswing_area` VALUES ('130903', '运河区', '130900', '3');

INSERT INTO `cmswing_area` VALUES ('130921', '沧　县', '130900', '4');

INSERT INTO `cmswing_area` VALUES ('130922', '青　县', '130900', '5');

INSERT INTO `cmswing_area` VALUES ('130923', '东光县', '130900', '6');

INSERT INTO `cmswing_area` VALUES ('130924', '海兴县', '130900', '7');

INSERT INTO `cmswing_area` VALUES ('130925', '盐山县', '130900', '8');

INSERT INTO `cmswing_area` VALUES ('130926', '肃宁县', '130900', '9');

INSERT INTO `cmswing_area` VALUES ('130927', '南皮县', '130900', '10');

INSERT INTO `cmswing_area` VALUES ('130928', '吴桥县', '130900', '11');

INSERT INTO `cmswing_area` VALUES ('130929', '献　县', '130900', '12');

INSERT INTO `cmswing_area` VALUES ('130930', '孟村回族自治县', '130900', '13');

INSERT INTO `cmswing_area` VALUES ('130981', '泊头市', '130900', '14');

INSERT INTO `cmswing_area` VALUES ('130982', '任丘市', '130900', '15');

INSERT INTO `cmswing_area` VALUES ('130983', '黄骅市', '130900', '16');

INSERT INTO `cmswing_area` VALUES ('130984', '河间市', '130900', '17');

INSERT INTO `cmswing_area` VALUES ('131001', '市辖区', '131000', '1');

INSERT INTO `cmswing_area` VALUES ('131002', '安次区', '131000', '2');

INSERT INTO `cmswing_area` VALUES ('131003', '广阳区', '131000', '3');

INSERT INTO `cmswing_area` VALUES ('131022', '固安县', '131000', '4');

INSERT INTO `cmswing_area` VALUES ('131023', '永清县', '131000', '5');

INSERT INTO `cmswing_area` VALUES ('131024', '香河县', '131000', '6');

INSERT INTO `cmswing_area` VALUES ('131025', '大城县', '131000', '7');

INSERT INTO `cmswing_area` VALUES ('131026', '文安县', '131000', '8');

INSERT INTO `cmswing_area` VALUES ('131028', '大厂回族自治县', '131000', '9');

INSERT INTO `cmswing_area` VALUES ('131081', '霸州市', '131000', '10');

INSERT INTO `cmswing_area` VALUES ('131082', '三河市', '131000', '11');

INSERT INTO `cmswing_area` VALUES ('131101', '市辖区', '131100', '1');

INSERT INTO `cmswing_area` VALUES ('131102', '桃城区', '131100', '2');

INSERT INTO `cmswing_area` VALUES ('131121', '枣强县', '131100', '3');

INSERT INTO `cmswing_area` VALUES ('131122', '武邑县', '131100', '4');

INSERT INTO `cmswing_area` VALUES ('131123', '武强县', '131100', '5');

INSERT INTO `cmswing_area` VALUES ('131124', '饶阳县', '131100', '6');

INSERT INTO `cmswing_area` VALUES ('131125', '安平县', '131100', '7');

INSERT INTO `cmswing_area` VALUES ('131126', '故城县', '131100', '8');

INSERT INTO `cmswing_area` VALUES ('131127', '景　县', '131100', '9');

INSERT INTO `cmswing_area` VALUES ('131128', '阜城县', '131100', '10');

INSERT INTO `cmswing_area` VALUES ('131181', '冀州市', '131100', '11');

INSERT INTO `cmswing_area` VALUES ('131182', '深州市', '131100', '12');

INSERT INTO `cmswing_area` VALUES ('140101', '市辖区', '140100', '1');

INSERT INTO `cmswing_area` VALUES ('140105', '小店区', '140100', '2');

INSERT INTO `cmswing_area` VALUES ('140106', '迎泽区', '140100', '3');

INSERT INTO `cmswing_area` VALUES ('140107', '杏花岭区', '140100', '4');

INSERT INTO `cmswing_area` VALUES ('140108', '尖草坪区', '140100', '5');

INSERT INTO `cmswing_area` VALUES ('140109', '万柏林区', '140100', '6');

INSERT INTO `cmswing_area` VALUES ('140110', '晋源区', '140100', '7');

INSERT INTO `cmswing_area` VALUES ('140121', '清徐县', '140100', '8');

INSERT INTO `cmswing_area` VALUES ('140122', '阳曲县', '140100', '9');

INSERT INTO `cmswing_area` VALUES ('140123', '娄烦县', '140100', '10');

INSERT INTO `cmswing_area` VALUES ('140181', '古交市', '140100', '11');

INSERT INTO `cmswing_area` VALUES ('140201', '市辖区', '140200', '1');

INSERT INTO `cmswing_area` VALUES ('140202', '城　区', '140200', '2');

INSERT INTO `cmswing_area` VALUES ('140203', '矿　区', '140200', '3');

INSERT INTO `cmswing_area` VALUES ('140211', '南郊区', '140200', '4');

INSERT INTO `cmswing_area` VALUES ('140212', '新荣区', '140200', '5');

INSERT INTO `cmswing_area` VALUES ('140221', '阳高县', '140200', '6');

INSERT INTO `cmswing_area` VALUES ('140222', '天镇县', '140200', '7');

INSERT INTO `cmswing_area` VALUES ('140223', '广灵县', '140200', '8');

INSERT INTO `cmswing_area` VALUES ('140224', '灵丘县', '140200', '9');

INSERT INTO `cmswing_area` VALUES ('140225', '浑源县', '140200', '10');

INSERT INTO `cmswing_area` VALUES ('140226', '左云县', '140200', '11');

INSERT INTO `cmswing_area` VALUES ('140227', '大同县', '140200', '12');

INSERT INTO `cmswing_area` VALUES ('140301', '市辖区', '140300', '1');

INSERT INTO `cmswing_area` VALUES ('140302', '城　区', '140300', '2');

INSERT INTO `cmswing_area` VALUES ('140303', '矿　区', '140300', '3');

INSERT INTO `cmswing_area` VALUES ('140311', '郊　区', '140300', '4');

INSERT INTO `cmswing_area` VALUES ('140321', '平定县', '140300', '5');

INSERT INTO `cmswing_area` VALUES ('140322', '盂　县', '140300', '6');

INSERT INTO `cmswing_area` VALUES ('140401', '市辖区', '140400', '1');

INSERT INTO `cmswing_area` VALUES ('140402', '城　区', '140400', '2');

INSERT INTO `cmswing_area` VALUES ('140411', '郊　区', '140400', '3');

INSERT INTO `cmswing_area` VALUES ('140421', '长治县', '140400', '4');

INSERT INTO `cmswing_area` VALUES ('140423', '襄垣县', '140400', '5');

INSERT INTO `cmswing_area` VALUES ('140424', '屯留县', '140400', '6');

INSERT INTO `cmswing_area` VALUES ('140425', '平顺县', '140400', '7');

INSERT INTO `cmswing_area` VALUES ('140426', '黎城县', '140400', '8');

INSERT INTO `cmswing_area` VALUES ('140427', '壶关县', '140400', '9');

INSERT INTO `cmswing_area` VALUES ('140428', '长子县', '140400', '10');

INSERT INTO `cmswing_area` VALUES ('140429', '武乡县', '140400', '11');

INSERT INTO `cmswing_area` VALUES ('140430', '沁　县', '140400', '12');

INSERT INTO `cmswing_area` VALUES ('140431', '沁源县', '140400', '13');

INSERT INTO `cmswing_area` VALUES ('140481', '潞城市', '140400', '14');

INSERT INTO `cmswing_area` VALUES ('140501', '市辖区', '140500', '1');

INSERT INTO `cmswing_area` VALUES ('140502', '城　区', '140500', '2');

INSERT INTO `cmswing_area` VALUES ('140521', '沁水县', '140500', '3');

INSERT INTO `cmswing_area` VALUES ('140522', '阳城县', '140500', '4');

INSERT INTO `cmswing_area` VALUES ('140524', '陵川县', '140500', '5');

INSERT INTO `cmswing_area` VALUES ('140525', '泽州县', '140500', '6');

INSERT INTO `cmswing_area` VALUES ('140581', '高平市', '140500', '7');

INSERT INTO `cmswing_area` VALUES ('140601', '市辖区', '140600', '1');

INSERT INTO `cmswing_area` VALUES ('140602', '朔城区', '140600', '2');

INSERT INTO `cmswing_area` VALUES ('140603', '平鲁区', '140600', '3');

INSERT INTO `cmswing_area` VALUES ('140621', '山阴县', '140600', '4');

INSERT INTO `cmswing_area` VALUES ('140622', '应　县', '140600', '5');

INSERT INTO `cmswing_area` VALUES ('140623', '右玉县', '140600', '6');

INSERT INTO `cmswing_area` VALUES ('140624', '怀仁县', '140600', '7');

INSERT INTO `cmswing_area` VALUES ('140701', '市辖区', '140700', '1');

INSERT INTO `cmswing_area` VALUES ('140702', '榆次区', '140700', '2');

INSERT INTO `cmswing_area` VALUES ('140721', '榆社县', '140700', '3');

INSERT INTO `cmswing_area` VALUES ('140722', '左权县', '140700', '4');

INSERT INTO `cmswing_area` VALUES ('140723', '和顺县', '140700', '5');

INSERT INTO `cmswing_area` VALUES ('140724', '昔阳县', '140700', '6');

INSERT INTO `cmswing_area` VALUES ('140725', '寿阳县', '140700', '7');

INSERT INTO `cmswing_area` VALUES ('140726', '太谷县', '140700', '8');

INSERT INTO `cmswing_area` VALUES ('140727', '祁　县', '140700', '9');

INSERT INTO `cmswing_area` VALUES ('140728', '平遥县', '140700', '10');

INSERT INTO `cmswing_area` VALUES ('140729', '灵石县', '140700', '11');

INSERT INTO `cmswing_area` VALUES ('140781', '介休市', '140700', '12');

INSERT INTO `cmswing_area` VALUES ('140801', '市辖区', '140800', '1');

INSERT INTO `cmswing_area` VALUES ('140802', '盐湖区', '140800', '2');

INSERT INTO `cmswing_area` VALUES ('140821', '临猗县', '140800', '3');

INSERT INTO `cmswing_area` VALUES ('140822', '万荣县', '140800', '4');

INSERT INTO `cmswing_area` VALUES ('140823', '闻喜县', '140800', '5');

INSERT INTO `cmswing_area` VALUES ('140824', '稷山县', '140800', '6');

INSERT INTO `cmswing_area` VALUES ('140825', '新绛县', '140800', '7');

INSERT INTO `cmswing_area` VALUES ('140826', '绛　县', '140800', '8');

INSERT INTO `cmswing_area` VALUES ('140827', '垣曲县', '140800', '9');

INSERT INTO `cmswing_area` VALUES ('140828', '夏　县', '140800', '10');

INSERT INTO `cmswing_area` VALUES ('140829', '平陆县', '140800', '11');

INSERT INTO `cmswing_area` VALUES ('140830', '芮城县', '140800', '12');

INSERT INTO `cmswing_area` VALUES ('140881', '永济市', '140800', '13');

INSERT INTO `cmswing_area` VALUES ('140882', '河津市', '140800', '14');

INSERT INTO `cmswing_area` VALUES ('140901', '市辖区', '140900', '1');

INSERT INTO `cmswing_area` VALUES ('140902', '忻府区', '140900', '2');

INSERT INTO `cmswing_area` VALUES ('140921', '定襄县', '140900', '3');

INSERT INTO `cmswing_area` VALUES ('140922', '五台县', '140900', '4');

INSERT INTO `cmswing_area` VALUES ('140923', '代　县', '140900', '5');

INSERT INTO `cmswing_area` VALUES ('140924', '繁峙县', '140900', '6');

INSERT INTO `cmswing_area` VALUES ('140925', '宁武县', '140900', '7');

INSERT INTO `cmswing_area` VALUES ('140926', '静乐县', '140900', '8');

INSERT INTO `cmswing_area` VALUES ('140927', '神池县', '140900', '9');

INSERT INTO `cmswing_area` VALUES ('140928', '五寨县', '140900', '10');

INSERT INTO `cmswing_area` VALUES ('140929', '岢岚县', '140900', '11');

INSERT INTO `cmswing_area` VALUES ('140930', '河曲县', '140900', '12');

INSERT INTO `cmswing_area` VALUES ('140931', '保德县', '140900', '13');

INSERT INTO `cmswing_area` VALUES ('140932', '偏关县', '140900', '14');

INSERT INTO `cmswing_area` VALUES ('140981', '原平市', '140900', '15');

INSERT INTO `cmswing_area` VALUES ('141001', '市辖区', '141000', '1');

INSERT INTO `cmswing_area` VALUES ('141002', '尧都区', '141000', '2');

INSERT INTO `cmswing_area` VALUES ('141021', '曲沃县', '141000', '3');

INSERT INTO `cmswing_area` VALUES ('141022', '翼城县', '141000', '4');

INSERT INTO `cmswing_area` VALUES ('141023', '襄汾县', '141000', '5');

INSERT INTO `cmswing_area` VALUES ('141024', '洪洞县', '141000', '6');