From d12129642190fd3af26112b8d21f0d07f50c6657 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 07 四月 2025 17:35:40 +0800
Subject: [PATCH] 添加外接应用接口
---
docker-compose/mysql/initdb/se_cloud_20241204.sql | 46 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 45 insertions(+), 1 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20241204.sql b/docker-compose/mysql/initdb/se_cloud_20241204.sql
index 115d76d..2a23bea 100644
--- a/docker-compose/mysql/initdb/se_cloud_20241204.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20241204.sql
@@ -107,5 +107,49 @@
insert into sys_status_ctrl (sys_name,ip,url,method,order_num) values ('鐢ㄦ埛鍙婃潈闄愮鐞�','127.0.0.1','http://localhost:8080/system/health', 'GET',1);
insert into sys_status_ctrl (sys_name,ip,url,method,order_num) values ('鏁版嵁绠＄悊鍒嗙郴缁�','127.0.0.1','http://localhost:8080/gateway/health','GET',2);
+
-- ----------------------------
-
+-- 03銆佸垎绯荤粺浠诲姟鎺у埗琛�
+-- ----------------------------
+drop table if exists sys_app_token;
+create table sys_app_token (
+ id bigint(20) not null auto_increment comment 'ID',
+ app_name varchar(200) comment '绯荤粺鍚嶇О',
+ token varchar(50) comment '浠ょ墝',
+ expire_time datetime comment '澶辨晥鏃堕棿',
+ role_name varchar(20) default 'readonly' comment '瑙掕壊鍚嶇О',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) comment '澶囨敞',
+ primary key (id)
+) engine=innodb auto_increment=1 comment = '澶栨帴搴旂敤琛�';
+select * from sys_app_token order by id; -- select * from sys_role;
+
+insert into sys_app_token (app_name, token, expire_time, role_name, create_by, create_time) values ('缁煎悎绠＄悊鍒嗙郴缁�', uuid(), '2027-01-01 00:00:00', 'superuser', 'admin', now()); -- 1801411200000
+
+-- 鑿滃崟 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
+values('澶栨帴搴旂敤', '3', '1', 'token', 'system/token/index', 1, 0, 'M', '0', '0', 'system:token:list', '#', 'admin', sysdate(), '', null, '澶栨帴搴旂敤');
+
+-- 鎸夐挳鐖惰彍鍗旾D
+SELECT @parentId := LAST_INSERT_ID();
+
+-- 鎸夐挳 SQL
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
+values('澶栨帴搴旂敤鏌ヨ', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'system:token:query', '#', 'admin', sysdate(), '', null, '', 'sys');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
+values('澶栨帴搴旂敤鏂板', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'system:token:add', '#', 'admin', sysdate(), '', null, '', 'sys');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
+values('澶栨帴搴旂敤淇敼', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'system:token:edit', '#', 'admin', sysdate(), '', null, '', 'sys');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remar, markk)
+values('澶栨帴搴旂敤鍒犻櫎', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'system:token:remove', '#', 'admin', sysdate(), '', null, '', 'sys');
+
+insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, mark)
+values('澶栨帴搴旂敤瀵煎嚭', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'system:token:export', '#', 'admin', sysdate(), '', null, '', 'sys');
+-- ----------------------------
--
Gitblit v1.9.3