-- ============================================================ -- SYSTEM DATA SEED — ejecutar completo en MySQL -- Tablas afectadas: instituciones, roles, permisos, users, -- rol_permiso, rol_usuario, -- user_permiso, user_entidades -- ============================================================ SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE rol_permiso; TRUNCATE TABLE rol_usuario; TRUNCATE TABLE user_permiso; TRUNCATE TABLE user_entidades; TRUNCATE TABLE permisos; TRUNCATE TABLE users; TRUNCATE TABLE roles; TRUNCATE TABLE instituciones; ALTER TABLE roles AUTO_INCREMENT = 1; ALTER TABLE permisos AUTO_INCREMENT = 1; ALTER TABLE users AUTO_INCREMENT = 1; ALTER TABLE instituciones AUTO_INCREMENT = 1; SET FOREIGN_KEY_CHECKS = 1; -- ============================================================ -- DOMAINS (32 registros, IDs 1–32) -- ============================================================ INSERT INTO instituciones (id, nombre, created_at, updated_at) VALUES (1, 'test', '2024-07-29 22:15:24', '2024-07-29 22:15:24'), (2, 'https://iestpsenordegualamita.edu.pe', '2024-07-29 22:15:24', '2024-08-05 03:26:19'), (3, 'https://iestpgell-leimebamba.edu.pe/', '2024-08-04 17:47:28', '2024-08-05 03:24:46'), (4, 'https://iestpfya74.edu.pe/', '2024-08-05 03:27:40', '2024-08-05 03:27:40'), (5, 'https://iestputcubamba.edu.pe', '2024-08-05 03:28:57', '2024-08-05 03:28:57'), (6, 'https://www.iestpbagua.edu.pe', '2024-08-05 03:30:51', '2024-08-05 03:30:51'), (7, 'iestptsamajain.edu.pe', '2024-08-12 05:38:06', '2024-11-03 06:25:04'), (8, 'https://campus.iestplg.edu.pe', '2024-09-19 20:19:54', '2024-11-03 06:27:00'), (9, 'https://www.iepdivinosalvador.com/', '2024-09-29 14:21:25', '2024-11-09 22:15:13'), (10, 'www.conlevel.com', '2024-09-29 14:27:08', '2024-09-29 14:27:08'), (11, 'https://www.leerveloz.com', '2024-10-28 21:48:08', '2024-11-09 22:17:45'), (12, 'ejemplotest.com', '2025-05-04 04:47:50', '2025-05-04 04:47:50'), (13, 'www.ejemplotest2.com', '2025-05-04 16:46:12', '2025-05-04 16:46:12'), (14, 'www.EmpresaTest.com', '2025-05-04 17:06:15', '2025-05-04 17:06:15'), (15, 'www.iestpgualamita.edu.pe ', '2025-05-04 17:38:54', '2025-05-04 17:38:54'), (16, 'www.iestpfeyalegria74.edu.pe', '2025-05-04 17:40:53', '2025-05-04 17:40:53'), (17, 'www.iestpgell.edu.pe', '2025-05-04 17:42:43', '2025-05-04 17:42:43'), (18, 'www.iestptsamajain.edu.pe', '2025-05-04 17:43:22', '2025-05-04 17:43:22'), (19, 'www.iestplg.edu.pe', '2025-05-04 17:43:55', '2025-05-04 17:43:55'), (20, ' www.iestputcubamba.edu.pe', '2025-05-04 17:44:32', '2025-05-04 17:44:32'), (21, 'www.iestpbagua.edu.pe', '2025-05-04 17:45:05', '2025-05-04 17:45:05'), (22, 'www.iestprodriguezdemendoza.edu.pe', '2025-05-04 18:15:19', '2025-05-04 18:15:19'), (23, 'www.goreamazonas.pe', '2025-05-04 18:18:36', '2025-05-04 18:18:36'), (24, 'www.levelte.com', '2025-05-15 06:19:44', '2025-05-15 06:19:44'), (25, 'ejemplo test', '2025-05-21 22:40:52', '2025-05-21 22:40:52'), (26, 'www.test.com', '2025-06-01 16:23:02', '2025-06-01 16:23:02'), (27, 'www.leerveloz.com', '2025-06-05 19:58:23', '2025-06-05 19:58:23'), (28, 'www.iestplg', '2025-06-13 06:01:09', '2025-06-13 06:01:09'), (29, 'www.iestpgualamita.edu.pe', '2025-06-14 15:06:40', '2025-06-14 15:06:40'), (30, 'www.iestpgell.edu.pe', '2025-06-14 15:07:22', '2025-06-14 15:07:22'), (31, 'www.levelte.com', '2025-06-14 23:18:12', '2025-06-14 23:18:12'), (32, 'institucional', '2026-05-26 00:33:23', '2026-05-26 00:33:23'); -- ============================================================ -- ROLES (10 roles, IDs 1–10) -- ============================================================ INSERT INTO roles (id, nombre, fecha, domain_id) VALUES (1, 'SuperAdmin', '2024-07-29 03:53:17', NULL), (2, 'Administrador', '2024-07-29 03:53:17', NULL), (3, 'Alumno', '2024-07-29 06:55:33', NULL), (4, 'Docentes', '2024-07-30 05:47:14', NULL), (5, 'Postulante', '2024-08-12 03:53:03', NULL), (6, 'Elecciones', '2024-09-29 14:22:21', NULL), (7, 'veedor', '2024-09-29 18:28:45', NULL), (8, 'editor_sin_estado', '2024-09-29 18:28:44', NULL), (9, 'Candidato', '2024-09-29 18:03:54', NULL), (10, 'Estructura', '2024-07-29 03:53:17', NULL); -- ============================================================ -- PERMISOS / MENÚ (58 ítems, IDs 1–58) -- IDs originales 50–103 → nuevo ID = viejo - 49 -- permiso_parent_id también restarle 49 -- IDs 55-58: rutas del frontend sin permiso (agregados) -- ============================================================ INSERT INTO permisos (id, nombre, descripcion, fecha, permiso_parent_id, tipo, `key`, icon, orden, url) VALUES -- Raíces (sin padre) (1, 'MULTI EMPRESAS', NULL, NULL, NULL, 'accordion', 'multi-empresas', NULL, NULL, NULL), (2, 'SEGURIDAD', NULL, NULL, NULL, 'accordion', 'seguridad', NULL, NULL, NULL), (3, 'ESTRUCTURA ORGANICA', NULL, NULL, NULL, 'accordion', 'estructura-organica', NULL, NULL, NULL), (4, 'AULA VIRTUAL', NULL, NULL, NULL, 'accordion', 'aula-virtual', NULL, NULL, NULL), (5, 'AGENDA VIRTUAL', NULL, NULL, NULL, 'accordion', 'agenda-virtual', NULL, NULL, NULL), (6, 'EJECUCION PROYECTOS', NULL, NULL, NULL, 'accordion', 'ejecucion-proyectos', NULL, NULL, NULL), (7, 'GESTION INCIDENCIAS', NULL, NULL, NULL, 'accordion', 'gestion-incidencias', NULL, NULL, NULL), (8, 'PROYECTOS', NULL, NULL, NULL, 'accordion', 'proyectos', NULL, NULL, NULL), -- Hijos de MULTI EMPRESAS (1) (9, 'Empresas', NULL, NULL, 1, 'item', 'empresas', NULL, NULL, '/company/list-company'), -- Hijos de SEGURIDAD (2) (10, 'Configuración', NULL, NULL, 2, 'item', 'configuracion', NULL, NULL, '/configuration/company'), (11, 'Roles y permisos', NULL, NULL, 2, 'item', 'roles-permisos', NULL, NULL, '/configuration/roles'), (12, 'Usuarios', NULL, NULL, 2, 'item', 'usuarios', NULL, NULL, '/configuration/users'), -- Hijos de ESTRUCTURA ORGANICA (3) (13, 'Banco de CV', NULL, NULL, 3, 'accordion', 'banco-cv', NULL, NULL, NULL), (14, 'CV', NULL, NULL, 13, 'item', 'cv', NULL, NULL, '/structure/bank-cv'), (15, 'Depentencia', NULL, NULL, 3, 'item', 'depentencia', NULL, NULL, '/structure/dependence'), (16, 'Reporte Puestos', NULL, NULL, 3, 'item', 'reporte-puestos', NULL, NULL, '/structure/report-job'), (17, 'Mantenimiento', NULL, NULL, 3, 'accordion', 'mantenimiento', NULL, NULL, NULL), -- Hijos de Mantenimiento (17) (18, 'Año', NULL, NULL, 17, 'item', 'anio', NULL, NULL, '/structure/affiliate-party'), (19, 'Gestiones', NULL, NULL, 17, 'accordion', 'gestiones', NULL, NULL, NULL), (20, 'Grado Instrucción', NULL, NULL, 17, 'item', 'grado-instruccion', NULL, NULL, '/maintenance/list-instruction-degree'), (21, 'Vinculos Laborales', NULL, NULL, 17, 'item', 'vinculos-laborales', NULL, NULL, '/maintenance/list-employment-ties'), (22, 'Niveles de Puesto', NULL, NULL, 17, 'item', 'niveles-puesto', NULL, NULL, '/maintenance/list-position-level'), (23, 'Modalidad de Puesto', NULL, NULL, 17, 'item', 'modalidad-puesto', NULL, NULL, '/maintenance/list-position-modality'), (24, 'Profesiones', NULL, NULL, 17, 'item', 'profesiones', NULL, NULL, '/maintenance/list-profession'), (25, 'Estado de Avance', NULL, NULL, 17, 'item', 'estado-avance', NULL, NULL, '/maintenance/list-progress-status'), (26, 'Escala', NULL, NULL, 17, 'item', 'escala', NULL, NULL, '/maintenance/list-scale'), (27, 'Ocupación Actual', NULL, NULL, 17, 'item', 'ocupacion-actual', NULL, NULL, '/maintenance/list-occupation'), (28, 'Bolsa de Trabajo', NULL, NULL, 3, 'item', 'bolsa-trabajo', NULL, NULL, '/maintenance/list-job-offer'), -- Hijos de AULA VIRTUAL (4) (29, 'Mantenimientos', NULL, NULL, 4, 'accordion', 'mantenimiento-aula', NULL, NULL, NULL), (30, 'Modulo', NULL, NULL, 29, 'item', 'modulo', NULL, NULL, '/maintenance/list-module'), (31, 'Competencia', NULL, NULL, 29, 'item', 'competencia', NULL, NULL, '/maintenance/list-competence'), (32, 'Area de Promociones', NULL, NULL, 29, 'item', 'area-promociones', NULL, NULL, '/maintenance/list-promotion'), (33, 'Estados', NULL, NULL, 29, 'item', 'estados', NULL, NULL, '/maintenance/list-state'), (34, 'Plan de Estudio', NULL, NULL, 29, 'item', 'plan-estudio', NULL, NULL, '/maintenance/list-state-course'), (35, 'Ciclos', NULL, NULL, 29, 'item', 'ciclos', NULL, NULL, '/maintenance/list-cycle'), (36, 'Aulas', NULL, NULL, 29, 'item', 'aulas', NULL, NULL, '/maintenance/list-classroom'), (37, 'Carreras Tecnicas', NULL, NULL, 4, 'item', 'carreras-tecnicas', NULL, NULL, '/technical-careers/list-technical-careers'), (38, 'Unidades Didacticas', NULL, NULL, 4, 'item', 'unidades-didacticas', NULL, NULL, '/didactic-units/list-didactic-units'), (39, 'Alumnos', NULL, NULL, 4, 'accordion', 'alumnos', NULL, NULL, NULL), (40, 'Datos Personales', NULL, NULL, 39, 'item', 'datos-personales-alumno', NULL, NULL, '/student/list-student'), (41, 'Documentos de Gestion', NULL, NULL, 39, 'item', 'documentos-gestion', NULL, NULL, '/student/document-management-student'), (42, 'Unidad Didactica', NULL, NULL, 39, 'item', 'unidad-didactica-alumno', NULL, NULL, '/student/courses-student'), (43, 'Docentes', NULL, NULL, 4, 'accordion', 'docentes', NULL, NULL, NULL), (44, 'Datos Personales', NULL, NULL, 43, 'item', 'datos-personales-docente', NULL, NULL, '/teacher/list-teacher'), (45, 'Documentos de Gestion', NULL, NULL, 43, 'item', 'documentos-gestion-docente', NULL, NULL, '/teacher/list-teacher'), (46, 'Unidad Didactica', NULL, NULL, 43, 'item', 'unidad-didactica-docente', NULL, NULL, '/teacher/course-teacher'), (47, 'Capacitaciones', NULL, NULL, 4, 'item', 'capacitaciones', NULL, NULL, '/trainings/list-training'), (48, 'Pagos', NULL, NULL, 4, 'item', 'pagos', NULL, NULL, '/payments/list-payments'), -- Hijos de AGENDA VIRTUAL (5) (49, 'Candidatos', NULL, NULL, 5, 'accordion', 'candidatos', NULL, NULL, NULL), -- Hijos de EJECUCION PROYECTOS (6) (50, 'Ejecucion', NULL, NULL, 6, 'accordion', 'ejecucion', NULL, NULL, NULL), -- Hijos de GESTION INCIDENCIAS (7) (51, 'Incidencias', NULL, NULL, 7, 'accordion', 'incidencias', NULL, NULL, NULL), -- Hijos de PROYECTOS (8) (52, 'proyectos', NULL, NULL, 8, 'item', 'proyectos', NULL, NULL, '/projects/list-project'), (53, 'Avance Curricular', 'Acceso al módulo de Avance Curricular', '2025-06-02 01:57:16', 39, 'item', 'avance-curricular', NULL, NULL, '/student/curricular-advance-report'), (54, 'Tarea', NULL, NULL, 8, 'item', 'tarea', NULL, NULL, '/maintenance/list-task'), -- ─── Ítems faltantes (rutas del frontend sin permiso) ───────────────────────── -- Inicio / Dashboard (raíz, sin padre) (55, 'Inicio', NULL, NULL, NULL, 'item', 'inicio', NULL, 1, '/dashboard'), -- Menús (administración de menú) — hijo de SEGURIDAD (2) (56, 'Menús', NULL, NULL, 2, 'item', 'menus', NULL, NULL, '/configuration/menus'), -- Feriados — hijo de Mantenimiento (17, dentro de ESTRUCTURA ORGANICA) (57, 'Feriados', NULL, NULL, 17, 'item', 'feriados', NULL, NULL, '/maintenance/holiday-management'), -- Reporte Docente — hijo de Docentes (43, dentro de AULA VIRTUAL) (58, 'Reporte Docente', NULL, NULL, 43, 'item', 'reporte-docente', NULL, NULL, '/teacher/report-course-teacher'); -- ============================================================ -- USUARIOS (12 usuarios, IDs 1–12) -- CARLOS TEVES: rol_id original 21 → mapeado a 5 (Postulante) -- ============================================================ INSERT INTO users (id, name, email, dni, password, password_changed, password_changed_at, api_token, type, status, remember_token, created_at, updated_at, rol_id, domain_id, alumno_id, docente_id, postulante_id, lastname, candidato_id) VALUES (1, 'ADMIN', 'admin@gmail.com', NULL, '$2a$12$3b2sNsvS12JzyO0n1vER3OVzY266cqJPviMfvcjrQGa.X.1A5b1ye', 0, NULL, 'OSShWxPtaWHantBy9mbgdLIx8bigLdn3Kr1lAQJ2jhByaJqKi4JmkwOh9zAMNfKJwjDveMCcQ97tc6UTueUX8w22DZzuK55n9x97mamUIC5JiF7nJTxoCjvg5bY7XzuIddB32bfhvZbEawJstbQJOg', 'invited', 'active', NULL, '2024-07-28 18:22:34', '2024-07-28 18:22:34', 1, 2, NULL, NULL, NULL, NULL, NULL), (2, 'GORE AMAZONAS', 'estructura@gmail.com', '1234578', '$2y$12$Jmm3fvBW6uK44GDiktN48ex97qNOiywIIFxDgs1QWqpZv3xnJW9CC', 0, NULL, 'w4kLWz9C7m0oEXFJLfRiJzSD3wRAXGQ8syL7rNEPXX9c4oQi1kRhn2UyGjCdwMenmJyMuWIAUpU4mncvcMhoHLaI657baP45N6CEgSXSQJkabkRPQWoDjOkZGfFm2KEUxSXenj9iXgCoAFL5kunDu1', 'invited', 'active', NULL, NULL, NULL, 8, 23, NULL, NULL, NULL, NULL, NULL), (3, 'IESTP FE Y ALEGRIA 74', 'fya74@gmail.com', '12345678', '$2y$12$deZ9fmB6bcApIXmJJf8R3.I9ve4cLyAbw4JXBtrQ7S8/kTgFVs0OO', 0, NULL, '6QllEUyIAeEpZ12gy079fCd5O7MSOAq8qQZuO9oppY29RoZA6XQSnkOtt3Q4ekSflMTazuK1oA0tCszayjdy486gch8Cc0gIkHvnrYxqekInC7eq9jfd8trazNmyXKmvlWiEAOftpPgupRSDfzrQnK', 'invited', 'active', NULL, NULL, NULL, 8, 16, NULL, NULL, NULL, NULL, NULL), (4, 'IESTP GELL LEYMEBAMBA', 'gell@gmail.com', '12345678', '$2y$12$F7zCsN7avn0ThGYJwL2seO9MPLgpkq8qQTmhrApV55x25Bk3l3uUy', 0, NULL, 'QTasUQPfQNdom1Ki0PR8gT4tuGrg6UctlZs4Ksdpzrjhm6JRjhS9oLtlayeoY1ObxroyJdaqSHo67s0VtE3wB5wQluc7uv6XgYuIHwvlxqKC2P8vdVxnq0uXPUFG2cdAc09bxLPUbSLURbbakR1Iqf', 'invited', 'active', NULL, NULL, NULL, 8, 17, NULL, NULL, NULL, NULL, NULL), (5, 'IESTP TSAMAJAIN', 'tsamajain@gmail.com', '12345678', '$2y$12$N5UQ/yUL3A0hmP9qEaEo1OxTLRn04BuquJzYcS48dH9tlnsZIqbhW', 0, NULL, 'yXAG7vc3pj469yS5gBhbjWmDmf5JGaEQ82tWWWiVPLWXCelq4fOp3pdpbd4aoAtmQpauRPdFEKyiBh5MzG13MSjnDPZxTEF6YO4gctYlByW2l5TPLLBTUjchKjyoABvKE6xCMi4miJNR8jbV0K3vnA', 'invited', 'active', NULL, NULL, NULL, 8, 18, NULL, NULL, NULL, NULL, NULL), (6, 'IESTP LONYA GRANDE', 'iestplonya@gmail.com', '12345678', '$2y$12$wP4ORp5wO2ZgSJFTJdzGKub98RZm9/LlwY41EVijk/q/j7aUgZSX6', 0, NULL, 'l7GcwMeOQTKViIdCEfuRV97q7r8CVceoK6xy2gtbZWAGq32cSuvFsNi19ca6o7gGtYgMn74LB67fzIqATs7Y64wUCPKhzh0qPHntUcrCL6CpGpABym1WcVYEphjtymxEyVlCsUxgtFLIw2Inep1npx', 'invited', 'active', NULL, NULL, NULL, 8, 19, NULL, NULL, NULL, NULL, NULL), (7, 'IESTP UTCUBAMBA', 'iestputcubamba@gmail.com', '12345670', '$2y$12$h8Hw5RrgB9fmKDp2qxC7teOzrqhSRMzlSAzOjwv01l6CQhppb/hsC', 0, NULL, 'fEJWKAuHESEkcNLdZG2PeQSGgscwiL1w0bLeC65bVqt5CH63szkJjI3CM8cMZqMbdCcaiZxjjRPsAuFPBZSe1T2DYlKJ6WmVlovfWzE2g2oeLu6Pvv8O9mhOWfOg2XsOLPDLIhrIxmAPyUhLTJAHJN', 'invited', 'active', NULL, NULL, NULL, 8, 20, NULL, NULL, NULL, NULL, NULL), (8, 'IESTP BAGUA', 'iestpbagua@gmail.com', '12345673', '$2y$12$GUUZ2WtIZbaCJUjneDsHaOzo/iUMVXaAzleV9WKE0d5U7XnS3rStu', 0, NULL, NULL, 'invited', 'active', NULL, NULL, NULL, 8, 21, NULL, NULL, NULL, NULL, NULL), (9, 'IESTP RODRIGUEZ DE MENDOZA', 'rmendoza@gmail.com', '12345675', '$2y$12$pswNEoClPRqOIWsKwtLZj.N9xiLqCrYmbE1cAfVAPhfUjk8G16XSe', 0, NULL, NULL, 'invited', 'active', NULL, NULL, NULL, 8, 22, NULL, NULL, NULL, NULL, NULL), (10, 'CARLOS TEVES', 'cv1@gmail.com', '12345679', '', 0, NULL, NULL, 'user', 'active', NULL, '2025-06-14 20:42:28', '2025-06-14 20:42:28', 5, 15, NULL, NULL, NULL, NULL, NULL), (11, 'LEVEL LEVEL', 'level@gmail.com', '23568965', '$2y$12$4Qo5hx29Q3IXEw06m2wJjeBa0AZMBWt.qCnEPUeE6hu0vaH0ymZRK', 0, NULL, 'uRRJBfyf6UmqzAVoXz80FfRdXsPWhcV8k6CaEmoiFnfwOc6OO6k4vEoqweBgHGTBCcWom54PVU5Ngtm54OXabbYjCRU2j0ZJNY1RmIphvD51yvwYlevB60A4tE20Yjgy22l3jZpoafjtjLarIBWDPe', 'invited', 'active', NULL, NULL, NULL, 8, 31, NULL, NULL, NULL, NULL, NULL), (12, 'IESTP GUALAMITA', 'gualamita@gmail.com', '56238965', '$2y$12$8vbWoq1y4e95iNTKZxNuYe1YVE7iix1Br9zdtmSZOt0Rb66c64.Nu', 0, NULL, '4Kjj2U0kAOOFuytS4b3YvWulMSz4eV5jpY6qR4nHdqslvFcEMT162CR9JvDqVntoGx0gWfHx1H29tkmy2Rph2p2NpkcBZehaxL3sV0xfAia1QOU0iHRY2AQWVpyEHdsBeQFYaNq34Da10HALJhIAMT', 'invited', 'active', NULL, NULL, NULL, 8, 29, NULL, NULL, NULL, NULL, NULL); -- ============================================================ -- ROL_USUARIO (M:M — rol primario de cada usuario) -- ============================================================ INSERT INTO rol_usuario (rol_id, user_id, domain_id) VALUES (1, 1, 2), -- ADMIN → SuperAdmin / domain 2 (8, 2, 23), -- GORE AMAZONAS → editor_sin_estado / domain 23 (8, 3, 16), -- FE Y ALEGRIA 74 / domain 16 (8, 4, 17), -- GELL LEYMEBAMBA / domain 17 (8, 5, 18), -- TSAMAJAIN / domain 18 (8, 6, 19), -- LONYA GRANDE / domain 19 (8, 7, 20), -- UTCUBAMBA / domain 20 (8, 8, 21), -- BAGUA / domain 21 (8, 9, 22), -- RODRIGUEZ DE MENDOZA / domain 22 (5, 10, 15), -- CARLOS TEVES → Postulante / domain 15 (8, 11, 31), -- LEVEL LEVEL / domain 31 (8, 12, 29); -- IESTP GUALAMITA / domain 29 -- ============================================================ -- ROL_PERMISO — qué ítems de menú puede ver cada rol/dominio -- Asigna los 54 permisos a cada combinación (rol, dominio) activa. -- CROSS JOIN: evita 648 filas manuales. -- ============================================================ INSERT INTO rol_permiso (idrol, idpermiso, domain_id, proyecto_id) SELECT combos.rol_id, p.id, combos.domain_id, NULL FROM permisos p CROSS JOIN ( SELECT 1 AS rol_id, 2 AS domain_id UNION ALL -- SuperAdmin / domain 2 SELECT 8, 16 UNION ALL -- editor_sin_estado / domain 16 SELECT 8, 17 UNION ALL -- / domain 17 SELECT 8, 18 UNION ALL -- / domain 18 SELECT 8, 19 UNION ALL -- / domain 19 SELECT 8, 20 UNION ALL -- / domain 20 SELECT 8, 21 UNION ALL -- / domain 21 SELECT 8, 22 UNION ALL -- / domain 22 SELECT 8, 23 UNION ALL -- / domain 23 SELECT 5, 15 UNION ALL -- Postulante / domain 15 SELECT 8, 31 UNION ALL -- / domain 31 SELECT 8, 29 -- / domain 29 ) AS combos; -- Total: 12 combinaciones × 54 permisos = 648 filas