SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for lyadmin_menu
-- ----------------------------
DROP TABLE IF EXISTS `lyadmin_menu`;
CREATE TABLE `lyadmin_menu` (
`id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Id',
`description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
`modifier` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
`dept_belong_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据归属部门',
`update_datetime` datetime(6) NULL DEFAULT NULL COMMENT '修改时间',
`create_datetime` datetime(6) NULL DEFAULT NULL COMMENT '创建时间',
`icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
`sort` int NULL DEFAULT NULL COMMENT '显示排序',
`is_link` smallint NOT NULL COMMENT '是否外链',
`web_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路由地址',
`component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件地址',
`component_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件名称',
`status` smallint NOT NULL COMMENT '菜单状态',
`isautopm` smallint NOT NULL COMMENT '自动创建按钮权限',
`cache` smallint NOT NULL COMMENT '是否页面缓存',
`visible` smallint NOT NULL COMMENT '侧边栏中是否显示',
`creator_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`parent_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级菜单',
PRIMARY KEY (`id`) USING BTREE,
INDEX `lyadmin_menu_creator_id_39b95522`(`creator_id` ASC) USING BTREE,
INDEX `lyadmin_menu_parent_id_4a6f3129`(`parent_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of lyadmin_menu
-- ----------------------------
INSERT INTO `lyadmin_menu` VALUES ('09a42810d4dd4b2eb939f8eb0b01d9d1', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2022-07-04 21:53:54.572593', '2022-07-04 20:52:44.855447', '', '计划任务', 20, 0, 'crontab', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', '77edf447326b4e0dbc6f9719c1de8a12');
INSERT INTO `lyadmin_menu` VALUES ('151035da-77a3-4a62-b474-fce6824571fb', NULL, NULL, NULL, '2022-06-27 13:56:06.189196', '2022-06-27 13:56:06.189196', '', '按钮管理', 6, 0, 'buttonManage', 'system/button', 'buttonManage', 1, 0, 0, 0, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('15c9ebc5-d12f-470a-a560-938a7dc57570', NULL, NULL, NULL, '2022-06-27 13:56:06.185699', '2022-06-27 13:56:06.185699', '', '角色管理', 3, 0, 'roleManage', 'system/role', 'role', 1, 0, 0, 1, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('25735adb-d051-4b7b-bbb7-1154526f3e4c', NULL, 'superadmin', NULL, '2022-07-30 21:34:32.844919', '2022-06-27 13:56:06.192188', 'user', '个人中心', 866, 0, 'personalCenter', NULL, NULL, 1, 0, 0, 1, NULL, NULL);
INSERT INTO `lyadmin_menu` VALUES ('2a7c0142f7514dacb7999383e4e67aca', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-14 19:50:04.517142', '2022-07-28 23:36:59.277661', 'WalletFilled', '财务管理', 299, 0, '', NULL, NULL, 0, 0, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL);
INSERT INTO `lyadmin_menu` VALUES ('2e3438c8-3ddc-43ff-b8d8-cca328e4856e', NULL, 'superadmin', NULL, '2022-07-03 15:19:35.715872', '2022-06-27 13:56:06.165122', 'avatar', '管理员管理', 3, 0, 'adminManage', NULL, NULL, 1, 0, 0, 1, NULL, NULL);
INSERT INTO `lyadmin_menu` VALUES ('3171db16eda048ae92b16536fc1241b6', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-18 05:49:59.580722', '2022-06-27 13:56:06.173100', '', '平台公告', 5, 0, 'messagNotice', NULL, NULL, 0, 0, 0, 1, NULL, 'd4e2fe169a8b40f3846421ac04e4fccb');
INSERT INTO `lyadmin_menu` VALUES ('3c13161f70f1469a913d539e7616c577', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-18 05:50:04.297499', '2022-07-28 23:40:08.355309', '', '意见反馈', 8, 0, 'userFeekback', NULL, NULL, 0, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd4e2fe169a8b40f3846421ac04e4fccb');
INSERT INTO `lyadmin_menu` VALUES ('4236eb70-1558-43a0-9cf2-037230c547f9', NULL, NULL, NULL, '2022-06-27 13:56:06.177090', '2022-06-27 13:56:06.177090', '', '部门管理', 1, 0, 'departmentManage', 'system/dept', 'dept', 1, 0, 0, 1, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('49160b589f004e44b3920c82583c2581', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd2c03bd9-dad0-4262-88ca-c3681d224fc3', '2025-02-19 16:55:53.273043', '2022-11-13 15:56:43.159810', '', '系统配置', 15, 0, 'systemConfig', NULL, NULL, 1, 1, 0, 1, 'd1431450-5068-4461-b57e-7862c005a547', 'd4e2fe169a8b40f3846421ac04e4fccb');
INSERT INTO `lyadmin_menu` VALUES ('4ba07859-8b73-4524-a1a6-bbff36d98337', NULL, NULL, NULL, '2022-06-27 13:56:06.179629', '2022-06-27 13:56:06.179629', '', '操作日志', 1, 0, 'journalManage', 'system/log/operationLog', 'operationLog', 1, 0, 0, 1, NULL, 'c236fb6b-ddaa-4deb-b79b-16e42d9f347f');
INSERT INTO `lyadmin_menu` VALUES ('54f769b0-3dff-416c-8102-e55ec44827cc', NULL, 'superadmin', NULL, '2022-07-29 23:08:25.510853', '2022-06-27 13:56:06.190193', 'tools', '系统管理', 990, 0, '', NULL, NULL, 1, 0, 0, 1, NULL, NULL);
INSERT INTO `lyadmin_menu` VALUES ('56c3f341-4f46-4b04-9cfc-c8a14701707e', NULL, NULL, NULL, '2022-06-27 13:56:06.181311', '2022-06-27 13:56:06.181311', '', '菜单管理', 2, 0, 'menuManage', 'system/menu', 'menu', 1, 0, 0, 1, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('576f1219d47845c1a6537df67ad5471a', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd2c03bd9-dad0-4262-88ca-c3681d224fc3', '2025-02-10 10:50:30.038589', '2025-01-23 19:19:19.976756', 'Avatar', '用途管理', 1, 0, 'serversUsage', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'f374d275152b4351914b8e85009c7990');
INSERT INTO `lyadmin_menu` VALUES ('6c745d378be14cc1bae9498e73f9a9b3', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd2c03bd9-dad0-4262-88ca-c3681d224fc3', '2025-02-10 10:50:40.291835', '2025-01-23 19:12:47.473346', 'Box', '机型管理', 1, 0, 'serversModel', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'f374d275152b4351914b8e85009c7990');
INSERT INTO `lyadmin_menu` VALUES ('718daec1b94b456c96d773889648173e', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2022-07-13 21:07:49.624609', '2022-07-13 21:07:49.624609', '', '终端服务', 30, 0, 'terminal', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', '77edf447326b4e0dbc6f9719c1de8a12');
INSERT INTO `lyadmin_menu` VALUES ('77edf447326b4e0dbc6f9719c1de8a12', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2022-07-29 23:09:12.270076', '2022-07-04 21:53:39.904375', 'TrendCharts', '系统监控', 888, 0, '', NULL, NULL, 1, 0, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL);
INSERT INTO `lyadmin_menu` VALUES ('80a340eae92b430abe17635468c2df1d', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-18 05:50:08.520290', '2022-06-27 13:56:06.175095', '', '参数设置', 12, 0, 'platformSettingsother', NULL, NULL, 0, 0, 0, 1, NULL, 'd4e2fe169a8b40f3846421ac04e4fccb');
INSERT INTO `lyadmin_menu` VALUES ('9065cb5445ac42ef93eb9e75e6287792', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-10 10:06:45.938052', '2022-07-03 15:21:19.325170', 'DataLine', '首页', 0, 0, 'analysis', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL);
INSERT INTO `lyadmin_menu` VALUES ('a607e820-36e5-45c0-aabf-85a8e4e2c7ac', NULL, NULL, NULL, '2022-06-27 13:56:06.187402', '2022-06-27 13:56:06.187402', '', '权限管理', 4, 0, 'authorityManage', 'system/rolePermission', 'rolePermission', 1, 0, 0, 1, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('ae5629946df4497cbec10419e8375dd9', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-18 05:49:54.600588', '2022-06-27 13:56:06.171105', '', '轮播图设置', 1, 0, 'carouselSettingsimg', NULL, NULL, 0, 0, 0, 1, NULL, 'd4e2fe169a8b40f3846421ac04e4fccb');
INSERT INTO `lyadmin_menu` VALUES ('bcbeeee5c91a4e2ea2c2a31237e33616', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2022-07-04 21:55:07.612049', '2022-07-04 21:54:47.113335', '', '服务监控', 10, 0, 'server', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', '77edf447326b4e0dbc6f9719c1de8a12');
INSERT INTO `lyadmin_menu` VALUES ('c236fb6b-ddaa-4deb-b79b-16e42d9f347f', NULL, NULL, NULL, '2022-06-27 13:56:06.194704', '2022-06-27 13:56:06.194704', 'info-filled', '日志管理', 999, 0, 'journalManage', NULL, NULL, 1, 0, 0, 1, NULL, NULL);
INSERT INTO `lyadmin_menu` VALUES ('d4e2fe169a8b40f3846421ac04e4fccb', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2025-02-20 08:13:25.729476', '2022-06-27 13:56:06.170108', 'platform', '基础管理', 9, 0, '', NULL, NULL, 0, 0, 0, 1, NULL, NULL);
INSERT INTO `lyadmin_menu` VALUES ('dc8c173b425048e7a8c9b59513596c7f', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL, '2022-07-28 23:38:06.926563', '2022-07-28 23:38:06.926563', '', '商品财务流水', 1, 0, 'financeStatisticsGoods', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', '2a7c0142f7514dacb7999383e4e67aca');
INSERT INTO `lyadmin_menu` VALUES ('e0f53902-e901-490c-83f3-331e60b97fcf', NULL, NULL, NULL, '2022-06-27 13:56:06.183705', '2022-06-27 13:56:06.183705', '', '按钮配置', 2, 0, 'buttonConfig', 'system/ menuButton', NULL, 1, 0, 0, 0, NULL, '54f769b0-3dff-416c-8102-e55ec44827cc');
INSERT INTO `lyadmin_menu` VALUES ('e686a47f91854a8482b334c91336f666', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd2c03bd9-dad0-4262-88ca-c3681d224fc3', '2025-01-23 20:11:51.708283', '2025-01-23 19:10:19.341270', 'CameraFilled', '服务器管理', 0, 0, 'serversManage', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'f374d275152b4351914b8e85009c7990');
INSERT INTO `lyadmin_menu` VALUES ('f374d275152b4351914b8e85009c7990', NULL, '456b688c-8ad5-46de-bc2e-d41d8047bd42', 'd2c03bd9-dad0-4262-88ca-c3681d224fc3', '2025-01-24 20:58:02.814055', '2025-01-23 19:07:49.702786', 'Briefcase', '设备管理', 1, 0, '', NULL, NULL, 1, 1, 0, 1, '456b688c-8ad5-46de-bc2e-d41d8047bd42', NULL);
SET FOREIGN_KEY_CHECKS = 1;