sql.sys_api.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of api-server Show documentation

api-server

There is a newer version: 10.0.12

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_api
-- ----------------------------
DROP TABLE IF EXISTS `sys_api`;
CREATE TABLE `sys_api`  (
  `id` bigint UNSIGNED NOT NULL COMMENT '主键',
  `app_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '应用程序名',
  `group_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '分组名',
  `note_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '注解路径',
  `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '路径',
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'GET' COMMENT '请求方法',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `req` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求参数',
  `res` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '响应结果',
  `permission` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '权限值',
  `login` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否要登录',
  `sort` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
  `enabled` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可用',
  `qps_limit` int UNSIGNED NOT NULL DEFAULT 300 COMMENT '每秒限制次数',
  `reusable` bit(1) NOT NULL DEFAULT b'0' COMMENT '可重复读流',
  `repeated_limit` bigint UNSIGNED NOT NULL DEFAULT 0 COMMENT '重复请求阈值毫秒数',
  `record` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否记录访问',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `AK_ux_sys_api_ux`(`app_name`, `path`, `method`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统接口' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;