text: /*
   * Copyright 2019-2029 geekidea(https://github.com/geekidea)
   *
   * Licensed under the Apache License, Version 2.0 (the "License");
   * you may not use this file except in compliance with the License.
   * You may obtain a copy of the License at
   *
   *     http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
  */
  
  -- ----------------------------
  -- Create Database for spring_boot_plus
  -- ----------------------------
  create database if not exists spring_boot_plus character set utf8mb4;
  
  -- ----------------------------
  -- Table structure for ip
  -- ----------------------------
  DROP TABLE IF EXISTS `ip`;
  CREATE TABLE `ip`  (
    `ip_start` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `ip_end` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `area` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `operator` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `ip_start_num` bigint(20) NOT NULL,
    `ip_end_num` bigint(20) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 526718 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for sys_log
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_log`;
  CREATE TABLE `sys_log`  (
    `log_id` bigint(18) NOT NULL COMMENT '主键',
    `type` tinyint(1) NULL DEFAULT NULL COMMENT '类型',
    `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
    `create_id` bigint(18) NULL DEFAULT NULL COMMENT '创建人ID',
    `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`log_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of sys_log
  -- ----------------------------
  INSERT INTO `sys_log` VALUES (1060438746056376321, 0, 'A', 100000, '2018-11-08 15:41:58');
  INSERT INTO `sys_log` VALUES (1060438788502732802, 0, 'B', 100000, '2018-11-08 15:42:08');
  INSERT INTO `sys_log` VALUES (1060438799600861185, 0, 'C', 100000, '2018-11-08 15:42:10');
  INSERT INTO `sys_log` VALUES (1060438809495224322, 0, 'D', 100000, '2018-11-08 15:42:13');
  
  