加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
power_menu.sql 8.21 KB
一键复制 编辑 原始数据 按行查看 历史
如故。 提交于 2024-10-28 16:31 . stripe后台支付、
/*
Navicat Premium Data Transfer
Source Server : arnosport
Source Server Type : MySQL
Source Server Version : 50650
Source Host : 8.210.90.110:3306
Source Schema : arnosport
Target Server Type : MySQL
Target Server Version : 50650
File Encoding : 65001
Date: 28/10/2024 16:18:47
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for power_menu
-- ----------------------------
DROP TABLE IF EXISTS `power_menu`;
CREATE TABLE `power_menu` (
`power_menu_id` int(11) NOT NULL AUTO_INCREMENT,
`power_id` int(11) NULL DEFAULT NULL COMMENT '权限id',
`role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
`menu_id` int(11) NULL DEFAULT NULL COMMENT '路由id',
`status` int(11) NULL DEFAULT 0 COMMENT '0:禁用1:正常',
`created_at` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`updated_at` datetime NULL DEFAULT NULL,
PRIMARY KEY (`power_menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '路由权限表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of power_menu
-- ----------------------------
INSERT INTO `power_menu` VALUES (1, 2, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (2, 3, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (3, 4, 1, 2, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (4, 2, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (5, 3, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (6, 4, 1, 3, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (7, 2, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (8, 3, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (9, 4, 1, 5, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (10, 1, 1, 7, 1, '2024-09-09 10:30:15', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (11, 2, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (12, 3, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (13, 4, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (14, 5, 1, 7, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (15, 2, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (16, 3, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (17, 4, 1, 8, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (18, 2, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (19, 3, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (20, 4, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (21, 6, 1, 10, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (22, 2, 1, 12, 1, '2024-09-09 10:30:16', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (23, 3, 1, 12, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (24, 4, 1, 12, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (25, 2, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (26, 3, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (27, 4, 1, 14, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (28, 2, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (29, 3, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (30, 4, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (31, 7, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (32, 16, 1, 15, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (33, 2, 1, 17, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (34, 3, 1, 17, 1, '2024-09-09 10:30:17', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (35, 4, 1, 17, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (36, 4, 1, 18, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (37, 8, 1, 18, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (38, 1, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (39, 4, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (40, 9, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (41, 10, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (42, 11, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (43, 12, 1, 20, 1, '2024-09-09 10:30:13', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (44, 13, 1, 20, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (45, 14, 1, 21, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (46, 15, 1, 21, 1, '2024-09-09 10:30:18', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (47, 4, 1, 24, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (48, 2, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (49, 3, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (50, 4, 1, 26, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (51, 3, 1, 30, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (52, 2, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (53, 3, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (54, 4, 1, 31, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (55, 2, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (56, 3, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (57, 4, 1, 32, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (58, 3, 1, 33, 1, '2024-09-09 10:30:19', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (59, 2, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (60, 3, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (61, 4, 1, 34, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (62, 3, 1, 36, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (63, 2, 1, 37, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (64, 4, 1, 37, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (65, 3, 1, 39, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (66, 3, 1, 40, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (67, 2, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (68, 3, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (69, 4, 1, 42, 1, '2024-09-09 10:30:20', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (70, 4, 1, 44, 1, '2024-09-09 10:30:21', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (71, 4, 1, 50, 1, '2024-09-09 10:30:21', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (72, 2, 1, 52, 1, '2024-10-28 16:13:59', '2024-09-08 10:30:05');
INSERT INTO `power_menu` VALUES (73, 3, 1, 52, 1, '2024-10-28 16:15:11', '2024-10-28 16:14:03');
INSERT INTO `power_menu` VALUES (74, 4, 1, 52, 1, '2024-10-28 16:15:13', '2024-10-28 16:14:03');
SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化