/*
 Navicat Premium Data Transfer

 Source Server         : 小菜鸟儿MyApi
 Source Server Type    : MySQL
 Source Server Version : 50644
 Source Host           : 47.111.144.85
 Source Database       : myapi_cainiaoer

 Target Server Type    : MySQL
 Target Server Version : 50644
 File Encoding         : utf-8

 Date: 03/11/2020 13:24:21 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `myapi_member`
-- ----------------------------
DROP TABLE IF EXISTS `myapi_member`;
CREATE TABLE `myapi_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `nickname` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '昵称',
  `mobile` varchar(15) NOT NULL,
  `password` char(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '密码',
  `salt` char(6) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '密码加密串',
  `sort` int(255) NOT NULL DEFAULT '0' COMMENT '排序',
  `is_hid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用:0否,1是',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除:0否,1是',
  `login_time` int(11) DEFAULT NULL COMMENT '上次登录时间戳',
  `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='后台用户表';

-- ----------------------------
--  Table structure for `myapi_project`
-- ----------------------------
DROP TABLE IF EXISTS `myapi_project`;
CREATE TABLE `myapi_project` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `unique_code` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '项目查看密码',
  `title` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '标题',
  `project_url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '项目地址，地址后面请加上/',
  `remark` varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '简介(SEO)',
  `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布人ID(admin表ID）',
  `status` tinyint(1) DEFAULT '0' COMMENT '项目状态，0项目启用中，1项目关闭（项目关闭后接口无法通过项目查看密码查看）',
  `is_hid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用:0否,1是',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除:0否,1是',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='项目数据表';

-- ----------------------------
--  Table structure for `myapi_project_api`
-- ----------------------------
DROP TABLE IF EXISTS `myapi_project_api`;
CREATE TABLE `myapi_project_api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) DEFAULT '0' COMMENT '文章所属项目',
  `serial_num` varchar(20) DEFAULT NULL COMMENT '接口编号，项目ID_年月日时分秒',
  `pid` int(11) DEFAULT '0' COMMENT '所属模块',
  `title` varchar(255) DEFAULT NULL,
  `api_url` varchar(255) DEFAULT '0' COMMENT '接口地址，模块/控制器/方法',
  `remark` text COMMENT '接口说明',
  `request_type` char(10) DEFAULT 'get' COMMENT '接口请求类型，post、get、put、delete、head',
  `api_param` text COMMENT '接口参数，json格式保存，内含（参数名称、参数类型、是否必须、默认值、参数说明，填充示例）',
  `return_param` text COMMENT '返回参数说明',
  `member_id` int(11) DEFAULT '0' COMMENT '添加人ID',
  `sort` int(11) DEFAULT '0',
  `is_hid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用:0否,1是',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除:0否,1是',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='项目API接口数据表';

-- ----------------------------
--  Table structure for `myapi_project_member`
-- ----------------------------
DROP TABLE IF EXISTS `myapi_project_member`;
CREATE TABLE `myapi_project_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL DEFAULT '0' COMMENT '项目ID',
  `member_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '成员ID',
  `status` tinyint(1) DEFAULT '0' COMMENT '成员状态，0申请中，1申请通过，2拒绝加入',
  `is_hid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用:0否,1是',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除:0否,1是',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='项目成员数据表';

SET FOREIGN_KEY_CHECKS = 1;