/*
Navicat MySQL Data Transfer

Source Server         : bcx
Source Server Version : 50518
Source Host           : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database       : ars

Target Server Type    : MYSQL
Target Server Version : 50518
File Encoding         : 65001

Date: 2017-06-13 08:58:36
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for cityconfig
-- ----------------------------
DROP TABLE IF EXISTS `cityconfig`;
CREATE TABLE `cityconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `nativeCode` varchar(255) DEFAULT NULL COMMENT '区域编号',
  `restURL` varchar(255) DEFAULT NULL COMMENT '接口地址',
  `trackURL` varchar(255) DEFAULT NULL COMMENT '轨迹接口地址',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `version` varchar(255) DEFAULT NULL COMMENT '版本',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `active` bit(1) DEFAULT NULL COMMENT '是否有效',
  `trainURL` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `k_city_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cityconfig
-- ----------------------------
INSERT INTO `cityconfig` VALUES ('1', '3502', 'http://120.76.218.179:9085/ars-rest/', 'http://120.76.218.179:9085/ars-rest/', '厦门市', '1.0.0', '2017-06-04 22:12:07', '2017-06-04 22:12:12', 'system', '
', 'http://120.76.218.179:9101/oledu/');
INSERT INTO `cityconfig` VALUES ('2', '3501', 'http://120.76.218.179:9085/ars-rest/', 'http://120.76.218.179:9085/ars-rest/', '福州市', '1.0.1', '2017-06-04 22:12:46', '2017-06-04 22:12:50', 'system', '
', 'http://120.76.218.179:9101/oledu/');
INSERT INTO `cityconfig` VALUES ('3', '3503', 'http://192.168.30.140:8080/ars-rest/', 'http://192.168.30.140:8080/ars-track/', '苏炳辉', '1.0.1', '2017-06-04 22:12:46', '2017-06-04 22:12:50', 'system', '
', 'http://120.76.218.179:9101/oledu/');
INSERT INTO `cityconfig` VALUES ('4', '3504', 'http://120.76.218.179:9053/ars-rest/', 'http://120.76.218.179:9053/ars-rest/', '9053', '1.0.0', '2017-06-07 16:03:02', '2017-06-07 16:03:05', 'system', '
', 'http://120.76.218.179:9101/oledu/');
INSERT INTO `cityconfig` VALUES ('5', '3502', 'http://120.76.218.179:9045/ars-rest/', 'http://120.76.218.179:9045/ars-rest/', '9045', '1.0.0', '2017-06-09 10:38:24', '2017-06-09 10:38:28', 'system', '
', 'http://120.76.218.179:9101/oledu/');
INSERT INTO `cityconfig` VALUES ('6', '3502', 'http://120.76.218.179:9085/ars-rest/', 'http://120.76.218.179:9085/ars-rest/', '9085', '1.0.0', '2017-06-09 10:38:24', '2017-06-09 10:38:28', 'system', '
', 'http://120.76.218.179:9101/oledu/');