-- Maestros desde docs/maestros.csv + perfil_profesor + rel_profesor_especialidad
-- Hash: Password1 (bcrypt)
-- fk_id_cat_tipo_usuario: 2 = Profesor

INSERT INTO usuarios (nombre, email, telefono, curp, hash_pass, fk_id_cat_tipo_usuario, activo, f_reg, f_mod, twofa_enabled, campass)
VALUES
  ('Aguilar de la Pascua Abril Yoali', 'abrila247@gmail.com', '5548798159', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Alcacer Camps Francisco', 'francescalcacer@gmail.com', '5534448749', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Alfonseca De la Cruz Ariadne', 'arialfonseca@gmail.com', '5559542827', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Amézquita Camacho Salvador Angel', 'salvador_amezquita@hotmail.com', '5591682182', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Ávila Pérez María Libertad', 'maria631936@gmail.com', '9513231246', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Balbuena Sánchez Jazmín Cinthya', 'jazminbal.cello@gmail.com', '5538803186', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Beteta David', 'davidcorteshernandezbeteta@gmail.com', '9516152143', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Beltrán Dingfelder Carolina', 'carobelding1@gmail.com', '5610758858', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('De Medina Eloísa', 'eloole_2000@yahoo.com', '5554005290', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Espinosa Caballero Ernesto Sebastián', 'sebastiancaballero.oficial30@gmail.com', '5551800070', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Eusebio García Dulce Evelyn', 'dulce-pianista.98@hotmail.com', '5574338641', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Orozco Viguri Germán', 'orozcovigurigerman@gmail.com', '5539226020', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Gómez Hidobro Daniel', 'huidooscuro@gmail.com', '5628220966', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Guiza Rodriguez Juan Manuel', 'manuelguiza@gmail.com', '5610868478', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Henry Silvie', 'konbit_music@yahoo.fr', '5554964202', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Huitrón Vega Ximena Arlen', 'ximenahuit@gmail.com', '5523350629', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('López Noble Mariana', 'marianelpez.18@gmail.com', '5517034904', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('López Araiza Guevara Mauricio', 'mauriciolopezaraizag@gmail.com', '5510805901', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Mondragón Morales María Fernanda', 'fernanda.morales34@hotmail.com', '5535277292', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Pardo Cristina', 'cristinapardor@gmail.com', '5522718337', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Quezada López Estefania Yesica Jocelin', 'yejoes@hotmail.com', '5579259883', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Rivera Flores Ulises Javier', 'ulisesdkm03@gmail.com', '5636151660', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Roaro Torres Narda', 'nardaroaro@hotmail.com', '4441936172', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Rojas Sánchez Rodrigo', 'ruyrojas@outlook.com', '5520294737', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Salas Gustavo', 'gusensal@yahoo.com', '5540638677', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Selley Alcaraz Nicolás', 'nicolasselley@gmail.com', '2411617519', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false),
  ('Tovar Nava Carlos', 'bancoderuido@gmail.com', '5635687303', NULL, '$2b$08$R.ACz5A8UIB9sDUl/bwU1.z85a.RDVf0QwQRtokdGnNJaimUgYhKW', 2, true, NOW(), NOW(), false, false);

-- perfil_profesor (especialidad = Instrumento del CSV). IDs 2..28 (27 profes, admin=1)
INSERT INTO perfil_profesor (fk_id_usuario, especialidad, activo) VALUES
  (2, 'Violín', true), (3, 'Guitarra', true), (4, 'Teatro y actuación', true), (5, 'Piano', true),
  (6, 'Saxofón', true), (7, 'Violonchelo', true), (8, 'Trompeta', true), (9, 'Arte terapia e hiperrealismo', true),
  (10, 'Directora General, percusión y piano', true), (11, 'Canto', true), (12, 'Iniciación musical y piano', true),
  (13, 'Pintura', true), (14, 'Batería', true), (15, 'Bajo, contrabajo, solfeo y armonía', true),
  (16, 'Canto', true), (17, 'Piano', true), (18, 'Piano', true), (19, 'Batería', true),
  (20, 'Canto', true), (21, 'Canto', true), (22, 'Canto', true), (23, 'Guitarra, ukulele', true),
  (24, 'Piano', true), (25, 'Piano composición', true), (26, 'Piano, canto, vibráfono, composición jazz, acordeon y teatro', true),
  (27, 'Piano', true), (28, 'Percusión Latina', true);

-- rel_profesor_especialidad (si existe la tabla)
INSERT INTO rel_profesor_especialidad (fk_id_profesor, especialidad)
SELECT fk_id_usuario, especialidad FROM perfil_profesor WHERE fk_id_usuario >= 2;
