/*
 Navicat MySQL Dump SQL

 Source Server         : Local
 Source Server Type    : MySQL
 Source Server Version : 80403 (8.4.3)
 Source Host           : localhost:3306
 Source Schema         : sfr

 Target Server Type    : MySQL
 Target Server Version : 80403 (8.4.3)
 File Encoding         : 65001

 Date: 08/12/2025 21:03:16
*/


-- ----------------------------
-- Table structure for categories
-- ----------------------------
CREATE TABLE `categories`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES (3, 'Festival', 1, 1, 1, '2025-12-08 20:43:42', '2025-12-08 20:44:12');
INSERT INTO `categories` VALUES (4, 'Concierto', 1, 1, 1, '2025-12-08 20:43:52', '2025-12-08 20:44:13');
INSERT INTO `categories` VALUES (5, 'Workshop', 1, 1, 1, '2025-12-08 20:44:08', '2025-12-08 20:44:14');

-- ----------------------------
-- Table structure for events
-- ----------------------------
CREATE TABLE `events`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `date` date NULL DEFAULT NULL,
  `time` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `imageUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `price` double NULL DEFAULT NULL,
  `category_id` bigint NULL DEFAULT NULL,
  `availableSeats` int NULL DEFAULT NULL,
  `isPresale` tinyint NULL DEFAULT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `category_id`(`category_id` ASC) USING BTREE,
  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of events
-- ----------------------------
INSERT INTO `events` VALUES (3, 'Velit adipisicing ex', 'Eos pariatur Minim', '1974-08-01', '14:30', 'Quisquam rerum incid', 'At id quasi et vita', NULL, 575, 3, NULL, NULL, 1, 1, 1, '2025-12-08 20:48:11', '2025-12-08 20:48:11');

-- ----------------------------
-- Table structure for group_method
-- ----------------------------
CREATE TABLE `group_method`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` bigint NOT NULL,
  `method_id` bigint NULL DEFAULT NULL,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `group_id`(`group_id` ASC) USING BTREE,
  INDEX `method_id`(`method_id` ASC) USING BTREE,
  CONSTRAINT `group_method_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `group_method_ibfk_2` FOREIGN KEY (`method_id`) REFERENCES `methods` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of group_method
-- ----------------------------
INSERT INTO `group_method` VALUES (1, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (2, 1, 2, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (3, 1, 3, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (4, 1, 4, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (5, 1, 5, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (6, 1, 6, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (7, 1, 7, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (8, 1, 8, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (9, 1, 9, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (10, 1, 10, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (11, 1, 11, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (12, 1, 12, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (13, 1, 13, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (14, 1, 14, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (15, 1, 15, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (16, 1, 16, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (17, 1, 17, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (18, 1, 18, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (19, 1, 19, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (20, 1, 20, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (21, 1, 21, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (22, 1, 22, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (23, 1, 23, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (24, 1, 24, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (25, 1, 25, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (26, 1, 26, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (27, 1, 27, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (28, 1, 28, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (29, 1, 29, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (30, 1, 30, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (31, 1, 31, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (32, 1, 32, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (33, 1, 33, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (34, 1, 34, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (35, 1, 35, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (36, 1, 36, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (37, 1, 37, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (38, 1, 38, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (39, 1, 39, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (40, 1, 40, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (41, 1, 41, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (42, 1, 42, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (43, 1, 43, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (44, 1, 44, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (45, 1, 45, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (46, 1, 46, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (47, 1, 47, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (48, 2, 38, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (49, 2, 39, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (50, 2, 40, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (51, 2, 41, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (52, 2, 42, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (53, 2, 43, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (54, 2, 44, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (55, 2, 45, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (56, 2, 46, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (57, 2, 47, NULL, NULL, NULL, NULL);
INSERT INTO `group_method` VALUES (58, 1, 51, NULL, NULL, '2025-12-08 20:21:08', '2025-12-08 20:21:08');
INSERT INTO `group_method` VALUES (59, 1, 52, NULL, NULL, '2025-12-08 20:21:09', '2025-12-08 20:21:09');
INSERT INTO `group_method` VALUES (60, 1, 54, NULL, NULL, '2025-12-08 20:21:09', '2025-12-08 20:21:09');
INSERT INTO `group_method` VALUES (61, 1, 49, NULL, NULL, '2025-12-08 20:21:09', '2025-12-08 20:21:09');
INSERT INTO `group_method` VALUES (62, 1, 53, NULL, NULL, '2025-12-08 20:21:10', '2025-12-08 20:21:10');
INSERT INTO `group_method` VALUES (63, 1, 55, NULL, NULL, '2025-12-08 20:21:10', '2025-12-08 20:21:10');
INSERT INTO `group_method` VALUES (64, 1, 48, NULL, NULL, '2025-12-08 20:21:10', '2025-12-08 20:21:10');
INSERT INTO `group_method` VALUES (65, 1, 50, NULL, NULL, '2025-12-08 20:21:11', '2025-12-08 20:21:11');

-- ----------------------------
-- Table structure for groups
-- ----------------------------
CREATE TABLE `groups`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of groups
-- ----------------------------
INSERT INTO `groups` VALUES (1, 'Programador', 1, -1, -1, NULL, NULL);
INSERT INTO `groups` VALUES (2, 'Administrador', 1, -1, -1, NULL, NULL);

-- ----------------------------
-- Table structure for menus
-- ----------------------------
CREATE TABLE `menus`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES (1, 'Menu', 'MENUS', 'fas fa-th-list', 1, -1, -1, NULL, NULL);
INSERT INTO `menus` VALUES (2, 'Method', 'METODOS', 'fas fa-list-ul', 1, -1, -1, NULL, NULL);
INSERT INTO `menus` VALUES (3, 'Group', 'GRUPOS', 'fas fa-users-cog', 1, -1, -1, NULL, NULL);
INSERT INTO `menus` VALUES (4, 'User', 'USUARIOS', 'fas fa-users', 1, -1, -1, NULL, NULL);
INSERT INTO `menus` VALUES (5, 'Admin', 'ADMINS', 'fas fa-users', 1, -1, -1, NULL, NULL);
INSERT INTO `menus` VALUES (6, 'event', 'EVENTOS', 'fas fa-users', 1, 1, 1, '2025-12-08 20:14:09', '2025-12-08 20:14:29');

-- ----------------------------
-- Table structure for methods
-- ----------------------------
CREATE TABLE `methods`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `action` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `menu_id` bigint NULL DEFAULT NULL,
  `is_menu` tinyint NULL DEFAULT NULL,
  `is_action` tinyint NULL DEFAULT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `menu_id`(`menu_id` ASC) USING BTREE,
  CONSTRAINT `methods_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of methods
-- ----------------------------
INSERT INTO `methods` VALUES (1, 'registrar', 'Registrar', NULL, NULL, 1, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (2, 'lista', 'Lista', NULL, NULL, 1, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (3, 'registrarBd', NULL, NULL, NULL, 1, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (4, 'activarBd', NULL, 'Activar', 'fas fa-play', 1, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (5, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 1, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (6, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 1, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (7, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 1, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (8, 'modificarBd', NULL, NULL, NULL, 1, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (9, 'registrar', 'Registrar', NULL, NULL, 2, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (10, 'lista', 'Lista', NULL, NULL, 2, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (11, 'registrarBd', NULL, NULL, NULL, 2, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (12, 'activarBd', NULL, 'Activar', 'fas fa-play', 2, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (13, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 2, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (14, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 2, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (15, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 2, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (16, 'modificarBd', NULL, NULL, NULL, 2, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (17, 'permisos', NULL, 'Asigna Permisos', 'fas fa-plus-square', 3, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (18, 'bajaPermiso', NULL, NULL, NULL, 3, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (19, 'altaPermiso', NULL, NULL, NULL, 3, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (20, 'registrar', 'Registrar', NULL, NULL, 3, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (21, 'lista', 'Lista', NULL, NULL, 3, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (22, 'registrarBd', NULL, NULL, NULL, 3, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (23, 'activarBd', NULL, 'Activar', 'fas fa-play', 3, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (24, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 3, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (25, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 3, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (26, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 3, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (27, 'modificarBd', NULL, NULL, NULL, 3, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (28, 'nuevaContra', NULL, 'Cambiar contraseña', 'fas fa-key', 4, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (29, 'nuevaContraBd', NULL, NULL, NULL, 4, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (30, 'registrar', 'Registrar', NULL, NULL, 4, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (31, 'lista', 'Lista', NULL, NULL, 4, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (32, 'registrarBd', NULL, NULL, NULL, 4, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (33, 'activarBd', NULL, 'Activar', 'fas fa-play', 4, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (34, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 4, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (35, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 4, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (36, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 4, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (37, 'modificarBd', NULL, NULL, NULL, 4, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (38, 'nuevaContra', '', 'Cambiar contraseña', 'fas fa-key', 5, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (39, 'nuevaContraBd', '', '', '', 5, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (40, 'registrar', 'Registrar', '', '', 5, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (41, 'lista', 'Lista', '', '', 5, 1, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (42, 'registrarBd', '', '', '', 5, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (43, 'activarBd', '', 'Activar', 'fas fa-play', 5, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (44, 'desactivarBd', '', 'Desactivar', 'fas fa-pause', 5, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (45, 'modificar', '', 'Modificar', 'fas fa-pencil-alt', 5, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (46, 'eliminarBd', '', 'Eliminar', 'fas fa-trash', 5, 0, 1, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (47, 'modificarBd', '', '', '', 5, 0, 0, 1, -1, -1, NULL, NULL);
INSERT INTO `methods` VALUES (48, 'registrar', 'Registrar', NULL, NULL, 6, 1, 0, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (49, 'lista', 'Lista', NULL, NULL, 6, 1, 0, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (50, 'registrarBd', NULL, NULL, NULL, 6, 0, 0, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (51, 'activarBd', NULL, 'Activar', 'fas fa-play', 6, 0, 1, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (52, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 6, 0, 1, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (53, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 6, 0, 1, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (54, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 6, 0, 1, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');
INSERT INTO `methods` VALUES (55, 'modificarBd', NULL, NULL, NULL, 6, 0, 0, 1, NULL, NULL, '2025-12-08 20:14:09', '2025-12-08 20:14:09');

-- ----------------------------
-- Table structure for methods_base
-- ----------------------------
CREATE TABLE `methods_base`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `action` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `menu_id` bigint NULL DEFAULT NULL,
  `is_menu` tinyint NULL DEFAULT NULL,
  `is_action` tinyint NULL DEFAULT NULL,
  `activo` tinyint NULL DEFAULT 1,
  `created_user_id` bigint NULL DEFAULT NULL,
  `updated_user_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of methods_base
-- ----------------------------
INSERT INTO `methods_base` VALUES (1, 'nuevaContra', NULL, 'Cambiar contraseña', 'fas fa-key', 5, 0, 1, 0, -1, -1, NULL, '2025-02-02 10:47:57');
INSERT INTO `methods_base` VALUES (2, 'nuevaContraBd', NULL, NULL, NULL, 5, 0, 0, 0, -1, -1, NULL, '2025-02-02 10:47:58');
INSERT INTO `methods_base` VALUES (3, 'registrar', 'Registrar', NULL, NULL, 5, 1, 0, 1, -1, -1, NULL, '2025-02-02 10:42:40');
INSERT INTO `methods_base` VALUES (4, 'lista', 'Lista', NULL, NULL, 5, 1, 0, 1, -1, -1, NULL, '2025-02-02 10:42:42');
INSERT INTO `methods_base` VALUES (5, 'registrarBd', NULL, NULL, NULL, 5, 0, 0, 1, -1, -1, NULL, '2025-02-02 10:42:44');
INSERT INTO `methods_base` VALUES (6, 'activarBd', NULL, 'Activar', 'fas fa-play', 5, 0, 1, 1, -1, -1, NULL, '2025-02-02 10:42:17');
INSERT INTO `methods_base` VALUES (7, 'desactivarBd', NULL, 'Desactivar', 'fas fa-pause', 5, 0, 1, 1, -1, -1, NULL, '2025-02-02 10:42:23');
INSERT INTO `methods_base` VALUES (8, 'modificar', NULL, 'Modificar', 'fas fa-pencil-alt', 5, 0, 1, 1, -1, -1, NULL, '2025-02-02 10:42:21');
INSERT INTO `methods_base` VALUES (9, 'eliminarBd', NULL, 'Eliminar', 'fas fa-trash', 5, 0, 1, 1, -1, -1, NULL, '2025-02-02 10:42:25');
INSERT INTO `methods_base` VALUES (10, 'modificarBd', NULL, NULL, NULL, 5, 0, 0, 1, -1, -1, NULL, '2025-02-02 10:42:48');

