-- ==========================================================
-- OPCIÓN 1: Inserta 6 horarios (Lunes a Sábado) para TODOS
-- los CURP en miembros_area_admin
-- ==========================================================
INSERT INTO horarios_fijos (CURP, dia_semana, hora_entrada, hora_salida)
SELECT m.curp,
	   d.dia_semana,
	   d.hora_entrada,
	   d.hora_salida
FROM miembros_area_admin m
CROSS JOIN (
	SELECT 'Lunes' AS dia_semana, '09:00:00' AS hora_entrada, '18:00:00' AS hora_salida
	UNION ALL SELECT 'Martes', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Miércoles', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Jueves', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Viernes', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Sábado', '09:00:00', '14:00:00'
) d;

-- ==========================================================
-- OPCIÓN 2: Inserta 5 horarios (Lunes a Viernes) para UN CURP
-- específico (cambia el valor de @curp_objetivo)
-- ==========================================================
SET @curp_objetivo = 'CUHL900504MYNRXS01';

INSERT INTO horarios_fijos (CURP, dia_semana, hora_entrada, hora_salida)
SELECT @curp_objetivo,
	   d.dia_semana,
	   d.hora_entrada,
	   d.hora_salida
FROM (
	SELECT 'Lunes' AS dia_semana, '09:00:00' AS hora_entrada, '18:00:00' AS hora_salida
	UNION ALL SELECT 'Martes', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Miércoles', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Jueves', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Viernes', '09:00:00', '18:00:00'
	UNION ALL SELECT 'Sábado', '09:00:00', '14:00:00'
) d;

-- Nota: ejecuta solo la opción que necesites para evitar inserciones duplicadas.
