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

The newest version!

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 '名称',
  `requestModel` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请模型',
  `responseModel` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '响应模型',
  `login` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否要登录',
  `enabled` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否可用',
  `rate_limit` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '每秒限制次数',
  `interval_limit` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '提交间隔(s)限制',
  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;