master

分支 (7)

标签 (7)

管理

管理

master

dependabot/npm_and_yarn/web/axios-0.21.1

dependabot/npm_and_yarn/web/node-notifier-8.0.1

dependabot/npm_and_yarn/web/webpack-dev-server-3.1.11

dependabot/npm_and_yarn/web/webpack-bundle-analyzer-3.3.2

dependabot/npm_and_yarn/web/lodash-4.17.19

dev

1.0.7

1.0.6

1.0.5

1.0.4

1.0.3

1.0.2

1.0.0

developer
/
java
/
developer.sql

CREATE DATABASE developer;
USE developer;


CREATE TABLE `custom_function`
(
    `id`          bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`        varchar(50)         DEFAULT NULL COMMENT '函数名称',
    `script_text` text COMMENT 'javascript脚本',
    `mark`        varchar(2048)       DEFAULT NULL COMMENT '脚本备注',
    `arguments`   varchar(1024)       DEFAULT NULL,
    `user_name`   varchar(50)         DEFAULT NULL,
    `is_public`   tinyint(1)          DEFAULT NULL,
    `create_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='自定义函数';

CREATE TABLE `custom_interfaces`
(
    `id`             bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `interfaces_id`  bigint(20) NOT NULL COMMENT '接口 id',
    `username`       varchar(50)         DEFAULT NULL COMMENT '所属用户',
    `cus_parameters` text COMMENT '参数数据结构',
    `javascript`     text,
    `pre_params`     text,
    `cus_headers`    text,
    `favorite_code`  varchar(20)         DEFAULT NULL COMMENT '收藏夹code',
    `create_time`    timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`    timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `idx_interfaces_id_username` (`interfaces_id`, `username`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='我的接口列表';

CREATE TABLE `custom_interfaces_item`
(
    `id`                   bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`                 varchar(100)        DEFAULT NULL COMMENT '用例名称',
    `custom_interfaces_id` bigint(20) NOT NULL COMMENT '收藏接口 id',
    `cus_parameters`       text COMMENT '参数数据结构',
    `javascript`           text COMMENT '检查点脚本',
    `pre_params`           text COMMENT '预置参数',
    `cus_headers`          text COMMENT '自定义header',
    `create_time`          timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`          timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `custom_interfaces_id` (`custom_interfaces_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='我的接口列表用例子项';

CREATE TABLE `end`
(
    `id`          bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`        varchar(50)         DEFAULT NULL COMMENT '项目名称',
    `prefix`      varchar(50)         DEFAULT NULL COMMENT '前缀',
    `config`      varchar(4096)       DEFAULT NULL COMMENT '登录配置',
    `header`      varchar(100)        DEFAULT NULL COMMENT 'header名',
    `mark`        varchar(255)        DEFAULT NULL COMMENT '备注',
    `create_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `prefix` (`prefix`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='前端项目';

CREATE TABLE `end_auth`
(
    `id`          bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user`        varchar(50)         DEFAULT NULL COMMENT '哪个用户的',
    `fk_end_id`   varchar(50)         DEFAULT NULL COMMENT '前端项目id',
    `config`      varchar(8192)       DEFAULT NULL COMMENT '登录配置',
    `create_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `fk_end_id` (`fk_end_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='前端项目个人账号密码管理';

CREATE TABLE `favorite`
(
    `id`             bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `version`        int(11)             DEFAULT '0' COMMENT '版本：乐观锁使用',
    `name`           varchar(50)         DEFAULT NULL COMMENT '名称',
    `owner`          varchar(100)        DEFAULT NULL COMMENT '所属者',
    `sort`           int(11)             DEFAULT '0' COMMENT '排序，小的排前面',
    `code`           varchar(20)         DEFAULT NULL COMMENT '编码：0101；01',
    `is_leaf`        tinyint(11)         DEFAULT '0' COMMENT '是否叶子节点',
    `fk_favorite_id` bigint(20)          DEFAULT NULL COMMENT '父分类ID',
    `create_time`    timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`    timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `code` (`code`),
    KEY `fk_favorite_id` (`fk_favorite_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='收藏夹';

CREATE TABLE `interfaces`
(
    `id`                    bigint(20)   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `hash`                  varchar(100) NOT NULL COMMENT '认定唯一接口标识符',
    `name`                  varchar(255)          DEFAULT NULL COMMENT '接口名称',
    `controller`            varchar(100)          DEFAULT NULL COMMENT '控制器',
    `url`                   varchar(100)          DEFAULT NULL COMMENT '接口地址，域名后面的一截如：http://g.domain.com/end/category中的end/category',
    `method`                varchar(10)           DEFAULT NULL COMMENT 'GET, POST, PUT, PATCH, DELETE',
    `deprecated`            tinyint(1)            DEFAULT NULL COMMENT '是否已经废弃',
    `mark`                  text COMMENT '详细描述：如返回值说明，接口的一些说明等',
    `returns`               text COMMENT '返回值数据结构',
    `returns_class_name`    varchar(200)          DEFAULT NULL COMMENT '返回值的参数类型',
    `parameters`            text COMMENT '参数数据结构',
    `parameters_class_name` varchar(2048)         DEFAULT NULL COMMENT '参数的参数类型',
    `fk_java_id`            bigint(20)            DEFAULT NULL COMMENT '属于哪个java项目',
    `fk_end_id`             bigint(20)            DEFAULT NULL COMMENT '属于哪个前端项目',
    `create_time`           timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`           timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `hash` (`hash`),
    KEY `fk_java_id` (`fk_java_id`),
    KEY `fk_end_id` (`fk_end_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口';

CREATE TABLE `interfaces_package`
(
    `id`           bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`         varchar(50)         DEFAULT NULL COMMENT '打包名称',
    `mark`         text COMMENT '详细描述：如返回值说明，接口的一些说明等',
    `test_case_id` bigint(20)          DEFAULT NULL COMMENT '绑定一个test_case id',
    `user_name`    varchar(225)        DEFAULT NULL COMMENT '用户名称（谁建的）',
    `config`       text COMMENT '接口聚合相关配置',
    `create_time`  timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`  timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口打包';


CREATE TABLE `interfaces_package_item`
(
    `id`                    bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `interfaces_id`         bigint(20)          DEFAULT NULL COMMENT 'interfaces id',
    `interfaces_package_id` bigint(20)          DEFAULT NULL COMMENT 'package id',
    `create_time`           timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`           timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `interfaces_package_id` (`interfaces_package_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口打包行';

CREATE TABLE `interfaces_versioned`
(
    `id`               bigint(20)   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `hash`             varchar(100) NOT NULL COMMENT '认定唯一接口标识符',
    `fk_interfaces_id` bigint(20)   NOT NULL COMMENT '接口 id',
    `name`             varchar(255)          DEFAULT NULL COMMENT '接口名称',
    `controller`       varchar(100)          DEFAULT NULL COMMENT '控制器',
    `url`              varchar(100)          DEFAULT NULL COMMENT '接口地址，域名后面的一截如：http://g.domain.com/end/category中的end/category',
    `method`           varchar(10)           DEFAULT NULL COMMENT 'GET, POST, PUT, PATCH, DELETE',
    `deprecated`       tinyint(1)            DEFAULT NULL COMMENT '是否已经废弃',
    `mark`             text COMMENT '详细描述：如返回值说明，接口的一些说明等',
    `returns`          text COMMENT '返回值数据结构',
    `parameters`       text COMMENT '参数数据结构',
    `fk_java_id`       bigint(20)            DEFAULT NULL COMMENT '属于哪个java项目',
    `fk_end_id`        bigint(20)            DEFAULT NULL COMMENT '属于哪个前端项目',
    `create_time`      timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`      timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `hash` (`hash`),
    KEY `fk_interfaces_id` (`fk_interfaces_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口历史版本';


CREATE TABLE `java`
(
    `id`            bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`          varchar(50)         DEFAULT NULL COMMENT '模块名称',
    `alias`         varchar(100)        DEFAULT NULL COMMENT '别名',
    `dev_domain`    varchar(100)        DEFAULT NULL COMMENT '开发环境域名',
    `test_domain`   varchar(100)        DEFAULT NULL COMMENT '测试环境域名',
    `prev_domain`   varchar(100)        DEFAULT NULL COMMENT '预发环境域名',
    `online_domain` varchar(100)        DEFAULT NULL COMMENT '线上环境域名',
    `wrapper`       text COMMENT '返回值包装类',
    `create_time`   timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`   timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='java模块';


CREATE TABLE `mark`
(
    `id`               bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user`             varchar(200)        DEFAULT NULL COMMENT '用户',
    `mark`             text COMMENT '备注内容',
    `fk_interfaces_id` bigint(20) NOT NULL COMMENT '接口 id',
    `create_time`      timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`      timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `fk_interfaces_id` (`fk_interfaces_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口备注';

CREATE TABLE `setting_of_user`
(
    `id`          bigint(20) NOT NULL COMMENT '主键',
    `remote`      tinyint(1)          DEFAULT NULL COMMENT '是否使用远程登录: 1-调用远程登录接口；2-使用本地user数据库',
    `url`         varchar(200)        DEFAULT NULL COMMENT '远程登录地址',
    `create_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time` timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT ='用户设置表';

CREATE TABLE `test_case`
(
    `id`            bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name`          varchar(240)        DEFAULT NULL COMMENT '用例名称',
    `user_name`     varchar(225)        DEFAULT NULL COMMENT '用户名称（谁建的）',
    `preset_params` text COMMENT '预置参数',
    `publics`       tinyint(1)          DEFAULT '0' COMMENT '是否共有',
    `mark`          varchar(1024)       DEFAULT NULL COMMENT '备注',
    `workflow`      longtext COMMENT '详细接口配置: json数据结构',
    `create_time`   timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`   timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口用例测试';

CREATE TABLE `test_case_history`
(
    `id`           bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `test_case_id` bigint(20)          DEFAULT NULL COMMENT '测试用例id',
    `name`         varchar(40)         DEFAULT NULL COMMENT '用例名称',
    `env`          varchar(100)        DEFAULT NULL COMMENT '环境',
    `user_name`    varchar(225)        DEFAULT NULL COMMENT '用户名称（谁执行的）',
    `total`        int(11)             DEFAULT '0' COMMENT '总共执行次数',
    `success`      int(11)             DEFAULT '0' COMMENT '成功次数',
    `failed`       int(11)             DEFAULT '0' COMMENT '失败次数',
    `result`       longtext COMMENT '执行结果',
    `create_time`  timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time`  timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `test_case_id` (`test_case_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='接口用例测试';

CREATE TABLE `user`
(
    `id`          bigint(20)  NOT NULL AUTO_INCREMENT COMMENT '主键',
    `username`    varchar(200)         DEFAULT NULL COMMENT '登录账户名',
    `name`        varchar(200)         DEFAULT NULL COMMENT '姓名',
    `mail`        varchar(200)         DEFAULT NULL COMMENT '邮箱',
    `cellphone`   varchar(20)          DEFAULT NULL COMMENT '联系电话',
    `password`    varchar(64)          DEFAULT NULL COMMENT '密码',
    `random`      varchar(10) NOT NULL COMMENT '随机数',
    `create_time` timestamp   NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modify_time` timestamp   NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8 COMMENT ='用户表';

insert into user (username, name, password, random)
values ('admin', 'admin', 'dacfab860b226140f3338df0875b9bf8', '56174386');