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 `dictionary`
  
  
  DROP TABLE IF EXISTS `dictionary`;
  /*!40101 SET @saved_cs_client = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `dictionary`
  (
      `id`            bigint(20) unsigned                             NOT NULL AUTO_INCREMENT COMMENT '用户Id',
      `dicname`         varchar(64) CHARACTER SET utf8 COLLATE utf8_bin COMMENT '字典类名',
      `diccode`          varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字典编码',
      `dicitemname`          varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字典项名',
      `dicitmevalue`          varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL 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 `dictionary`
  --
  
  LOCK TABLES `dictionary` WRITE;
  /*!40000 ALTER TABLE `dictionary`
      DISABLE KEYS */;
  INSERT INTO `dictionary`
  VALUES (1, '测试环境', 'testenviroment', '功能测试环境1','te1',
          '2019-07-01 00:00:00', '2019-07-01 00:00:00');
  INSERT INTO `dictionary`
  VALUES (2, '测试环境', 'testenviroment', '功能测试环境2','te2',
          '2019-07-01 00:00:00', '2019-07-01 00:00:00');
  INSERT INTO `dictionary`
  VALUES (3, '测试人员职务', 'testerlevel', '初级测试工程师','juniortester',
          '2019-07-01 00:00:00', '2019-07-01 00:00:00');
  INSERT INTO `dictionary`
  VALUES (4, '测试人员职务', 'testerlevel', '中级测试工程师','middletester',
          '2019-07-01 00:00:00', '2019-07-01 00:00:00');
  /*!40000 ALTER TABLE `dictionary`
      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
  