text: -- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
  --
  -- Host: localhost    Database: admin_dev
  -- ------------------------------------------------------
  -- Server version	10.1.26-MariaDB-0+deb9u1
  
  /*!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 */;
  /*!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE */;
  /*!40103 SET TIME_ZONE = '+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
  /*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;
  
  --
  -- Table structure for table `api`
  
  
  DROP TABLE IF EXISTS `api`;
  /*!40101 SET @saved_cs_client = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `api`
  (
      `id`            bigint(20) unsigned    NOT NULL AUTO_INCREMENT COMMENT 'Id',
      `deployunitid`  bigint(20) unsigned    NOT NULL  COMMENT 'DeployUnitId',
      `deployunitname`  varchar(64) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '发布单元名',
      `apiname`       varchar(64) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '接口名',
      `visittype`     varchar(10) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '访问方式，字典表获取',
      `apistyle`     varchar(10) CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'restful,普通方式',
      `path`          varchar(200) CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'url访问路径',
      `requestcontenttype`          varchar(64) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '请求数据格式，form表单，json',
      `responecontenttype`          varchar(64) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '响应数据格式，form表单，json',
      `memo`          varchar(200) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '备注',
      `create_time`   datetime DEFAULT NOW() COMMENT '创建时间',
      `lastmodify_time`    datetime DEFAULT NOW() COMMENT '上一次修改时间',
      PRIMARY KEY (`id`)
  ) ENGINE = InnoDB
    AUTO_INCREMENT = 4
    DEFAULT CHARSET = utf8mb4 COMMENT ='发布单元表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `api`
  --
  
  LOCK TABLES `api` WRITE;
  /*!40000 ALTER TABLE `api`
      DISABLE KEYS */;
  INSERT INTO `api`
  VALUES (1, 1,'getUserNamebyID','根据id获取用户名', 'get', '/user','json','html','根据id获取用户名',
          '2019-07-01 00:00:00', '2019-07-01 00:00:00');
  /*!40000 ALTER TABLE `api`
      ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE = @OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE = @OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT = @OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS = @OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION = @OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES = @OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-02-16 19:24:53
  