v2.1.4
sql 脚本 - DML
sql
-- 菜单
DELETE FROM system_menu WHERE id = 158;
INSERT INTO system_menu VALUES (158, 152, '文件操作日志', NULL, 2, 40, 1, 1, 1, 0, 'IconFile', NULL, 'sftpLog', '2024-03-05 15:30:13', '2024-08-04 20:23:19', '1', '1', 0);
-- 字典项
DELETE FROM dict_key WHERE id = 43;
INSERT INTO dict_key VALUES (43, 'messageType', 'STRING', '[{\"name\": \"tagLabel\", \"type\": \"STRING\"}, {\"name\": \"tagVisible\", \"type\": \"BOOLEAN\"}, {\"name\": \"tagColor\", \"type\": \"COLOR\"}, {\"name\": \"redirectComponent\", \"type\": \"STRING\"}]', '消息类型', '2024-05-13 12:07:56', '2024-08-19 12:28:30', '1', '1', 0);
-- 字典值
DELETE FROM dict_value WHERE id IN (295, 296, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 401, 402, 403, 404, 405);
INSERT INTO dict_value VALUES (295, 43, 'messageType', 'EXEC_FAILED', '执行失败', '{\"tagColor\": \"red\", \"tagLabel\": \"部分失败\", \"tagVisible\": true, \"redirectComponent\": \"execCommand\"}', 10, '2024-05-13 12:07:56', '2024-08-19 12:28:48', '1', '1', 0);
INSERT INTO dict_value VALUES (296, 43, 'messageType', 'UPLOAD_FAILED', '上传失败', '{\"tagColor\": \"red\", \"tagLabel\": \"部分失败\", \"tagVisible\": true, \"redirectComponent\": \"batchUpload\"}', 20, '2024-05-13 12:07:56', '2024-08-19 12:28:51', '1', '1', 0);
INSERT INTO dict_value VALUES (353, 53, 'terminalTheme', '{\"background\":\"#1E1F29\",\"foreground\":\"#F8F8F2\",\"cursor\":\"#BBBBBB\",\"selectionBackground\":\"#44475A\",\"black\":\"#000000\",\"red\":\"#FF5555\",\"green\":\"#50FA7B\",\"yellow\":\"#F1FA8C\",\"blue\":\"#BD93F9\",\"cyan\":\"#8BE9FD\",\"white\":\"#BBBBBB\",\"brightBlack\":\"#555555\",\"brightRed\":\"#FF5555\",\"brightGreen\":\"#50FA7B\",\"brightYellow\":\"#F1FA8C\",\"brightBlue\":\"#BD93F9\",\"brightCyan\":\"#8BE9FD\",\"brightWhite\":\"#FFFFFF\"}', 'Dracula', '{\"dark\": true}', 10, '2024-07-04 19:15:42', '2024-08-19 18:49:12', '1', '1', 0);
INSERT INTO dict_value VALUES (354, 53, 'terminalTheme', '{\"background\":\"#FFFFFF\",\"foreground\":\"#000000\",\"cursor\":\"#000000\",\"selectionBackground\":\"#B5D5FF\",\"black\":\"#000000\",\"red\":\"#CC0000\",\"green\":\"#4E9A06\",\"yellow\":\"#C4A000\",\"blue\":\"#3465A4\",\"cyan\":\"#06989A\",\"white\":\"#D3D7CF\",\"brightBlack\":\"#555753\",\"brightRed\":\"#EF2929\",\"brightGreen\":\"#8AE234\",\"brightYellow\":\"#FCE94F\",\"brightBlue\":\"#729FCF\",\"brightCyan\":\"#34E2E2\",\"brightWhite\":\"#EEEEEC\"}', 'Builtin Tango Light', '{\"dark\": false}', 20, '2024-07-04 19:21:38', '2024-08-19 18:49:31', '1', '1', 0);
INSERT INTO dict_value VALUES (355, 53, 'terminalTheme', '{\"background\":\"#161719\",\"foreground\":\"#C5C8C6\",\"cursor\":\"#D0D0D0\",\"selectionBackground\":\"#444444\",\"black\":\"#000000\",\"red\":\"#FD5FF1\",\"green\":\"#87C38A\",\"yellow\":\"#FFD7B1\",\"blue\":\"#85BEFD\",\"cyan\":\"#85BEFD\",\"white\":\"#E0E0E0\",\"brightBlack\":\"#000000\",\"brightRed\":\"#FD5FF1\",\"brightGreen\":\"#94FA36\",\"brightYellow\":\"#F5FFA8\",\"brightBlue\":\"#96CBFE\",\"brightCyan\":\"#85BEFD\",\"brightWhite\":\"#E0E0E0\"}', 'Atom', '{\"dark\": true}', 30, '2024-07-04 19:21:49', '2024-08-19 18:49:49', '1', '1', 0);
INSERT INTO dict_value VALUES (356, 53, 'terminalTheme', '{\"background\":\"#F9F9F9\",\"foreground\":\"#2A2C33\",\"cursor\":\"#BBBBBB\",\"selectionBackground\":\"#EDEDED\",\"black\":\"#000000\",\"red\":\"#DE3E35\",\"green\":\"#3F953A\",\"yellow\":\"#D2B67C\",\"blue\":\"#2F5AF3\",\"cyan\":\"#3F953A\",\"white\":\"#BBBBBB\",\"brightBlack\":\"#000000\",\"brightRed\":\"#DE3E35\",\"brightGreen\":\"#3F953A\",\"brightYellow\":\"#D2B67C\",\"brightBlue\":\"#2F5AF3\",\"brightCyan\":\"#3F953A\",\"brightWhite\":\"#FFFFFF\"}', 'AtomOneLight', '{\"dark\": false}', 40, '2024-07-04 19:22:02', '2024-08-19 18:50:00', '1', '1', 0);
INSERT INTO dict_value VALUES (357, 53, 'terminalTheme', '{\"background\":\"#282C34\",\"foreground\":\"#DCDFE4\",\"cursor\":\"#A3B3CC\",\"selectionBackground\":\"#474E5D\",\"black\":\"#282C34\",\"red\":\"#E06C75\",\"green\":\"#98C379\",\"yellow\":\"#E5C07B\",\"blue\":\"#61AFEF\",\"cyan\":\"#56B6C2\",\"white\":\"#DCDFE4\",\"brightBlack\":\"#282C34\",\"brightRed\":\"#E06C75\",\"brightGreen\":\"#98C379\",\"brightYellow\":\"#E5C07B\",\"brightBlue\":\"#61AFEF\",\"brightCyan\":\"#56B6C2\",\"brightWhite\":\"#DCDFE4\"}', 'OneHalfDark', '{\"dark\": true}', 50, '2024-07-04 19:22:16', '2024-08-19 18:50:15', '1', '1', 0);
INSERT INTO dict_value VALUES (358, 53, 'terminalTheme', '{\"background\":\"#FAFAFA\",\"foreground\":\"#383A42\",\"cursor\":\"#BFCEFF\",\"selectionBackground\":\"#BFCEFF\",\"black\":\"#383A42\",\"red\":\"#E45649\",\"green\":\"#50A14F\",\"yellow\":\"#C18401\",\"blue\":\"#0184BC\",\"cyan\":\"#0997B3\",\"white\":\"#FAFAFA\",\"brightBlack\":\"#4F525E\",\"brightRed\":\"#E06C75\",\"brightGreen\":\"#98C379\",\"brightYellow\":\"#E5C07B\",\"brightBlue\":\"#61AFEF\",\"brightCyan\":\"#56B6C2\",\"brightWhite\":\"#FFFFFF\"}', 'OneHalfLight', '{\"dark\": false}', 60, '2024-07-04 19:22:26', '2024-08-19 18:50:27', '1', '1', 0);
INSERT INTO dict_value VALUES (359, 53, 'terminalTheme', '{\"background\":\"#1E1E1E\",\"foreground\":\"#FFFFFF\",\"cursor\":\"#98989D\",\"selectionBackground\":\"#3F638B\",\"black\":\"#1A1A1A\",\"red\":\"#CC372E\",\"green\":\"#26A439\",\"yellow\":\"#CDAC08\",\"blue\":\"#0869CB\",\"cyan\":\"#479EC2\",\"white\":\"#98989D\",\"brightBlack\":\"#464646\",\"brightRed\":\"#FF453A\",\"brightGreen\":\"#32D74B\",\"brightYellow\":\"#FFD60A\",\"brightBlue\":\"#0A84FF\",\"brightCyan\":\"#76D6FF\",\"brightWhite\":\"#FFFFFF\"}', 'Apple System Colors', '{\"dark\": true}', 70, '2024-07-04 19:22:45', '2024-08-19 18:50:46', '1', '1', 0);
INSERT INTO dict_value VALUES (360, 53, 'terminalTheme', '{\"background\":\"#FFFFFF\",\"foreground\":\"#4D4D4C\",\"cursor\":\"#4D4D4C\",\"selectionBackground\":\"#D6D6D6\",\"black\":\"#000000\",\"red\":\"#C82829\",\"green\":\"#718C00\",\"yellow\":\"#EAB700\",\"blue\":\"#4271AE\",\"cyan\":\"#3E999F\",\"white\":\"#FFFFFF\",\"brightBlack\":\"#000000\",\"brightRed\":\"#C82829\",\"brightGreen\":\"#718C00\",\"brightYellow\":\"#EAB700\",\"brightBlue\":\"#4271AE\",\"brightCyan\":\"#3E999F\",\"brightWhite\":\"#FFFFFF\"}', 'Tomorrow', '{\"dark\": false}', 80, '2024-07-04 19:22:57', '2024-08-19 18:51:03', '1', '1', 0);
INSERT INTO dict_value VALUES (361, 53, 'terminalTheme', '{\"background\":\"#1E1E2E\",\"foreground\":\"#CDD6F4\",\"cursor\":\"#F5E0DC\",\"selectionBackground\":\"#585B70\",\"black\":\"#45475A\",\"red\":\"#F38BA8\",\"green\":\"#A6E3A1\",\"yellow\":\"#F9E2AF\",\"blue\":\"#89B4FA\",\"cyan\":\"#94E2D5\",\"white\":\"#BAC2DE\",\"brightBlack\":\"#585B70\",\"brightRed\":\"#F38BA8\",\"brightGreen\":\"#A6E3A1\",\"brightYellow\":\"#F9E2AF\",\"brightBlue\":\"#89B4FA\",\"brightCyan\":\"#94E2D5\",\"brightWhite\":\"#A6ADC8\"}', 'catppuccin-mocha', '{\"dark\": true}', 90, '2024-07-04 19:23:13', '2024-08-19 18:51:23', '1', '1', 0);
INSERT INTO dict_value VALUES (362, 53, 'terminalTheme', '{\"background\":\"#EFF1F5\",\"foreground\":\"#4C4F69\",\"cursor\":\"#DC8A78\",\"selectionBackground\":\"#ACB0BE\",\"black\":\"#5C5F77\",\"red\":\"#D20F39\",\"green\":\"#40A02B\",\"yellow\":\"#DF8E1D\",\"blue\":\"#1E66F5\",\"cyan\":\"#179299\",\"white\":\"#ACB0BE\",\"brightBlack\":\"#6C6F85\",\"brightRed\":\"#D20F39\",\"brightGreen\":\"#40A02B\",\"brightYellow\":\"#DF8E1D\",\"brightBlue\":\"#1E66F5\",\"brightCyan\":\"#179299\",\"brightWhite\":\"#BCC0CC\"}', 'catppuccin-latte', '{\"dark\": false}', 100, '2024-07-04 19:23:32', '2024-08-19 18:51:43', '1', '1', 0);
INSERT INTO dict_value VALUES (363, 53, 'terminalTheme', '{\"background\":\"#24273A\",\"foreground\":\"#CAD3F5\",\"cursor\":\"#F4DBD6\",\"selectionBackground\":\"#5B6078\",\"black\":\"#494D64\",\"red\":\"#ED8796\",\"green\":\"#A6DA95\",\"yellow\":\"#EED49F\",\"blue\":\"#8AADF4\",\"cyan\":\"#8BD5CA\",\"white\":\"#B8C0E0\",\"brightBlack\":\"#5B6078\",\"brightRed\":\"#ED8796\",\"brightGreen\":\"#A6DA95\",\"brightYellow\":\"#EED49F\",\"brightBlue\":\"#8AADF4\",\"brightCyan\":\"#8BD5CA\",\"brightWhite\":\"#A5ADCB\"}', 'catppuccin-macchiato', '{\"dark\": true}', 110, '2024-07-04 19:23:41', '2024-08-19 18:51:55', '1', '1', 0);
INSERT INTO dict_value VALUES (364, 53, 'terminalTheme', '{\"background\":\"#F9F9F9\",\"foreground\":\"#373A41\",\"cursor\":\"#F32759\",\"selectionBackground\":\"#DAF0FF\",\"black\":\"#373A41\",\"red\":\"#D52753\",\"green\":\"#23974A\",\"yellow\":\"#DF631C\",\"blue\":\"#275FE4\",\"cyan\":\"#27618D\",\"white\":\"#BABBC2\",\"brightBlack\":\"#676A77\",\"brightRed\":\"#FF6480\",\"brightGreen\":\"#3CBC66\",\"brightYellow\":\"#C5A332\",\"brightBlue\":\"#0099E1\",\"brightCyan\":\"#6D93BB\",\"brightWhite\":\"#D3D3D3\"}', 'BlulocoLight', '{\"dark\": false}', 120, '2024-07-04 19:24:06', '2024-08-19 18:52:12', '1', '1', 0);
INSERT INTO dict_value VALUES (365, 53, 'terminalTheme', '{\"background\":\"#303446\",\"foreground\":\"#C6D0F5\",\"cursor\":\"#F2D5CF\",\"selectionBackground\":\"#626880\",\"black\":\"#51576D\",\"red\":\"#E78284\",\"green\":\"#A6D189\",\"yellow\":\"#E5C890\",\"blue\":\"#8CAAEE\",\"cyan\":\"#81C8BE\",\"white\":\"#B5BFE2\",\"brightBlack\":\"#626880\",\"brightRed\":\"#E78284\",\"brightGreen\":\"#A6D189\",\"brightYellow\":\"#E5C890\",\"brightBlue\":\"#8CAAEE\",\"brightCyan\":\"#81C8BE\",\"brightWhite\":\"#A5ADCE\"}', 'catppuccin-frappe', '{\"dark\": true}', 130, '2024-07-04 19:24:17', '2024-08-19 18:52:24', '1', '1', 0);
INSERT INTO dict_value VALUES (366, 53, 'terminalTheme', '{\"background\":\"#1D262A\",\"foreground\":\"#E7EBED\",\"cursor\":\"#EAEAEA\",\"selectionBackground\":\"#4E6A78\",\"black\":\"#435B67\",\"red\":\"#FC3841\",\"green\":\"#5CF19E\",\"yellow\":\"#FED032\",\"blue\":\"#37B6FF\",\"cyan\":\"#59FFD1\",\"white\":\"#FFFFFF\",\"brightBlack\":\"#A1B0B8\",\"brightRed\":\"#FC746D\",\"brightGreen\":\"#ADF7BE\",\"brightYellow\":\"#FEE16C\",\"brightBlue\":\"#70CFFF\",\"brightCyan\":\"#9AFFE6\",\"brightWhite\":\"#FFFFFF\"}', 'MaterialDesignColors', '{\"dark\": true}', 140, '2024-07-04 19:24:27', '2024-08-19 18:52:56', '1', '1', 0);
INSERT INTO dict_value VALUES (401, 43, 'messageType', 'LOGIN_FAILED', '登录失败', '{\"tagColor\": \"red\", \"tagLabel\": \"登录失败\", \"tagVisible\": true, \"redirectComponent\": \"0\"}', 50, '2024-08-19 18:34:27', '2024-08-19 18:34:27', '1', '1', 0);
INSERT INTO dict_value VALUES (402, 53, 'terminalTheme', '{\"background\":\"#101216\",\"foreground\":\"#8B949E\",\"cursor\":\"#C9D1D9\",\"selectionBackground\":\"#3B5070\",\"black\":\"#000000\",\"red\":\"#F78166\",\"green\":\"#56D364\",\"yellow\":\"#E3B341\",\"blue\":\"#6CA4F8\",\"cyan\":\"#2B7489\",\"white\":\"#FFFFFF\",\"brightBlack\":\"#4D4D4D\",\"brightRed\":\"#F78166\",\"brightGreen\":\"#56D364\",\"brightYellow\":\"#E3B341\",\"brightBlue\":\"#6CA4F8\",\"brightCyan\":\"#2B7489\",\"brightWhite\":\"#FFFFFF\"}', 'GitHub Dark', '{\"dark\": true}', 150, '2024-08-19 18:53:14', '2024-08-19 18:53:20', '1', '1', 0);
INSERT INTO dict_value VALUES (403, 53, 'terminalTheme', '{\"background\":\"#F4F4F4\",\"foreground\":\"#3E3E3E\",\"cursor\":\"#3F3F3F\",\"selectionBackground\":\"#A9C1E2\",\"black\":\"#3E3E3E\",\"red\":\"#970B16\",\"green\":\"#07962A\",\"yellow\":\"#F8EEC7\",\"blue\":\"#003E8A\",\"cyan\":\"#89D1EC\",\"white\":\"#FFFFFF\",\"brightBlack\":\"#666666\",\"brightRed\":\"#DE0000\",\"brightGreen\":\"#87D5A2\",\"brightYellow\":\"#F1D007\",\"brightBlue\":\"#2E6CBA\",\"brightCyan\":\"#1CFAFE\",\"brightWhite\":\"#FFFFFF\"}', 'Github', '{\"dark\": false}', 160, '2024-08-19 18:53:39', '2024-08-19 18:53:39', '1', '1', 0);
INSERT INTO dict_value VALUES (404, 53, 'terminalTheme', '{\"background\":\"#1F1F1F\",\"foreground\":\"#B9BCBA\",\"cursor\":\"#F83E19\",\"selectionBackground\":\"#2A2D32\",\"black\":\"#3A3D43\",\"red\":\"#BE3F48\",\"green\":\"#879A3B\",\"yellow\":\"#C5A635\",\"blue\":\"#4F76A1\",\"cyan\":\"#578FA4\",\"white\":\"#B9BCBA\",\"brightBlack\":\"#888987\",\"brightRed\":\"#FB001F\",\"brightGreen\":\"#0F722F\",\"brightYellow\":\"#C47033\",\"brightBlue\":\"#186DE3\",\"brightCyan\":\"#2E706D\",\"brightWhite\":\"#FDFFB9\"}', 'DimmedMonokai', '{\"dark\": true}', 170, '2024-08-19 18:53:52', '2024-08-19 18:53:52', '1', '1', 0);
INSERT INTO dict_value VALUES (405, 53, 'terminalTheme', '{\"background\":\"#1F1D27\",\"foreground\":\"#B7A1FF\",\"cursor\":\"#FF9839\",\"selectionBackground\":\"#353147\",\"black\":\"#1F1D27\",\"red\":\"#D9393E\",\"green\":\"#2DCD73\",\"yellow\":\"#D9B76E\",\"blue\":\"#FFC284\",\"cyan\":\"#2488FF\",\"white\":\"#B7A1FF\",\"brightBlack\":\"#353147\",\"brightRed\":\"#D9393E\",\"brightGreen\":\"#2DCD73\",\"brightYellow\":\"#D9B76E\",\"brightBlue\":\"#FFC284\",\"brightCyan\":\"#2488FF\",\"brightWhite\":\"#EAE5FF\"}', 'Duotone Dark', '{\"dark\": true}', 180, '2024-08-19 18:54:09', '2024-08-19 18:54:09', '1', '1', 0);