platomix-tool/platomix-docker/docker-api/apimngr_20230228.sql

-- MySQL dump 10.13  Distrib 5.7.40, for Linux (x86_64)
--
-- Host: localhost    Database: apimngr
-- ------------------------------------------------------
-- Server version	5.7.40

/*!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 `t_api`
--

CREATE DATABASE IF NOT EXISTS apimngr;
USE apimngr;

DROP TABLE IF EXISTS `t_api`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api` (
  `api_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `api_name` varchar(100) NOT NULL COMMENT '接口名称',
  `url` varchar(200) NOT NULL COMMENT '请求地址',
  `cgi_url` varchar(200) DEFAULT NULL,
  `api_type_id` int(11) DEFAULT NULL,
  `call_limit` varchar(50) DEFAULT NULL COMMENT '调用量限制',
  `qps_limit` varchar(50) DEFAULT NULL COMMENT 'QPS限制',
  `status` int(11) DEFAULT NULL COMMENT '状态 0=免费使用 1=付费开通 2=测试使用 3=VIP使用',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `version` varchar(30) DEFAULT NULL,
  `doc_url` varchar(100) DEFAULT NULL,
  `create_by` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `browser_count` int(11) NOT NULL DEFAULT '0',
  `ext_json` text,
  `apply_user_id` int(11) DEFAULT NULL COMMENT '申请人id',
  `mobile` varchar(20) DEFAULT NULL COMMENT '联系方式',
  `apply_status` int(11) DEFAULT NULL COMMENT '申请状态：0未审核  1已审核',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `disagree_reason` varchar(500) DEFAULT NULL,
  `is_apply` int(11) DEFAULT NULL COMMENT '是否是申请新增：0否 1是',
  PRIMARY KEY (`api_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='接口表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api`
--

LOCK TABLES `t_api` WRITE;
/*!40000 ALTER TABLE `t_api` DISABLE KEYS */;
INSERT INTO `t_api` VALUES (1,'销售接口','https://windata.platomix.net/bi-api/report/dataapi/GoodsSales','http://114.116.34.93:8888/8c4885f4a76e40638c68c22d9bfba952/1',1,'100000','1000',1,'','1.0.0','http://114.116.34.93:8888/8c4885f4a76e40638c68c22d9bfba952/1','admin','2023-02-28 15:22:48','2023-02-28 16:17:03',10,'{\n  \"method\": \"请求方式\",\n  \"params\": [\n    {\n      \"name\": \"参数名称\",\n      \"type\": \"参数类型\",\n      \"required\": \"是否必填\",\n      \"description\": \"参数说明\",\n      \"default\": \"无\"\n    }\n  ],\n  \"returnParams\": [\n    {\n      \"name\": \"销售额\",\n      \"type\": \"指标\",\n      \"description\": \"销售额\"\n    }\n  ],\n  \"response\": {\n    \"code\": \"返回码\",\n    \"message\": \"返回信息\",\n    \"data\": \"返回数据\"\n  }\n}',NULL,NULL,2,NULL,NULL,NULL),(2,'','',NULL,NULL,NULL,NULL,NULL,'需要增加销售接口数据',NULL,NULL,NULL,'2023-02-28 16:07:40','2023-02-28 16:07:55',0,NULL,2,'13800013800',1,'2023-02-28 08:07:40','null',1);
/*!40000 ALTER TABLE `t_api` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_auth_apply`
--

DROP TABLE IF EXISTS `t_api_auth_apply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_auth_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID\n',
  `api_id` int(11) DEFAULT NULL COMMENT '接口id',
  `apply_use` varchar(500) NOT NULL COMMENT '申请用途',
  `status` int(11) DEFAULT NULL COMMENT '审核状态:0 未审核、1 已审核',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `examine_user_id` int(11) DEFAULT NULL COMMENT '审核用户ID\n',
  `examine_content` int(11) DEFAULT NULL COMMENT '审核内容:0 不同意、0 已同意',
  `disagree_reason` varchar(500) DEFAULT NULL COMMENT '不通过原因',
  `examine_time` datetime DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='接口申请权限';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_auth_apply`
--

LOCK TABLES `t_api_auth_apply` WRITE;
/*!40000 ALTER TABLE `t_api_auth_apply` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_api_auth_apply` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_collect`
--

DROP TABLE IF EXISTS `t_api_collect`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_collect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID\n',
  `api_id` int(11) DEFAULT NULL COMMENT '接口id',
  `is_collect` int(11) DEFAULT NULL COMMENT '是否收藏:1 是、0 否',
  `create_time` datetime DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='接口收藏';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_collect`
--

LOCK TABLES `t_api_collect` WRITE;
/*!40000 ALTER TABLE `t_api_collect` DISABLE KEYS */;
INSERT INTO `t_api_collect` VALUES (1,2,1,0,'2023-02-28 08:05:30','2023-02-28 16:05:53');
/*!40000 ALTER TABLE `t_api_collect` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_log`
--

DROP TABLE IF EXISTS `t_api_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_log` (
  `apilog_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `app_id` int(11) DEFAULT NULL COMMENT '应用id',
  `api_id` int(11) DEFAULT NULL COMMENT '接口id',
  `call_result` int(11) DEFAULT NULL COMMENT '调用结果 1=成功 0=失败',
  `invoke_time` varchar(50) NOT NULL,
  `response_time` varchar(100) DEFAULT NULL COMMENT '接口返回时间',
  `img_url` varchar(500) DEFAULT NULL COMMENT '图片路径',
  `err_code` varchar(30) DEFAULT NULL COMMENT '错误码',
  `invoke_date` datetime DEFAULT NULL COMMENT '调用时间',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `user_name` varchar(100) DEFAULT NULL COMMENT '用户姓名',
  `params` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`apilog_id`,`invoke_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='接口日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_log`
--

LOCK TABLES `t_api_log` WRITE;
/*!40000 ALTER TABLE `t_api_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_api_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_log_day`
--

DROP TABLE IF EXISTS `t_api_log_day`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_log_day` (
  `user_id` int(11) NOT NULL COMMENT '开发者id',
  `user_name` varchar(100) DEFAULT NULL COMMENT '开发者名称',
  `app_id` int(11) NOT NULL COMMENT '应用id',
  `app_name` varchar(100) DEFAULT NULL COMMENT '应用名称',
  `api_id` int(11) NOT NULL COMMENT '接口id',
  `api_name` varchar(255) DEFAULT NULL COMMENT '应用名称',
  `total` int(11) DEFAULT NULL COMMENT '调用成功次数',
  `failed` int(11) DEFAULT NULL COMMENT '调用失败次数',
  `qps` int(11) DEFAULT NULL COMMENT 'qps峰值',
  `day` varchar(50) DEFAULT NULL COMMENT '日期'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='接口日志--日表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_log_day`
--

LOCK TABLES `t_api_log_day` WRITE;
/*!40000 ALTER TABLE `t_api_log_day` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_api_log_day` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_log_hour`
--

DROP TABLE IF EXISTS `t_api_log_hour`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_log_hour` (
  `app_id` int(11) NOT NULL COMMENT '应用id',
  `api_id` int(11) NOT NULL COMMENT '接口id',
  `success` int(11) DEFAULT NULL COMMENT '成功次数',
  `failed` int(11) DEFAULT NULL COMMENT '失败次数',
  `qps` int(11) DEFAULT NULL COMMENT 'qps峰值',
  `day` varchar(30) DEFAULT NULL COMMENT '日期 yyyy-mm-dd hh:mm'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='接口日志--时表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_log_hour`
--

LOCK TABLES `t_api_log_hour` WRITE;
/*!40000 ALTER TABLE `t_api_log_hour` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_api_log_hour` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_log_test`
--

DROP TABLE IF EXISTS `t_api_log_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_log_test` (
  `apilog_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT NULL,
  `api_id` int(11) DEFAULT NULL,
  `call_result` int(11) DEFAULT NULL,
  `invoke_time` bigint(20) NOT NULL,
  `response_time` varchar(100) DEFAULT NULL,
  `img_url` varchar(500) DEFAULT NULL,
  `err_code` varchar(30) DEFAULT NULL,
  `invoke_date` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(100) DEFAULT NULL,
  `params` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`apilog_id`),
  KEY `app_id` (`app_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE,
  KEY `call_result_index` (`call_result`),
  KEY `api_id_index` (`api_id`),
  KEY `err_code_index` (`err_code`),
  KEY `ind_invoke_time` (`invoke_time`),
  KEY `ind2` (`call_result`,`invoke_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_log_test`
--

LOCK TABLES `t_api_log_test` WRITE;
/*!40000 ALTER TABLE `t_api_log_test` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_api_log_test` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_need_apply`
--

DROP TABLE IF EXISTS `t_api_need_apply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_need_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID\n',
  `api_id` int(11) DEFAULT NULL COMMENT '接口id',
  `mobile` varchar(20) NOT NULL COMMENT '联系方式',
  `field_json` varchar(1000) NOT NULL COMMENT '联系方式',
  `description` varchar(500) NOT NULL COMMENT '描述',
  `status` int(11) DEFAULT NULL COMMENT '审核状态:审核状态:0 未审核、1 已审核待开发 2已审核已完成 3审核不通过',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `examine_user_id` int(11) DEFAULT NULL COMMENT '审核用户ID\n',
  `disagree_reason` varchar(500) DEFAULT NULL COMMENT '不通过原因',
  `examine_time` datetime DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='接口申请开发';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_need_apply`
--

LOCK TABLES `t_api_need_apply` WRITE;
/*!40000 ALTER TABLE `t_api_need_apply` DISABLE KEYS */;
INSERT INTO `t_api_need_apply` VALUES (1,2,1,'13800013800','[{\"param\":\"销售笔单价\",\"desc\":\"销售笔单价\"},{\"param\":\"客单价\",\"desc\":\"客单价\"}]','需要增加销售字段',1,'2023-02-28 08:05:27',1,'null','2023-02-28 08:06:39');
/*!40000 ALTER TABLE `t_api_need_apply` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_type`
--

DROP TABLE IF EXISTS `t_api_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_type` (
  `apitype_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `type_name` varchar(100) NOT NULL COMMENT '类型名称',
  `description` varchar(100) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`apitype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='接口类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_type`
--

LOCK TABLES `t_api_type` WRITE;
/*!40000 ALTER TABLE `t_api_type` DISABLE KEYS */;
INSERT INTO `t_api_type` VALUES (1,'销售接口','');
/*!40000 ALTER TABLE `t_api_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_api_version`
--

DROP TABLE IF EXISTS `t_api_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_api_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) NOT NULL,
  `old_version` varchar(50) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(100) DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_api_version`
--

LOCK TABLES `t_api_version` WRITE;
/*!40000 ALTER TABLE `t_api_version` DISABLE KEYS */;
INSERT INTO `t_api_version` VALUES (1,1,'1.0.0','2023-02-28 15:22:48','admin','');
/*!40000 ALTER TABLE `t_api_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_app`
--

DROP TABLE IF EXISTS `t_app`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_app` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) NOT NULL COMMENT '应用名称',
  `user_id` int(11) NOT NULL COMMENT '关联用户id',
  `app_type_id` int(11) NOT NULL COMMENT '应用类型id',
  `api_key` varchar(100) NOT NULL COMMENT 'API Key',
  `secret_key` varchar(100) NOT NULL COMMENT 'Secret Key',
  `create_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(50) DEFAULT NULL COMMENT '更新时间',
  `status` int(11) DEFAULT NULL COMMENT '应用状态（1=正常 0=停用 2=待审核）',
  `description` varchar(100) DEFAULT NULL COMMENT '应用描述',
  `expire_date` varchar(50) DEFAULT NULL COMMENT '到期日期',
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='应用表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_app`
--

LOCK TABLES `t_app` WRITE;
/*!40000 ALTER TABLE `t_app` DISABLE KEYS */;
INSERT INTO `t_app` VALUES (1,'销售应用',2,1,'4dc5bd0a63dd478db693e916','d8b34a193c7e418fa1626f0140b9df05','2023-02-28 15:57:29',NULL,1,'','Invalid date');
/*!40000 ALTER TABLE `t_app` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_app_api`
--

DROP TABLE IF EXISTS `t_app_api`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_app_api` (
  `appapi_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `app_id` int(11) NOT NULL COMMENT '应用id',
  `api_id` int(11) NOT NULL COMMENT '接口id',
  `status` int(11) NOT NULL COMMENT '状态 0=待审核 1=正常使用 2=待支付 3=停用',
  `call_limit` varchar(50) DEFAULT NULL COMMENT '调用量限制',
  `qps_limit` varchar(50) DEFAULT NULL COMMENT 'QPS限制',
  `qps_apply_id` varchar(50) DEFAULT NULL COMMENT '更高QPS申请id',
  `used` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`appapi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='接口权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_app_api`
--

LOCK TABLES `t_app_api` WRITE;
/*!40000 ALTER TABLE `t_app_api` DISABLE KEYS */;
INSERT INTO `t_app_api` VALUES (3,1,1,1,'100000','1000',NULL,NULL);
/*!40000 ALTER TABLE `t_app_api` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_app_type`
--

DROP TABLE IF EXISTS `t_app_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_app_type` (
  `apptype_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `type_name` varchar(100) NOT NULL COMMENT '应用类型名称',
  `description` varchar(100) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`apptype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='应用类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_app_type`
--

LOCK TABLES `t_app_type` WRITE;
/*!40000 ALTER TABLE `t_app_type` DISABLE KEYS */;
INSERT INTO `t_app_type` VALUES (1,'销售类应用','销售的API');
/*!40000 ALTER TABLE `t_app_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_auth`
--

DROP TABLE IF EXISTS `t_auth`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_auth` (
  `auth_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `api_id` int(11) NOT NULL COMMENT '接口id',
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_auth`
--

LOCK TABLES `t_auth` WRITE;
/*!40000 ALTER TABLE `t_auth` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_auth` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_code_info`
--

DROP TABLE IF EXISTS `t_code_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_code_info` (
  `err_code` varchar(30) NOT NULL COMMENT '错误码',
  `err_detail` varchar(200) DEFAULT NULL COMMENT '错误详情',
  `err_description` varchar(200) DEFAULT NULL COMMENT '错误描述',
  `feedback` varchar(200) DEFAULT NULL COMMENT '处理意见',
  KEY `err_code_index` (`err_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_code_info`
--

LOCK TABLES `t_code_info` WRITE;
/*!40000 ALTER TABLE `t_code_info` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_code_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_qps_apply`
--

DROP TABLE IF EXISTS `t_qps_apply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_qps_apply` (
  `qps_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `max_qps` varchar(50) NOT NULL COMMENT '预估最高QPS',
  `call_times` varchar(50) DEFAULT NULL COMMENT '预估每日调用量',
  `areas` varchar(200) DEFAULT NULL COMMENT '接入地域比例',
  `company_name` varchar(100) DEFAULT NULL COMMENT '公司名称',
  `phone` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(100) DEFAULT NULL COMMENT '联系邮箱',
  `description` varchar(2000) DEFAULT NULL COMMENT '应用介绍',
  `apply_reason` varchar(1000) DEFAULT NULL COMMENT '提升配额原因',
  `apply_status` tinyint(4) DEFAULT NULL COMMENT '申请状态 0=默认配额 1=审核通过 2=审核中 3=审核拒绝',
  PRIMARY KEY (`qps_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='更高QPS申请';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_qps_apply`
--

LOCK TABLES `t_qps_apply` WRITE;
/*!40000 ALTER TABLE `t_qps_apply` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_qps_apply` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_role`
--

DROP TABLE IF EXISTS `t_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(50) NOT NULL COMMENT '角色名字',
  `role_type` int(11) NOT NULL COMMENT '角色类型',
  `description` varchar(100) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_role`
--

LOCK TABLES `t_role` WRITE;
/*!40000 ALTER TABLE `t_role` DISABLE KEYS */;
INSERT INTO `t_role` VALUES (1,'管理员',1,NULL),(2,'开发者',2,'123');
/*!40000 ALTER TABLE `t_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_sms_log`
--

DROP TABLE IF EXISTS `t_sms_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_sms_log` (
  `sms_id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(30) NOT NULL COMMENT '电话号码',
  `code` varchar(20) NOT NULL COMMENT '验证码',
  `create_time` varchar(30) NOT NULL COMMENT '创建时间',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  PRIMARY KEY (`sms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_sms_log`
--

LOCK TABLES `t_sms_log` WRITE;
/*!40000 ALTER TABLE `t_sms_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_sms_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_system_log`
--

DROP TABLE IF EXISTS `t_system_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_system_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_account` varchar(100) NOT NULL COMMENT '日志账号',
  `log_content` varchar(200) NOT NULL COMMENT '日志内容',
  `log_ip` varchar(100) DEFAULT NULL COMMENT 'ip地址',
  `log_time` datetime DEFAULT NULL COMMENT '日期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=427 DEFAULT CHARSET=utf8mb4 COMMENT='系统日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_system_log`
--

LOCK TABLES `t_system_log` WRITE;
/*!40000 ALTER TABLE `t_system_log` DISABLE KEYS */;
INSERT INTO `t_system_log` VALUES (1,'admin','/api/user/info','114.245.110.33','2023-02-28 15:08:14'),(2,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:08:14'),(3,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:08:14'),(4,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:08:14'),(5,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:08:14'),(6,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:08:14'),(7,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:08:14'),(8,'admin','/api/user/info','114.245.110.33','2023-02-28 15:11:58'),(9,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:11:58'),(10,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:11:58'),(11,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:11:58'),(12,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:11:58'),(13,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:11:58'),(14,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:11:58'),(15,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:12:06'),(16,'admin','/api/user/info','114.245.110.33','2023-02-28 15:12:17'),(17,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:12:17'),(18,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:12:17'),(19,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:12:17'),(20,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:12:17'),(21,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:12:17'),(22,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:12:17'),(23,'admin','/api/user/login','114.245.110.33','2023-02-28 15:12:35'),(24,'admin','/api/user/info','114.245.110.33','2023-02-28 15:12:35'),(25,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:12:35'),(26,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:12:35'),(27,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:12:35'),(28,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:12:35'),(29,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:12:35'),(30,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:12:35'),(31,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:12:45'),(32,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:12:50'),(33,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:12:50'),(34,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:12:50'),(35,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:12:50'),(36,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:12:50'),(37,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:12:50'),(38,'test','/api/user/login','114.245.110.33','2023-02-28 15:14:13'),(39,'test','/api/user/info','114.245.110.33','2023-02-28 15:14:13'),(40,'test','/api/app/listcount','114.245.110.33','2023-02-28 15:14:13'),(41,'test','/api/apilog/generalcount','114.245.110.33','2023-02-28 15:14:13'),(42,'test','/api/appapi/listservice','114.245.110.33','2023-02-28 15:14:13'),(43,'test','/api/app/list','114.245.110.33','2023-02-28 15:14:17'),(44,'test','/api/app/list','114.245.110.33','2023-02-28 15:15:28'),(45,'test','/api/apimngr/listapis','114.245.110.33','2023-02-28 15:15:28'),(46,'test','/api/apptype/list','114.245.110.33','2023-02-28 15:15:28'),(47,'admin','/api/user/login','114.245.110.33','2023-02-28 15:16:10'),(48,'admin','/api/user/info','114.245.110.33','2023-02-28 15:16:10'),(49,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:16:10'),(50,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:16:10'),(51,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:16:10'),(52,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:16:10'),(53,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:16:10'),(54,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:16:10'),(55,'admin','/api/user/login','114.245.110.33','2023-02-28 15:20:04'),(56,'admin','/api/user/info','114.245.110.33','2023-02-28 15:20:04'),(57,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:20:04'),(58,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:20:04'),(59,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:20:04'),(60,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:20:04'),(61,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:20:04'),(62,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:20:04'),(63,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:20:08'),(64,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:20:13'),(65,'admin','/api/apptype/insert','114.245.110.33','2023-02-28 15:20:46'),(66,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:20:46'),(67,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:20:58'),(68,'admin','/api/app/list','114.245.110.33','2023-02-28 15:20:59'),(69,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:21:00'),(70,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:21:00'),(71,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 15:21:00'),(72,'admin','/api/app/list','114.245.110.33','2023-02-28 15:21:00'),(73,'admin','/api/user/listdev','114.245.110.33','2023-02-28 15:21:00'),(74,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:21:28'),(75,'admin','/api/apitype/insert','114.245.110.33','2023-02-28 15:21:35'),(76,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:21:35'),(77,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:21:42'),(78,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:21:42'),(79,'admin','/api/role/list','114.245.110.33','2023-02-28 15:21:42'),(80,'admin','/api/apimngr/insert','114.245.110.33','2023-02-28 15:22:48'),(81,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:22:48'),(82,'admin','/api/apimngr/insert','114.245.110.33','2023-02-28 15:25:06'),(83,'admin','/api/user/info','114.245.110.33','2023-02-28 15:25:11'),(84,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:25:11'),(85,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:25:11'),(86,'admin','/api/role/list','114.245.110.33','2023-02-28 15:25:11'),(87,'admin','/api/user/info','114.245.110.33','2023-02-28 15:25:17'),(88,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:25:17'),(89,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:25:17'),(90,'admin','/api/role/list','114.245.110.33','2023-02-28 15:25:17'),(91,'admin','/api/user/info','114.245.110.33','2023-02-28 15:25:23'),(92,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:25:23'),(93,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:25:23'),(94,'admin','/api/role/list','114.245.110.33','2023-02-28 15:25:23'),(95,'admin','/api/apimngr/apicount','114.245.110.33','2023-02-28 15:28:03'),(96,'admin','/api/user/topdevelopers','114.245.110.33','2023-02-28 15:28:03'),(97,'admin','/api/app/appcount','114.245.110.33','2023-02-28 15:28:03'),(98,'admin','/api/app/topapps','114.245.110.33','2023-02-28 15:28:03'),(99,'admin','/api/user/developercount','114.245.110.33','2023-02-28 15:28:03'),(100,'admin','/api/apimngr/topapis','114.245.110.33','2023-02-28 15:28:03'),(101,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:28:06'),(102,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:06'),(103,'admin','/api/role/list','114.245.110.33','2023-02-28 15:28:06'),(104,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:11'),(105,'admin','/api/appapi/listqpsapply','114.245.110.33','2023-02-28 15:28:11'),(106,'admin','/api/user/info','114.245.110.33','2023-02-28 15:28:14'),(107,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:14'),(108,'admin','/api/appapi/listqpsapply','114.245.110.33','2023-02-28 15:28:14'),(109,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:16'),(110,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:28:16'),(111,'admin','/api/user/info','114.245.110.33','2023-02-28 15:28:17'),(112,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:18'),(113,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:28:18'),(114,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 15:28:19'),(115,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 15:28:19'),(116,'admin','/api/user/listdevbyadmin','114.245.110.33','2023-02-28 15:28:25'),(117,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:28:32'),(118,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:28:32'),(119,'admin','/api/role/list','114.245.110.33','2023-02-28 15:28:32'),(120,'admin','/api/user/info','114.245.110.33','2023-02-28 15:41:34'),(121,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:41:35'),(122,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:41:35'),(123,'admin','/api/role/list','114.245.110.33','2023-02-28 15:41:35'),(124,'admin','/api/user/login','114.245.110.33','2023-02-28 15:41:54'),(125,'admin','/api/user/info','114.245.110.33','2023-02-28 15:41:54'),(126,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:41:54'),(127,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:41:54'),(128,'admin','/api/role/list','114.245.110.33','2023-02-28 15:41:54'),(129,'admin','/api/user/info','114.245.110.33','2023-02-28 15:53:41'),(130,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:53:42'),(131,'admin','/api/role/list','114.245.110.33','2023-02-28 15:53:42'),(132,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:53:42'),(133,'admin','/api/user/info','114.245.110.33','2023-02-28 15:53:48'),(134,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:53:49'),(135,'admin','/api/role/list','114.245.110.33','2023-02-28 15:53:49'),(136,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:53:49'),(137,'admin','/api/user/info','114.245.110.33','2023-02-28 15:53:56'),(138,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:53:56'),(139,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:53:56'),(140,'admin','/api/role/list','114.245.110.33','2023-02-28 15:53:56'),(141,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:54:53'),(142,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:54:53'),(143,'admin','/api/role/list','114.245.110.33','2023-02-28 15:54:53'),(144,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 15:55:16'),(145,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:55:16'),(146,'admin','/api/user/info','114.245.110.33','2023-02-28 15:55:32'),(147,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:55:33'),(148,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:55:33'),(149,'admin','/api/role/list','114.245.110.33','2023-02-28 15:55:33'),(150,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 15:55:45'),(151,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:55:46'),(152,'admin','/api/user/info','114.245.110.33','2023-02-28 15:56:09'),(153,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:09'),(154,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:56:09'),(155,'admin','/api/role/list','114.245.110.33','2023-02-28 15:56:09'),(156,'admin','/api/appapi/listqpsapply','114.245.110.33','2023-02-28 15:56:14'),(157,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:14'),(158,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:56:15'),(159,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:15'),(160,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 15:56:17'),(161,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 15:56:17'),(162,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:56:19'),(163,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:20'),(164,'admin','/api/app/list','114.245.110.33','2023-02-28 15:56:20'),(165,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 15:56:21'),(166,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:21'),(167,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:56:21'),(168,'admin','/api/app/list','114.245.110.33','2023-02-28 15:56:21'),(169,'admin','/api/user/listdev','114.245.110.33','2023-02-28 15:56:21'),(170,'admin','/api/user/info','114.245.110.33','2023-02-28 15:56:29'),(171,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:56:30'),(172,'admin','/api/role/list','114.245.110.33','2023-02-28 15:56:30'),(173,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:56:30'),(174,'admin','/api/app/insertbyadmin','114.245.110.33','2023-02-28 15:57:29'),(175,'admin','/api/app/list','114.245.110.33','2023-02-28 15:57:30'),(176,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:57:35'),(177,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:40'),(178,'admin','/api/app/list','114.245.110.33','2023-02-28 15:57:40'),(179,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:57:44'),(180,'admin','/api/role/list','114.245.110.33','2023-02-28 15:57:44'),(181,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:44'),(182,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:50'),(183,'admin','/api/apptype/list','114.245.110.33','2023-02-28 15:57:50'),(184,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 15:57:50'),(185,'admin','/api/user/listdev','114.245.110.33','2023-02-28 15:57:50'),(186,'admin','/api/app/list','114.245.110.33','2023-02-28 15:57:50'),(187,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:52'),(188,'admin','/api/role/list','114.245.110.33','2023-02-28 15:57:52'),(189,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:57:52'),(190,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:55'),(191,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:57'),(192,'admin','/api/role/list','114.245.110.33','2023-02-28 15:57:57'),(193,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:57:57'),(194,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:57:59'),(195,'admin','/api/appapi/listqpsapply','114.245.110.33','2023-02-28 15:57:59'),(196,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:58:00'),(197,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:58:00'),(198,'admin','/api/appapi/disable','114.245.110.33','2023-02-28 15:58:07'),(199,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:58:07'),(200,'admin','/api/appapi/disable','114.245.110.33','2023-02-28 15:58:10'),(201,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:58:10'),(202,'admin','/api/appapi/update','114.245.110.33','2023-02-28 15:58:14'),(203,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:58:14'),(204,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:58:28'),(205,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:58:28'),(206,'admin','/api/role/list','114.245.110.33','2023-02-28 15:58:28'),(207,'admin','/api/user/login','114.245.110.33','2023-02-28 15:59:17'),(208,'admin','/api/user/info','114.245.110.33','2023-02-28 15:59:17'),(209,'admin','/api/apitype/list','114.245.110.33','2023-02-28 15:59:17'),(210,'admin','/api/appapi/list','114.245.110.33','2023-02-28 15:59:17'),(211,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 15:59:42'),(212,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:59:42'),(213,'test','/api/user/login','114.245.110.33','2023-02-28 15:59:47'),(214,'test','/api/user/info','114.245.110.33','2023-02-28 15:59:47'),(215,'test','/api/app/listcount','114.245.110.33','2023-02-28 15:59:47'),(216,'test','/api/apilog/generalcount','114.245.110.33','2023-02-28 15:59:47'),(217,'test','/api/appapi/listservice','114.245.110.33','2023-02-28 15:59:47'),(218,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 15:59:50'),(219,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 15:59:50'),(220,'test','/api/app/list','114.245.110.33','2023-02-28 15:59:51'),(221,'test','/api/apitype/list','114.245.110.33','2023-02-28 15:59:51'),(222,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 15:59:51'),(223,'test','/api/apimngr/list','114.245.110.33','2023-02-28 15:59:51'),(224,'test','/api/apimngr/list','114.245.110.33','2023-02-28 15:59:51'),(225,'test','/api/app/findbyid','114.245.110.33','2023-02-28 15:59:56'),(226,'test','/api/apiversion/list','114.245.110.33','2023-02-28 15:59:56'),(227,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 15:59:56'),(228,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 15:59:56'),(229,'admin','/api/user/info','114.245.110.33','2023-02-28 15:59:59'),(230,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:00'),(231,'admin','/api/role/list','114.245.110.33','2023-02-28 16:00:00'),(232,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:00:00'),(233,'test','/api/app/list','114.245.110.33','2023-02-28 16:00:05'),(234,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:00:05'),(235,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:00:05'),(236,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:00:05'),(237,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:00:05'),(238,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:19'),(239,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:00:19'),(240,'admin','/api/role/list','114.245.110.33','2023-02-28 16:00:19'),(241,'admin','/api/appapi/list','114.245.110.33','2023-02-28 16:00:25'),(242,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:25'),(243,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:27'),(244,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:00:27'),(245,'admin','/api/role/list','114.245.110.33','2023-02-28 16:00:27'),(246,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:31'),(247,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:00:31'),(248,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:00:31'),(249,'admin','/api/user/listdev','114.245.110.33','2023-02-28 16:00:31'),(250,'admin','/api/app/list','114.245.110.33','2023-02-28 16:00:31'),(251,'admin','/api/user/info','114.245.110.33','2023-02-28 16:00:37'),(252,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:00:37'),(253,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:00:37'),(254,'admin','/api/app/list','114.245.110.33','2023-02-28 16:00:37'),(255,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:37'),(256,'admin','/api/user/listdev','114.245.110.33','2023-02-28 16:00:37'),(257,'admin','/api/app/findbyid','114.245.110.33','2023-02-28 16:00:40'),(258,'admin','/api/app/update','114.245.110.33','2023-02-28 16:00:43'),(259,'admin','/api/app/list','114.245.110.33','2023-02-28 16:00:43'),(260,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:00:46'),(261,'admin','/api/apptype/update','114.245.110.33','2023-02-28 16:00:50'),(262,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:00:50'),(263,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:00:52'),(264,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:00:52'),(265,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:00:52'),(266,'admin','/api/app/list','114.245.110.33','2023-02-28 16:00:52'),(267,'admin','/api/user/listdev','114.245.110.33','2023-02-28 16:00:52'),(268,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:01:05'),(269,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:01:05'),(270,'admin','/api/role/list','114.245.110.33','2023-02-28 16:01:05'),(271,'admin','/api/user/info','114.245.110.33','2023-02-28 16:02:46'),(272,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:02:48'),(273,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:02:48'),(274,'admin','/api/role/list','114.245.110.33','2023-02-28 16:02:48'),(275,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:03:02'),(276,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:03:02'),(277,'admin','/api/user/info','114.245.110.33','2023-02-28 16:03:14'),(278,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:03:14'),(279,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:03:14'),(280,'admin','/api/role/list','114.245.110.33','2023-02-28 16:03:14'),(281,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:03:42'),(282,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:03:42'),(283,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:03:42'),(284,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:03:42'),(285,'test','/api/apimngr/findRelationbyid','114.245.110.33','2023-02-28 16:03:42'),(286,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 16:03:58'),(287,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 16:03:58'),(288,'test','/api/app/list','114.245.110.33','2023-02-28 16:04:14'),(289,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:04:14'),(290,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:04:14'),(291,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:04:14'),(292,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:04:14'),(293,'test','/api/apiNeedApply/insert','114.245.110.33','2023-02-28 16:05:26'),(294,'test','/api/apiCollect/insert','114.245.110.33','2023-02-28 16:05:29'),(295,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:29'),(296,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:05:30'),(297,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:05:30'),(298,'test','/api/apiNeedApply/applyList','114.245.110.33','2023-02-28 16:05:34'),(299,'test','/api/apimngr/applyList','114.245.110.33','2023-02-28 16:05:34'),(300,'test','/api/apiNeedApply/getDetail','114.245.110.33','2023-02-28 16:05:36'),(301,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:05:39'),(302,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:05:39'),(303,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:05:39'),(304,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:39'),(305,'test','/api/apimngr/findRelationbyid','114.245.110.33','2023-02-28 16:05:39'),(306,'test','/api/apimngr/applyList','114.245.110.33','2023-02-28 16:05:42'),(307,'test','/api/apiNeedApply/applyList','114.245.110.33','2023-02-28 16:05:42'),(308,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:45'),(309,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:05:47'),(310,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:05:47'),(311,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:05:47'),(312,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:47'),(313,'test','/api/apimngr/findRelationbyid','114.245.110.33','2023-02-28 16:05:47'),(314,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:51'),(315,'test','/api/apiCollect/cancel','114.245.110.33','2023-02-28 16:05:53'),(316,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:05:53'),(317,'test','/api/apptype/list','114.245.110.33','2023-02-28 16:05:55'),(318,'test','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:05:55'),(319,'test','/api/app/list','114.245.110.33','2023-02-28 16:05:55'),(320,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:05:58'),(321,'test','/api/apptype/list','114.245.110.33','2023-02-28 16:05:58'),(322,'test','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:05:58'),(323,'test','/api/appapi/listbyappid','114.245.110.33','2023-02-28 16:05:58'),(324,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:06:00'),(325,'test','/api/app/update','114.245.110.33','2023-02-28 16:06:12'),(326,'test','/api/appapi/listbyappid','114.245.110.33','2023-02-28 16:06:12'),(327,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:06:12'),(328,'test','/api/app/list','114.245.110.33','2023-02-28 16:06:21'),(329,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:06:21'),(330,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:06:21'),(331,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:06:21'),(332,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:06:21'),(333,'admin','/api/user/info','114.245.110.33','2023-02-28 16:06:29'),(334,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 16:06:29'),(335,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 16:06:29'),(336,'admin','/api/apiNeedApply/getDetail','114.245.110.33','2023-02-28 16:06:32'),(337,'admin','/api/apiNeedApply/update','114.245.110.33','2023-02-28 16:06:39'),(338,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 16:06:39'),(339,'admin','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:06:41'),(340,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:06:45'),(341,'test','/api/apimngr/applyInsertApi','114.245.110.33','2023-02-28 16:07:40'),(342,'admin','/api/user/info','114.245.110.33','2023-02-28 16:07:48'),(343,'admin','/api/apiNeedApply/examineList','114.245.110.33','2023-02-28 16:07:49'),(344,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 16:07:49'),(345,'admin','/api/apimngr/examineApi','114.245.110.33','2023-02-28 16:07:55'),(346,'admin','/api/apimngr/examineList','114.245.110.33','2023-02-28 16:07:55'),(347,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:07:59'),(348,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:08:10'),(349,'admin','/api/role/list','114.245.110.33','2023-02-28 16:08:10'),(350,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:08:10'),(351,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:08:55'),(352,'admin','/api/apimngr/listapis','114.245.110.33','2023-02-28 16:08:55'),(353,'admin','/api/apptype/list','114.245.110.33','2023-02-28 16:08:55'),(354,'admin','/api/app/list','114.245.110.33','2023-02-28 16:08:55'),(355,'admin','/api/user/listdev','114.245.110.33','2023-02-28 16:08:55'),(356,'admin','/api/app/findbyid','114.245.110.33','2023-02-28 16:10:46'),(357,'admin','/api/appapi/listqpsapply','114.245.110.33','2023-02-28 16:11:47'),(358,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:11:47'),(359,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:11:50'),(360,'admin','/api/role/list','114.245.110.33','2023-02-28 16:11:50'),(361,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:11:50'),(362,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:12:02'),(363,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:12:02'),(364,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:12:18'),(365,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:12:18'),(366,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:12:18'),(367,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:12:18'),(368,'test','/api/app/list','114.245.110.33','2023-02-28 16:12:25'),(369,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:12:25'),(370,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:12:25'),(371,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:12:25'),(372,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:12:25'),(373,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:12:29'),(374,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:12:29'),(375,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:12:29'),(376,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:12:29'),(377,'test','/api/app/list','114.245.110.33','2023-02-28 16:12:37'),(378,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:12:37'),(379,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:12:37'),(380,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:12:37'),(381,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:12:37'),(382,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:12:50'),(383,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:14:15'),(384,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:14:15'),(385,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:14:15'),(386,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:14:15'),(387,'admin','/api/apitype/list','114.245.110.33','2023-02-28 16:14:28'),(388,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:14:28'),(389,'admin','/api/role/list','114.245.110.33','2023-02-28 16:14:28'),(390,'admin','/api/apimngr/delete','114.245.110.33','2023-02-28 16:15:01'),(391,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:15:19'),(392,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:15:19'),(393,'test','/api/user/info','114.245.110.33','2023-02-28 16:15:25'),(394,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:15:25'),(395,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:15:25'),(396,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:15:25'),(397,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:15:25'),(398,'test','/api/apimngr/findRelationbyid','114.245.110.33','2023-02-28 16:15:25'),(399,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:15:50'),(400,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:15:50'),(401,'admin','/api/apimngr/update','114.245.110.33','2023-02-28 16:17:03'),(402,'admin','/api/apimngr/list','114.245.110.33','2023-02-28 16:17:03'),(403,'test','/api/user/info','114.245.110.33','2023-02-28 16:17:07'),(404,'test','/api/app/findbyid','114.245.110.33','2023-02-28 16:17:08'),(405,'test','/api/apimngr/findbyid','114.245.110.33','2023-02-28 16:17:08'),(406,'test','/api/apiversion/list','114.245.110.33','2023-02-28 16:17:08'),(407,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:17:08'),(408,'test','/api/apimngr/findRelationbyid','114.245.110.33','2023-02-28 16:17:08'),(409,'test','/api/app/list','114.245.110.33','2023-02-28 16:17:32'),(410,'test','/api/app/list','114.245.110.33','2023-02-28 16:17:35'),(411,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:17:35'),(412,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:17:35'),(413,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:17:35'),(414,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:17:35'),(415,'test','/api/app/list','114.245.110.33','2023-02-28 16:20:16'),(416,'test','/api/app/listcount','114.245.110.33','2023-02-28 16:20:18'),(417,'test','/api/appapi/listservice','114.245.110.33','2023-02-28 16:20:18'),(418,'test','/api/apilog/generalcount','114.245.110.33','2023-02-28 16:20:18'),(419,'test','/api/app/list','114.245.110.33','2023-02-28 16:20:21'),(420,'test','/api/apitype/list','114.245.110.33','2023-02-28 16:20:21'),(421,'test','/api/apiCollect/list','114.245.110.33','2023-02-28 16:20:21'),(422,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:20:21'),(423,'test','/api/apimngr/list','114.245.110.33','2023-02-28 16:20:21'),(424,'test','/api/apilog/generalcount','114.245.110.33','2023-02-28 16:20:23'),(425,'test','/api/app/listcount','114.245.110.33','2023-02-28 16:20:23'),(426,'test','/api/appapi/listservice','114.245.110.33','2023-02-28 16:20:23');
/*!40000 ALTER TABLE `t_system_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user`
--

DROP TABLE IF EXISTS `t_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(100) NOT NULL COMMENT '姓名',
  `account` varchar(50) NOT NULL COMMENT '账号',
  `phone` varchar(30) NOT NULL COMMENT '电话',
  `password_hash` varchar(100) NOT NULL COMMENT '密码',
  `email` varchar(50) NOT NULL COMMENT '邮箱',
  `status` int(11) DEFAULT NULL COMMENT '用户状态（1=免费用户 0=异常用户 2=付费用户 3=VIP用户 4=测试用户)',
  `role_id` int(11) NOT NULL COMMENT '角色',
  `description` varchar(100) DEFAULT NULL COMMENT '备注',
  `company_name` varchar(100) DEFAULT NULL,
  `company_info` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user`
--

LOCK TABLES `t_user` WRITE;
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` VALUES (1,'平台管理员','admin','13382890928','a3f4c511243abf2522465a603ab46f53','536818@qq.com',1,1,NULL,NULL,NULL),(2,'测试开发者','test','13771111749','e10adc3949ba59abbe56e057f20f883e','88933120@qq.com',1,2,'12','测试公司！！@3seiirf','gongsi ');
/*!40000 ALTER TABLE `t_user` 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 2023-02-28 17:10:33