text: CREATE DATABASE ag_gate DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  /*
   Navicat Premium Data Transfer
  
   Source Server         : ag-admin
   Source Server Type    : MySQL
   Source Server Version : 50718
   Source Host           : localhost
   Source Database       : ag_gate
  
   Target Server Type    : MySQL
   Target Server Version : 50718
   File Encoding         : utf-8
  
   Date: 07/07/2017 22:23:23 PM
  */
  
  SET NAMES utf8;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  --  Table structure for `base_element`
  -- ----------------------------
  DROP TABLE IF EXISTS `base_element`;
  CREATE TABLE `base_element` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `code` varchar(255) DEFAULT NULL,
    `type` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `uri` varchar(255) DEFAULT NULL,
    `menu_id` varchar(255) DEFAULT NULL,
    `parent_id` varchar(255) DEFAULT NULL,
    `path` varchar(2000) DEFAULT NULL,
    `method` varchar(10) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `crt_time` datetime DEFAULT NULL,
    `crt_user` varchar(255) DEFAULT NULL,
    `crt_name` varchar(255) DEFAULT NULL,
    `crt_host` varchar(255) DEFAULT NULL,
    `attr1` varchar(255) DEFAULT NULL,
    `attr2` varchar(255) DEFAULT NULL,
    `attr3` varchar(255) DEFAULT NULL,
    `attr4` varchar(255) DEFAULT NULL,
    `attr5` varchar(255) DEFAULT NULL,
    `attr6` varchar(255) DEFAULT NULL,
    `attr7` varchar(255) DEFAULT NULL,
    `attr8` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  --  Records of `base_element`
  -- ----------------------------
  BEGIN;
  INSERT INTO `base_element` VALUES ('44', 'user:system', 'uri', '获取用户系统', '/api/user/un/{*}/system', '-1', null, null, 'GET', '', null, null, null, null, null, null, null, null, null, null, null, null);
  COMMIT;
  
  -- ----------------------------
  --  Table structure for `gate_client`
  -- ----------------------------
  DROP TABLE IF EXISTS `gate_client`;
  CREATE TABLE `gate_client` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `code` varchar(255) DEFAULT NULL,
    `secret` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `locked` char(1) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `crt_time` datetime DEFAULT NULL,
    `crt_user` varchar(255) DEFAULT NULL,
    `crt_name` varchar(255) DEFAULT NULL,
    `crt_host` varchar(255) DEFAULT NULL,
    `upd_time` datetime DEFAULT NULL,
    `upd_user` varchar(255) DEFAULT NULL,
    `upd_name` varchar(255) DEFAULT NULL,
    `upd_host` varchar(255) DEFAULT NULL,
    `attr1` varchar(255) DEFAULT NULL,
    `attr2` varchar(255) DEFAULT NULL,
    `attr3` varchar(255) DEFAULT NULL,
    `attr4` varchar(255) DEFAULT NULL,
    `attr5` varchar(255) DEFAULT NULL,
    `attr6` varchar(255) DEFAULT NULL,
    `attr7` varchar(255) DEFAULT NULL,
    `attr8` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  --  Records of `gate_client`
  -- ----------------------------
  BEGIN;
  INSERT INTO `gate_client` VALUES ('1', 'admin-ui', '$2a$12$zmM.eBOEpcp7wUfo7ypBSemy23bcGSEESLlIreg1FhHWV3ADoap/q', 'admin-ui', '0', '', null, '', '', '', '2017-07-07 21:51:32', '1', '管理员', '0:0:0:0:0:0:0:1', '', '', '', '', '', '', '', ''), ('3', 'admin-api-gate', '$2a$12$03C/g.y/QHnDe8P90Oi3cOS1nViIb22EoRUoeK9cWALmv5NJi1sUC', 'admin-api-gate', '0', '', null, null, null, null, '2017-07-06 21:42:17', '1', '管理员', '0:0:0:0:0:0:0:1', null, null, null, null, null, null, null, null);
  COMMIT;
  
  -- ----------------------------
  --  Table structure for `gate_client_service`
  -- ----------------------------
  DROP TABLE IF EXISTS `gate_client_service`;
  CREATE TABLE `gate_client_service` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `service_id` varchar(255) DEFAULT NULL,
    `client_id` varchar(255) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `crt_time` datetime DEFAULT NULL,
    `crt_user` varchar(255) DEFAULT NULL,
    `crt_name` varchar(255) DEFAULT NULL,
    `crt_host` varchar(255) DEFAULT NULL,
    `attr1` varchar(255) DEFAULT NULL,
    `attr2` varchar(255) DEFAULT NULL,
    `attr3` varchar(255) DEFAULT NULL,
    `attr4` varchar(255) DEFAULT NULL,
    `attr5` varchar(255) DEFAULT NULL,
    `attr6` varchar(255) DEFAULT NULL,
    `attr7` varchar(255) DEFAULT NULL,
    `attr8` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  --  Records of `gate_client_service`
  -- ----------------------------
  BEGIN;
  INSERT INTO `gate_client_service` VALUES ('20', '44', '1', null, null, null, null, null, null, null, null, null, null, null, null, null);
  COMMIT;
  
  SET FOREIGN_KEY_CHECKS = 1;
  