From be23080eaeaf0c38aa29c119ec0b0731f53995e8 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期五, 20 九月 2024 14:52:01 +0800
Subject: [PATCH] http 认证
---
iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql | 22 +++++++++++-----------
1 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
index 9ef32c6..660929d 100644
--- a/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
+++ b/iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql
@@ -196,14 +196,15 @@
INSERT INTO `t_da_sequence_num` (`id`, `code`, `name`, `sequence_num`, `prefix`) VALUES ('2', 'POINT_C', '计算点编码', 100000, 'C');
CREATE TABLE `t_http_api` (
- `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ID',
- `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码',
- `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
- `url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL',
- `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方法',
- `param` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '参数',
- `descp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
- `status` int NULL DEFAULT NULL COMMENT '状态',
+ `id` varchar(36) NOT NULL COMMENT 'ID',
+ `code` varchar(32) NOT NULL COMMENT '编码',
+ `name` varchar(32) NOT NULL COMMENT '名称',
+ `url` varchar(100) NOT NULL COMMENT 'URL',
+ `method` varchar(10) NULL DEFAULT NULL COMMENT '请求方法',
+ `param` varchar(200) NULL DEFAULT NULL COMMENT '参数',
+ `descp` varchar(100) NULL DEFAULT NULL COMMENT '描述',
+ `is_auth` tinyint(1) NOT NULL COMMENT '是否认证',
+ `auth_url` varchar(36) NULL DEFAULT NULL COMMENT '认证地址',
`creator` VARCHAR(64) COMMENT '创建人' ,
`create_time` DATETIME COMMENT '创建时间' ,
`updater` VARCHAR(64) COMMENT '修改人' ,
@@ -212,20 +213,19 @@
UNIQUE KEY `uk_code` (`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Api接口' ROW_FORMAT = DYNAMIC;
-
CREATE TABLE `t_http_token` (
`id` varchar(36) NOT NULL COMMENT 'ID',
- `api_id` varchar(36) NOT NULL COMMENT '接口ID',
`login_url` varchar(200) DEFAULT NULL COMMENT '登录地址',
`client_id` varchar(100) DEFAULT NULL COMMENT 'ClientId',
`client_secret` varchar(100) DEFAULT NULL COMMENT 'ClientSecret',
`username` varchar(50) DEFAULT NULL COMMENT '用户名',
`password` varchar(50) DEFAULT NULL COMMENT '密码',
+ `refresh_freq` varchar(10) DEFAULT NULL COMMENT '刷新频率',
`token` varchar(2000) DEFAULT NULL COMMENT 'token',
`expire_time` datetime DEFAULT NULL COMMENT '过期时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
- UNIQUE KEY `uk_api_id` (`api_id`) USING BTREE
+ UNIQUE KEY `uk_login_url` (`login_url`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='接口Token';
CREATE TABLE `t_http_tag` (
--
Gitblit v1.9.3