Dromara Orion Visor

Appearance

v2.5.5 ​

sql 脚本 - DML ​

sql
-- 字典项
DELETE FROM `dict_key` WHERE id = 97;
INSERT INTO `dict_key` VALUES (97, 'tagType', 'STRING', '[]', '标签类型', '2025-10-08 22:50:11', '2025-10-08 22:50:11', 'admin', 'admin', 0);

-- 字典值
DELETE FROM `dict_value` WHERE id IN (638, 639, 640, 641, 642, 643, 673);
INSERT INTO `dict_value` VALUES (638, 2, 'operatorLogType', 'system-user:unlock', '解锁用户', '{}', 80, '2025-10-08 22:36:01', '2025-10-08 22:36:29', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (639, 1, 'operatorLogModule', 'infra:tag', '数据标签', '{}', 2220, '2025-10-08 22:38:47', '2025-10-08 22:39:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (640, 2, 'operatorLogType', 'tag:create', '创建数据标签', '{}', 10, '2025-10-08 22:39:17', '2025-10-08 22:39:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (641, 2, 'operatorLogType', 'tag:update', '修改数据标签', '{}', 20, '2025-10-08 22:39:33', '2025-10-08 22:39:33', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (642, 2, 'operatorLogType', 'tag:delete', '删除数据标签', '{}', 30, '2025-10-08 22:39:43', '2025-10-08 22:39:43', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (643, 97, 'tagType', 'HOST', '主机标签', '{}', 10, '2025-10-08 22:50:28', '2025-10-08 22:50:28', 'admin', 'admin', 0);

-- 菜单表
DELETE FROM `system_menu` WHERE id IN (10, 48, 94, 124, 125, 203, 308, 321, 322, 323, 324, 325, 326, 327, 328, 329);
INSERT INTO `system_menu` VALUES (10, 5, '角色管理', NULL, 2, 10, 1, 1, 1, 0, 'IconUserGroup', '', 'userRole', '2023-07-28 10:55:52', '2024-03-07 19:10:13', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (48, 5, '用户管理', NULL, 2, 20, 1, 1, 1, 0, 'IconUserAdd', NULL, 'userList', '2023-08-16 10:19:24', '2025-10-08 22:28:46', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (94, 5, '个人中心', NULL, 2, 21, 0, 1, 0, 0, 'IconUser', NULL, 'userInfo', '2023-10-08 18:53:01', '2025-10-08 22:28:28', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (124, 325, '查询在线用户', 'infra:system-user:query-session', 3, 50, 1, 1, 1, 0, NULL, NULL, NULL, '2023-11-02 11:24:14', '2025-10-08 22:33:48', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (125, 325, '下线用户会话', 'infra:system-user:management:offline-session', 3, 60, 1, 1, 1, 0, NULL, NULL, NULL, '2023-11-02 11:24:37', '2025-10-08 22:34:06', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (203, 12, '系统设置', NULL, 2, 100, 1, 1, 1, 0, 'IconSettings', NULL, 'systemSetting', '2024-06-17 20:46:15', '2025-10-08 22:21:25', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (308, 282, '主机告警事件', NULL, 2, 70, 1, 1, 1, 0, 'IconNotification', NULL, 'hostAlarmEvent', '2025-09-17 16:06:34', '2025-10-19 23:55:25', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (321, 12, '标签列表', NULL, 2, 50, 1, 1, 1, 0, 'IconTags', NULL, 'systemTags', '2025-10-08 22:25:41', '2025-10-08 22:30:44', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (322, 321, '修改标签', 'infra:tag:update', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:27:11', '2025-10-08 22:27:42', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (323, 321, '删除标签', 'infra:tag:delete', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:27:38', '2025-10-08 22:27:38', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (324, 321, '创建标签', 'infra:tag:create', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:28:03', '2025-10-08 22:28:03', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (325, 5, '在线用户', NULL, 2, 40, 1, 1, 1, 0, 'IconIdcard', NULL, 'userSession', '2025-10-08 22:30:03', '2025-10-08 23:23:03', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (326, 5, '锁定用户', NULL, 2, 50, 1, 1, 1, 0, 'IconLock', NULL, 'lockedUser', '2025-10-08 22:31:23', '2025-10-08 22:31:23', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (327, 326, '查询锁定用户', 'infra:system-user:query-lock', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:32:28', '2025-10-08 22:32:28', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (328, 326, '解锁用户', 'infra:system-user:management:unlock', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:32:44', '2025-10-08 22:32:44', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (329, 321, '查询标签', 'infra:tag:query', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2025-10-08 22:38:06', '2025-10-08 22:38:06', 'admin', 'admin', 0);

最后更新: