From 811f2d080d12fec5b95ff41c5263e89741e16cf9 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 11 十二月 2024 10:24:08 +0800
Subject: [PATCH] 1
---
docker-compose/mysql/initdb/se_cloud_20240629.sql | 27 ++++++++++++++++-----------
1 files changed, 16 insertions(+), 11 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20240629.sql b/docker-compose/mysql/initdb/se_cloud_20240629.sql
index 797fb83..5088d74 100644
--- a/docker-compose/mysql/initdb/se_cloud_20240629.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20240629.sql
@@ -68,14 +68,18 @@
update_by varchar(64) default '' comment '鏇存柊鑰�',
update_time datetime comment '鏇存柊鏃堕棿',
remark varchar(500) default null comment '澶囨敞',
+ unique (user_name),
primary key (user_id)
) engine=innodb auto_increment=3 comment = '鐢ㄦ埛淇℃伅琛�';
+create unique index index_sys_user_name on sys_user (user_name);
+
-- ----------------------------
-- 鍒濆鍖�-鐢ㄦ埛淇℃伅琛ㄦ暟鎹�
-- ----------------------------
insert into sys_user values(1, 103, 'admin', '', '00', '1', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�');
insert into sys_user values(2, 105, 'ry', '', '00', '1', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�');
+-- insert into sys_user (user_name, nick_name) values ('admin', 'admin');
-- select * from sys_user;
-- ----------------------------
@@ -185,7 +189,7 @@
-- insert into sys_menu values('107', '閫氱煡鍏憡', '1', '8', 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, '閫氱煡鍏憡鑿滃崟');
insert into sys_menu values('108', '鏃ュ織绠＄悊', '1', '9', 'log', '', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, '鏃ュ織绠＄悊鑿滃崟');
-- insert into sys_menu values('109', '鍦ㄧ嚎鐢ㄦ埛', '2', '1', 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '鍦ㄧ嚎鐢ㄦ埛鑿滃崟');
--- insert into sys_menu values('110', '瀹氭椂浠诲姟', '2', '2', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, '瀹氭椂浠诲姟鑿滃崟');
+insert into sys_menu values('110', '瀹氭椂浠诲姟', '1', '11', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, '瀹氭椂浠诲姟鑿滃崟');
-- insert into sys_menu values('111', 'Sentinel鎺у埗鍙�', '2', '3', 'http://localhost:8718', '', '', '', 0, 0, 'C', '0', '0', 'monitor:sentinel:list', 'sentinel', 'admin', sysdate(), '', null, '娴侀噺鎺у埗鑿滃崟');
-- insert into sys_menu values('112', 'Nacos鎺у埗鍙�', '2', '4', 'http://localhost:8848/nacos', '', '', '', 0, 0, 'C', '0', '0', 'monitor:nacos:list', 'nacos', 'admin', sysdate(), '', null, '鏈嶅姟娌荤悊鑿滃崟');
-- insert into sys_menu values('113', 'Admin鎺у埗鍙�', '2', '5', 'http://localhost:9100/login', '', '', '', 0, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, '鏈嶅姟鐩戞帶鑿滃崟');
@@ -270,20 +274,20 @@
-- insert into sys_menu values('1059', '棰勮浠ｇ爜', '115', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
-- insert into sys_menu values('1060', '鐢熸垚浠ｇ爜', '115', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
-- 棣栭〉
-insert into sys_menu values('1061', 'xx瀹為獙鏉′欢寤鸿', '0', '1', '#', '', '', '', 1, 0, 'M', '0', '0', 'system:index:sy', '#', 'admin', sysdate(), '', null, '棣栭〉', 'index');
-insert into sys_menu values('1062', 'xx姒傚康寮�鍙戜笌楠岃瘉骞冲彴', '1061', '1', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:glkf', '#', 'admin', sysdate(), '', null, '姒傚康寮�鍙戜笌楠岃瘉骞冲彴', 'index');
-insert into sys_menu values('1063', 'xx浣撶郴璁捐涓庤瘎浼板钩鍙�', '1061', '2', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:txsj', '#', 'admin', sysdate(), '', null, '浣撶郴璁捐涓庤瘎浼板钩鍙�', 'index');
-insert into sys_menu values('1064', 'xx鏂规鎺ㄦ紨涓庡垎鏋愬钩鍙�', '1061', '3', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:faty', '#', 'admin', sysdate(), '', null, '鏂规鎺ㄦ紨涓庡垎鏋愬钩鍙�', 'index');
-insert into sys_menu values('1065', 'xx鍒涘缓涓巟x杩愮敤鐮旂┒骞冲彴', '1061', '4', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:cxyyy','#', 'admin', sysdate(), '', null, '鍒涘缓涓庤繍鐢ㄧ爺绌跺钩鍙�', 'index');
-insert into sys_menu values('1066', 'xx缁煎悎闆嗘垚鐮旇鍘�', '1061', '5', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:zhjc', '#', 'admin', sysdate(), '', null, '缁煎悎闆嗘垚鐮旇鍘�', 'index');
+insert into sys_menu values('1061', '浣滄垬瀹為獙鏉′欢寤鸿', '0', '1', '#', '', '', '', 1, 0, 'M', '0', '0', 'system:index:sy', '#', 'admin', sysdate(), '', null, '棣栭〉', 'index');
+insert into sys_menu values('1062', '浣滄垬姒傚康寮�鍙戜笌楠岃瘉骞冲彴', '1061', '1', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:glkf', '#', 'admin', sysdate(), '', null, '姒傚康寮�鍙戜笌楠岃瘉骞冲彴', 'index');
+insert into sys_menu values('1063', '浣滄垬浣撶郴璁捐涓庤瘎浼板钩鍙�', '1061', '2', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:txsj', '#', 'admin', sysdate(), '', null, '浣撶郴璁捐涓庤瘎浼板钩鍙�', 'index');
+insert into sys_menu values('1064', '浣滄垬鏂规鎺ㄦ紨涓庡垎鏋愬钩鍙�', '1061', '3', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:faty', '#', 'admin', sysdate(), '', null, '鏂规鎺ㄦ紨涓庡垎鏋愬钩鍙�', 'index');
+insert into sys_menu values('1065', '鎴樻硶鍒涙柊涓庝綔鎴樿繍鐢ㄧ爺绌跺钩鍙�', '1061', '4', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:cxyyy','#', 'admin', sysdate(), '', null, '鍒涘缓涓庤繍鐢ㄧ爺绌跺钩鍙�', 'index');
+insert into sys_menu values('1066', '浣滄垬缁煎悎闆嗘垚鐮旇鍘�', '1061', '5', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:zhjc', '#', 'admin', sysdate(), '', null, '缁煎悎闆嗘垚鐮旇鍘�', 'index');
insert into sys_menu values('1067', '鎬佸娍鏄剧ず鍒嗙郴缁�', '1061', '6', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:tsxs', '#', 'admin', sysdate(), '', null, '鎬佸娍鏄剧ず鍒嗙郴缁�', 'index');
insert into sys_menu values('1068', '鏁版嵁绠＄悊鍒嗙郴缁�', '1061', '7', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:sjgl', '#', 'admin', sysdate(), '', null, '鏁版嵁绠＄悊鍒嗙郴缁�', 'index');
insert into sys_menu values('1069', '瑁呭搴�', '1061', '8', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:zbk', '#', 'admin', sysdate(), '', null, '瑁呭搴�', 'index');
insert into sys_menu values('1070', '浠跨湡璧勬簮绠＄悊鍒嗙郴缁�', '1061', '9', '#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:fzzy', '#', 'admin', sysdate(), '', null, '浠跨湡璧勬簮绠＄悊鍒嗙郴缁�', 'index');
-insert into sys_menu values('1071', '宸ュ叿绠�', '1061', '10','#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:gjx', '#', 'admin', sysdate(), '', null, '宸ュ叿绠�', 'index');
-insert into sys_menu values('1072', '鐢ㄦ埛鍙婃潈闄愮鐞�', '1061', '11','#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:yhgl', '#', 'admin', sysdate(), '', null, '鐢ㄦ埛鍙婃潈闄愮鐞�', 'index');
-insert into sys_menu values('1073', '鐩戞帶鍙婅繍缁寸鐞�', '1061', '12','#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:ywjk', '#', 'admin', sysdate(), '', null, '鐩戞帶鍙婅繍缁寸鐞�', 'index');
-insert into sys_menu values('1074', 'ISIM Cloud', '1061', '13','#', '', '', '', 0, 0, 'C', '0', '0', 'system:index:isim', '#', 'admin', sysdate(), '', null, 'ISIM Cloud', 'index');
+insert into sys_menu values('1071', '宸ュ叿绠�', '1061', '10','#', '', '', '', 0, 0, 'F', '0', '0', 'system:index:gjx', '#', 'admin', sysdate(), '', null, '宸ュ叿绠�', 'index');
+insert into sys_menu values('1072', '鐢ㄦ埛鍙婃潈闄愮鐞�', '1061', '11','#', '', '', '', 0, 0, 'F', '0', '0', 'system:index:yhgl', '#', 'admin', sysdate(), '', null, '鐢ㄦ埛鍙婃潈闄愮鐞�', 'index');
+insert into sys_menu values('1073', '鐩戞帶鍙婅繍缁寸鐞�', '1061', '12','#', '', '', '', 0, 0, 'F', '0', '0', 'system:index:ywjk', '#', 'admin', sysdate(), '', null, '鐩戞帶鍙婅繍缁寸鐞�', 'index');
+insert into sys_menu values('1074', 'ISIM Cloud', '1061', '13','#', '', '', '', 0, 0, 'F', '0', '0', 'system:index:isim', '#', 'admin', sysdate(), '', null, 'ISIM Cloud', 'index');
alter table sys_menu add column mark varchar(20) comment '鑿滃崟鏍囪瘑';
update sys_menu set mark = 'sys' where menu_id < 1070;
@@ -633,6 +637,7 @@
insert into sys_job values(1, '绯荤粺榛樿锛堟棤鍙傦級', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
insert into sys_job values(2, '绯荤粺榛樿锛堟湁鍙傦級', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
insert into sys_job values(3, '绯荤粺榛樿锛堝鍙傦級', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
+-- select * from sys_job order by job_id;
-- ----------------------------
--
Gitblit v1.9.3