-- Imports real data pulled directly from the legacy KHAIZEN Team Portal
-- (Google Apps Script web app, still live) via a headless-browser read
-- -- confirmed with the user, not assumed: (1) the schedule table's
-- Apr 20 - Dec 31 2026 shift roster for the 5 non-admin agents the
-- portal covers, and (2) ONLY the 5 currently-pending PTO requests as
-- real time_off_requests rows, per explicit user choice among three
-- options (full re-migration / pending-only / schedule-only) --
-- pending-only was chosen specifically so the approved/denied/revoked
-- history stays exactly where it already lives (time_off_balances.
-- pre_migration_used, seeded in 0040 from this same portal and cross-
-- checked live just before this migration was written -- every one of
-- the 9 agents' "Used" totals matched exactly, zero drift), rather than
-- double-counting it by also inserting 16 approved rows on top of a
-- number that already accounts for them.
--
-- One of the 6 pending requests scraped from the portal is deliberately
-- EXCLUDED: "Mon -- Sep 2-Aug 1, 2026 (0 day)" has an end date before
-- its start date -- a real data-entry error in the legacy tool itself
-- (which never validated the range), not a parsing mistake here. It
-- would fail time_off_requests' own `check (end_date >= start_date)`
-- constraint outright. Flagged to the user rather than guessing at
-- what the real intended dates were; not imported.
--
-- Shift codes (EARLY/LATE/SAT/OFF) are copied verbatim -- they're
-- already the exact same strings this app's own schedule.shift_code
-- convention uses (migration 0011), no translation needed. NSD never
-- actually appears in the live data despite being a selectable option.
--
-- Upserting on (shift_date, agent_id) is intentionally idempotent --
-- safe to re-run this file if needed, and bumps updated_at for every
-- row it touches. Known, accepted side effect: the next time Mon/
-- Jurina/Mayvel/Kate/Ruby Rose open Home, its notification feed (added
-- this session) will show a "Your schedule was updated" toast, capped
-- at the 14 nearest upcoming shifts by that feed's own query -- an
-- accurate, bounded confirmation that their schedule just got filled
-- in, not a bug.

insert into public.schedule (shift_date, agent_id, shift_code) values
('2026-04-20', 'mon', 'LATE'),
('2026-04-20', 'jurina', 'LATE'),
('2026-04-20', 'mayvel', 'EARLY'),
('2026-04-20', 'kate', 'EARLY'),
('2026-04-20', 'rubyrose', 'LATE'),
('2026-04-21', 'mon', 'LATE'),
('2026-04-21', 'jurina', 'LATE'),
('2026-04-21', 'mayvel', 'EARLY'),
('2026-04-21', 'kate', 'EARLY'),
('2026-04-21', 'rubyrose', 'LATE'),
('2026-04-22', 'mon', 'LATE'),
('2026-04-22', 'jurina', 'LATE'),
('2026-04-22', 'mayvel', 'EARLY'),
('2026-04-22', 'kate', 'EARLY'),
('2026-04-22', 'rubyrose', 'LATE'),
('2026-04-23', 'mon', 'LATE'),
('2026-04-23', 'jurina', 'LATE'),
('2026-04-23', 'mayvel', 'EARLY'),
('2026-04-23', 'kate', 'EARLY'),
('2026-04-23', 'rubyrose', 'LATE'),
('2026-04-24', 'mon', 'LATE'),
('2026-04-24', 'jurina', 'LATE'),
('2026-04-24', 'mayvel', 'EARLY'),
('2026-04-24', 'kate', 'EARLY'),
('2026-04-24', 'rubyrose', 'LATE'),
('2026-04-25', 'mon', 'OFF'),
('2026-04-25', 'jurina', 'OFF'),
('2026-04-25', 'mayvel', 'SAT'),
('2026-04-25', 'kate', 'SAT'),
('2026-04-25', 'rubyrose', 'OFF'),
('2026-04-27', 'mon', 'EARLY'),
('2026-04-27', 'jurina', 'EARLY'),
('2026-04-27', 'mayvel', 'LATE'),
('2026-04-27', 'kate', 'LATE'),
('2026-04-27', 'rubyrose', 'EARLY'),
('2026-04-28', 'mon', 'EARLY'),
('2026-04-28', 'jurina', 'EARLY'),
('2026-04-28', 'mayvel', 'LATE'),
('2026-04-28', 'kate', 'LATE'),
('2026-04-28', 'rubyrose', 'EARLY'),
('2026-04-29', 'mon', 'EARLY'),
('2026-04-29', 'jurina', 'EARLY'),
('2026-04-29', 'mayvel', 'LATE'),
('2026-04-29', 'kate', 'LATE'),
('2026-04-29', 'rubyrose', 'EARLY'),
('2026-04-30', 'mon', 'EARLY'),
('2026-04-30', 'jurina', 'EARLY'),
('2026-04-30', 'mayvel', 'LATE'),
('2026-04-30', 'kate', 'LATE'),
('2026-04-30', 'rubyrose', 'EARLY'),
('2026-05-01', 'mon', 'EARLY'),
('2026-05-01', 'jurina', 'EARLY'),
('2026-05-01', 'mayvel', 'LATE'),
('2026-05-01', 'kate', 'LATE'),
('2026-05-01', 'rubyrose', 'EARLY'),
('2026-05-02', 'mon', 'SAT'),
('2026-05-02', 'jurina', 'OFF'),
('2026-05-02', 'mayvel', 'OFF'),
('2026-05-02', 'kate', 'OFF'),
('2026-05-02', 'rubyrose', 'SAT'),
('2026-05-04', 'mon', 'LATE'),
('2026-05-04', 'jurina', 'EARLY'),
('2026-05-04', 'mayvel', 'EARLY'),
('2026-05-04', 'kate', 'EARLY'),
('2026-05-04', 'rubyrose', 'LATE'),
('2026-05-05', 'mon', 'LATE'),
('2026-05-05', 'jurina', 'EARLY'),
('2026-05-05', 'mayvel', 'EARLY'),
('2026-05-05', 'kate', 'EARLY'),
('2026-05-05', 'rubyrose', 'LATE'),
('2026-05-06', 'mon', 'LATE'),
('2026-05-06', 'jurina', 'EARLY'),
('2026-05-06', 'mayvel', 'EARLY'),
('2026-05-06', 'kate', 'EARLY'),
('2026-05-06', 'rubyrose', 'LATE'),
('2026-05-07', 'mon', 'LATE'),
('2026-05-07', 'jurina', 'EARLY'),
('2026-05-07', 'mayvel', 'EARLY'),
('2026-05-07', 'kate', 'EARLY'),
('2026-05-07', 'rubyrose', 'LATE'),
('2026-05-08', 'mon', 'LATE'),
('2026-05-08', 'jurina', 'EARLY'),
('2026-05-08', 'mayvel', 'EARLY'),
('2026-05-08', 'kate', 'EARLY'),
('2026-05-08', 'rubyrose', 'LATE'),
('2026-05-09', 'mon', 'OFF'),
('2026-05-09', 'jurina', 'SAT'),
('2026-05-09', 'mayvel', 'SAT'),
('2026-05-09', 'kate', 'OFF'),
('2026-05-09', 'rubyrose', 'OFF'),
('2026-05-11', 'mon', 'EARLY'),
('2026-05-11', 'jurina', 'EARLY'),
('2026-05-11', 'mayvel', 'LATE'),
('2026-05-11', 'kate', 'EARLY'),
('2026-05-11', 'rubyrose', 'EARLY'),
('2026-05-12', 'mon', 'EARLY'),
('2026-05-12', 'jurina', 'EARLY'),
('2026-05-12', 'mayvel', 'LATE'),
('2026-05-12', 'kate', 'EARLY'),
('2026-05-12', 'rubyrose', 'EARLY'),
('2026-05-13', 'mon', 'EARLY'),
('2026-05-13', 'jurina', 'EARLY'),
('2026-05-13', 'mayvel', 'LATE'),
('2026-05-13', 'kate', 'EARLY'),
('2026-05-13', 'rubyrose', 'EARLY'),
('2026-05-14', 'mon', 'EARLY'),
('2026-05-14', 'jurina', 'EARLY'),
('2026-05-14', 'mayvel', 'LATE'),
('2026-05-14', 'kate', 'EARLY'),
('2026-05-14', 'rubyrose', 'EARLY'),
('2026-05-15', 'mon', 'EARLY'),
('2026-05-15', 'jurina', 'EARLY'),
('2026-05-15', 'mayvel', 'LATE'),
('2026-05-15', 'kate', 'EARLY'),
('2026-05-15', 'rubyrose', 'EARLY'),
('2026-05-16', 'mon', 'OFF'),
('2026-05-16', 'jurina', 'OFF'),
('2026-05-16', 'mayvel', 'OFF'),
('2026-05-16', 'kate', 'SAT'),
('2026-05-16', 'rubyrose', 'SAT'),
('2026-05-18', 'mon', 'EARLY'),
('2026-05-18', 'jurina', 'EARLY'),
('2026-05-18', 'mayvel', 'EARLY'),
('2026-05-18', 'kate', 'EARLY'),
('2026-05-18', 'rubyrose', 'LATE'),
('2026-05-19', 'mon', 'EARLY'),
('2026-05-19', 'jurina', 'EARLY'),
('2026-05-19', 'mayvel', 'EARLY'),
('2026-05-19', 'kate', 'EARLY'),
('2026-05-19', 'rubyrose', 'LATE'),
('2026-05-20', 'mon', 'EARLY'),
('2026-05-20', 'jurina', 'EARLY'),
('2026-05-20', 'mayvel', 'EARLY'),
('2026-05-20', 'kate', 'EARLY'),
('2026-05-20', 'rubyrose', 'LATE'),
('2026-05-21', 'mon', 'EARLY'),
('2026-05-21', 'jurina', 'EARLY'),
('2026-05-21', 'mayvel', 'EARLY'),
('2026-05-21', 'kate', 'EARLY'),
('2026-05-21', 'rubyrose', 'LATE'),
('2026-05-22', 'mon', 'EARLY'),
('2026-05-22', 'jurina', 'EARLY'),
('2026-05-22', 'mayvel', 'EARLY'),
('2026-05-22', 'kate', 'EARLY'),
('2026-05-22', 'rubyrose', 'LATE'),
('2026-05-23', 'mon', 'SAT'),
('2026-05-23', 'jurina', 'SAT'),
('2026-05-23', 'mayvel', 'OFF'),
('2026-05-23', 'kate', 'OFF'),
('2026-05-23', 'rubyrose', 'OFF'),
('2026-05-25', 'mon', 'EARLY'),
('2026-05-25', 'jurina', 'EARLY'),
('2026-05-25', 'mayvel', 'EARLY'),
('2026-05-25', 'kate', 'EARLY'),
('2026-05-25', 'rubyrose', 'EARLY'),
('2026-05-26', 'mon', 'EARLY'),
('2026-05-26', 'jurina', 'EARLY'),
('2026-05-26', 'mayvel', 'EARLY'),
('2026-05-26', 'kate', 'EARLY'),
('2026-05-26', 'rubyrose', 'EARLY'),
('2026-05-27', 'mon', 'EARLY'),
('2026-05-27', 'jurina', 'EARLY'),
('2026-05-27', 'mayvel', 'EARLY'),
('2026-05-27', 'kate', 'EARLY'),
('2026-05-27', 'rubyrose', 'EARLY'),
('2026-05-28', 'mon', 'EARLY'),
('2026-05-28', 'jurina', 'EARLY'),
('2026-05-28', 'mayvel', 'EARLY'),
('2026-05-28', 'kate', 'EARLY'),
('2026-05-28', 'rubyrose', 'EARLY'),
('2026-05-29', 'mon', 'EARLY'),
('2026-05-29', 'jurina', 'EARLY'),
('2026-05-29', 'mayvel', 'EARLY'),
('2026-05-29', 'kate', 'EARLY'),
('2026-05-29', 'rubyrose', 'EARLY'),
('2026-05-30', 'mon', 'OFF'),
('2026-05-30', 'jurina', 'OFF'),
('2026-05-30', 'mayvel', 'SAT'),
('2026-05-30', 'kate', 'SAT'),
('2026-05-30', 'rubyrose', 'OFF'),
('2026-06-01', 'mon', 'EARLY'),
('2026-06-01', 'jurina', 'LATE'),
('2026-06-01', 'mayvel', 'EARLY'),
('2026-06-01', 'kate', 'EARLY'),
('2026-06-01', 'rubyrose', 'EARLY'),
('2026-06-02', 'mon', 'EARLY'),
('2026-06-02', 'jurina', 'LATE'),
('2026-06-02', 'mayvel', 'EARLY'),
('2026-06-02', 'kate', 'EARLY'),
('2026-06-02', 'rubyrose', 'EARLY'),
('2026-06-03', 'mon', 'EARLY'),
('2026-06-03', 'jurina', 'LATE'),
('2026-06-03', 'mayvel', 'EARLY'),
('2026-06-03', 'kate', 'EARLY'),
('2026-06-03', 'rubyrose', 'EARLY'),
('2026-06-04', 'mon', 'EARLY'),
('2026-06-04', 'jurina', 'LATE'),
('2026-06-04', 'mayvel', 'EARLY'),
('2026-06-04', 'kate', 'EARLY'),
('2026-06-04', 'rubyrose', 'EARLY'),
('2026-06-05', 'mon', 'EARLY'),
('2026-06-05', 'jurina', 'LATE'),
('2026-06-05', 'mayvel', 'EARLY'),
('2026-06-05', 'kate', 'EARLY'),
('2026-06-05', 'rubyrose', 'EARLY'),
('2026-06-06', 'mon', 'SAT'),
('2026-06-06', 'jurina', 'OFF'),
('2026-06-06', 'mayvel', 'OFF'),
('2026-06-06', 'kate', 'OFF'),
('2026-06-06', 'rubyrose', 'SAT'),
('2026-06-08', 'mon', 'EARLY'),
('2026-06-08', 'jurina', 'EARLY'),
('2026-06-08', 'mayvel', 'EARLY'),
('2026-06-08', 'kate', 'LATE'),
('2026-06-08', 'rubyrose', 'EARLY'),
('2026-06-09', 'mon', 'EARLY'),
('2026-06-09', 'jurina', 'EARLY'),
('2026-06-09', 'mayvel', 'EARLY'),
('2026-06-09', 'kate', 'LATE'),
('2026-06-09', 'rubyrose', 'EARLY'),
('2026-06-10', 'mon', 'EARLY'),
('2026-06-10', 'jurina', 'EARLY'),
('2026-06-10', 'mayvel', 'EARLY'),
('2026-06-10', 'kate', 'LATE'),
('2026-06-10', 'rubyrose', 'EARLY'),
('2026-06-11', 'mon', 'EARLY'),
('2026-06-11', 'jurina', 'EARLY'),
('2026-06-11', 'mayvel', 'EARLY'),
('2026-06-11', 'kate', 'LATE'),
('2026-06-11', 'rubyrose', 'EARLY'),
('2026-06-12', 'mon', 'EARLY'),
('2026-06-12', 'jurina', 'EARLY'),
('2026-06-12', 'mayvel', 'EARLY'),
('2026-06-12', 'kate', 'LATE'),
('2026-06-12', 'rubyrose', 'EARLY'),
('2026-06-13', 'mon', 'OFF'),
('2026-06-13', 'jurina', 'SAT'),
('2026-06-13', 'mayvel', 'SAT'),
('2026-06-13', 'kate', 'OFF'),
('2026-06-13', 'rubyrose', 'OFF'),
('2026-06-15', 'mon', 'LATE'),
('2026-06-15', 'jurina', 'LATE'),
('2026-06-15', 'mayvel', 'EARLY'),
('2026-06-15', 'kate', 'EARLY'),
('2026-06-15', 'rubyrose', 'EARLY'),
('2026-06-16', 'mon', 'LATE'),
('2026-06-16', 'jurina', 'LATE'),
('2026-06-16', 'mayvel', 'EARLY'),
('2026-06-16', 'kate', 'EARLY'),
('2026-06-16', 'rubyrose', 'EARLY'),
('2026-06-17', 'mon', 'LATE'),
('2026-06-17', 'jurina', 'LATE'),
('2026-06-17', 'mayvel', 'EARLY'),
('2026-06-17', 'kate', 'EARLY'),
('2026-06-17', 'rubyrose', 'EARLY'),
('2026-06-18', 'mon', 'LATE'),
('2026-06-18', 'jurina', 'LATE'),
('2026-06-18', 'mayvel', 'EARLY'),
('2026-06-18', 'kate', 'EARLY'),
('2026-06-18', 'rubyrose', 'EARLY'),
('2026-06-19', 'mon', 'LATE'),
('2026-06-19', 'jurina', 'LATE'),
('2026-06-19', 'mayvel', 'EARLY'),
('2026-06-19', 'kate', 'EARLY'),
('2026-06-19', 'rubyrose', 'EARLY'),
('2026-06-20', 'mon', 'OFF'),
('2026-06-20', 'jurina', 'OFF'),
('2026-06-20', 'mayvel', 'OFF'),
('2026-06-20', 'kate', 'SAT'),
('2026-06-20', 'rubyrose', 'SAT'),
('2026-06-22', 'mon', 'EARLY'),
('2026-06-22', 'jurina', 'EARLY'),
('2026-06-22', 'mayvel', 'LATE'),
('2026-06-22', 'kate', 'LATE'),
('2026-06-22', 'rubyrose', 'EARLY'),
('2026-06-23', 'mon', 'EARLY'),
('2026-06-23', 'jurina', 'EARLY'),
('2026-06-23', 'mayvel', 'LATE'),
('2026-06-23', 'kate', 'LATE'),
('2026-06-23', 'rubyrose', 'EARLY'),
('2026-06-24', 'mon', 'EARLY'),
('2026-06-24', 'jurina', 'EARLY'),
('2026-06-24', 'mayvel', 'LATE'),
('2026-06-24', 'kate', 'LATE'),
('2026-06-24', 'rubyrose', 'EARLY'),
('2026-06-25', 'mon', 'EARLY'),
('2026-06-25', 'jurina', 'EARLY'),
('2026-06-25', 'mayvel', 'LATE'),
('2026-06-25', 'kate', 'LATE'),
('2026-06-25', 'rubyrose', 'EARLY'),
('2026-06-26', 'mon', 'EARLY'),
('2026-06-26', 'jurina', 'EARLY'),
('2026-06-26', 'mayvel', 'LATE'),
('2026-06-26', 'kate', 'LATE'),
('2026-06-26', 'rubyrose', 'EARLY'),
('2026-06-27', 'mon', 'SAT'),
('2026-06-27', 'jurina', 'SAT'),
('2026-06-27', 'mayvel', 'OFF'),
('2026-06-27', 'kate', 'OFF'),
('2026-06-27', 'rubyrose', 'OFF'),
('2026-06-29', 'mon', 'LATE'),
('2026-06-29', 'jurina', 'LATE'),
('2026-06-29', 'mayvel', 'EARLY'),
('2026-06-29', 'kate', 'EARLY'),
('2026-06-29', 'rubyrose', 'LATE'),
('2026-06-30', 'mon', 'LATE'),
('2026-06-30', 'jurina', 'LATE'),
('2026-06-30', 'mayvel', 'EARLY'),
('2026-06-30', 'kate', 'EARLY'),
('2026-06-30', 'rubyrose', 'LATE'),
('2026-07-01', 'mon', 'LATE'),
('2026-07-01', 'jurina', 'LATE'),
('2026-07-01', 'mayvel', 'EARLY'),
('2026-07-01', 'kate', 'EARLY'),
('2026-07-01', 'rubyrose', 'LATE'),
('2026-07-02', 'mon', 'LATE'),
('2026-07-02', 'jurina', 'LATE'),
('2026-07-02', 'mayvel', 'EARLY'),
('2026-07-02', 'kate', 'EARLY'),
('2026-07-02', 'rubyrose', 'LATE'),
('2026-07-03', 'mon', 'LATE'),
('2026-07-03', 'jurina', 'LATE'),
('2026-07-03', 'mayvel', 'EARLY'),
('2026-07-03', 'kate', 'EARLY'),
('2026-07-03', 'rubyrose', 'LATE'),
('2026-07-04', 'mon', 'OFF'),
('2026-07-04', 'jurina', 'OFF'),
('2026-07-04', 'mayvel', 'SAT'),
('2026-07-04', 'kate', 'SAT'),
('2026-07-04', 'rubyrose', 'OFF'),
('2026-07-06', 'mon', 'EARLY'),
('2026-07-06', 'jurina', 'EARLY'),
('2026-07-06', 'mayvel', 'LATE'),
('2026-07-06', 'kate', 'LATE'),
('2026-07-06', 'rubyrose', 'EARLY'),
('2026-07-07', 'mon', 'EARLY'),
('2026-07-07', 'jurina', 'EARLY'),
('2026-07-07', 'mayvel', 'LATE'),
('2026-07-07', 'kate', 'LATE'),
('2026-07-07', 'rubyrose', 'EARLY'),
('2026-07-08', 'mon', 'EARLY'),
('2026-07-08', 'jurina', 'EARLY'),
('2026-07-08', 'mayvel', 'LATE'),
('2026-07-08', 'kate', 'LATE'),
('2026-07-08', 'rubyrose', 'EARLY'),
('2026-07-09', 'mon', 'EARLY'),
('2026-07-09', 'jurina', 'EARLY'),
('2026-07-09', 'mayvel', 'LATE'),
('2026-07-09', 'kate', 'LATE'),
('2026-07-09', 'rubyrose', 'EARLY'),
('2026-07-10', 'mon', 'EARLY'),
('2026-07-10', 'jurina', 'EARLY'),
('2026-07-10', 'mayvel', 'LATE'),
('2026-07-10', 'kate', 'LATE'),
('2026-07-10', 'rubyrose', 'EARLY'),
('2026-07-11', 'mon', 'SAT'),
('2026-07-11', 'jurina', 'OFF'),
('2026-07-11', 'mayvel', 'OFF'),
('2026-07-11', 'kate', 'OFF'),
('2026-07-11', 'rubyrose', 'SAT'),
('2026-07-13', 'mon', 'LATE'),
('2026-07-13', 'jurina', 'EARLY'),
('2026-07-13', 'mayvel', 'EARLY'),
('2026-07-13', 'kate', 'EARLY'),
('2026-07-13', 'rubyrose', 'LATE'),
('2026-07-14', 'mon', 'LATE'),
('2026-07-14', 'jurina', 'EARLY'),
('2026-07-14', 'mayvel', 'EARLY'),
('2026-07-14', 'kate', 'EARLY'),
('2026-07-14', 'rubyrose', 'LATE'),
('2026-07-15', 'mon', 'LATE'),
('2026-07-15', 'jurina', 'EARLY'),
('2026-07-15', 'mayvel', 'EARLY'),
('2026-07-15', 'kate', 'EARLY'),
('2026-07-15', 'rubyrose', 'LATE'),
('2026-07-16', 'mon', 'LATE'),
('2026-07-16', 'jurina', 'EARLY'),
('2026-07-16', 'mayvel', 'EARLY'),
('2026-07-16', 'kate', 'EARLY'),
('2026-07-16', 'rubyrose', 'LATE'),
('2026-07-17', 'mon', 'LATE'),
('2026-07-17', 'jurina', 'EARLY'),
('2026-07-17', 'mayvel', 'EARLY'),
('2026-07-17', 'kate', 'EARLY'),
('2026-07-17', 'rubyrose', 'LATE'),
('2026-07-18', 'mon', 'OFF'),
('2026-07-18', 'jurina', 'SAT'),
('2026-07-18', 'mayvel', 'SAT'),
('2026-07-18', 'kate', 'OFF'),
('2026-07-18', 'rubyrose', 'OFF'),
('2026-07-20', 'mon', 'EARLY'),
('2026-07-20', 'jurina', 'EARLY'),
('2026-07-20', 'mayvel', 'LATE'),
('2026-07-20', 'kate', 'EARLY'),
('2026-07-20', 'rubyrose', 'EARLY'),
('2026-07-21', 'mon', 'EARLY'),
('2026-07-21', 'jurina', 'EARLY'),
('2026-07-21', 'mayvel', 'LATE'),
('2026-07-21', 'kate', 'EARLY'),
('2026-07-21', 'rubyrose', 'EARLY'),
('2026-07-22', 'mon', 'EARLY'),
('2026-07-22', 'jurina', 'EARLY'),
('2026-07-22', 'mayvel', 'LATE'),
('2026-07-22', 'kate', 'EARLY'),
('2026-07-22', 'rubyrose', 'EARLY'),
('2026-07-23', 'mon', 'EARLY'),
('2026-07-23', 'jurina', 'EARLY'),
('2026-07-23', 'mayvel', 'LATE'),
('2026-07-23', 'kate', 'EARLY'),
('2026-07-23', 'rubyrose', 'EARLY'),
('2026-07-24', 'mon', 'EARLY'),
('2026-07-24', 'jurina', 'EARLY'),
('2026-07-24', 'mayvel', 'LATE'),
('2026-07-24', 'kate', 'EARLY'),
('2026-07-24', 'rubyrose', 'EARLY'),
('2026-07-25', 'mon', 'OFF'),
('2026-07-25', 'jurina', 'OFF'),
('2026-07-25', 'mayvel', 'OFF'),
('2026-07-25', 'kate', 'SAT'),
('2026-07-25', 'rubyrose', 'SAT'),
('2026-07-27', 'mon', 'EARLY'),
('2026-07-27', 'jurina', 'EARLY'),
('2026-07-27', 'mayvel', 'EARLY'),
('2026-07-27', 'kate', 'EARLY'),
('2026-07-27', 'rubyrose', 'LATE'),
('2026-07-28', 'mon', 'EARLY'),
('2026-07-28', 'jurina', 'EARLY'),
('2026-07-28', 'mayvel', 'EARLY'),
('2026-07-28', 'kate', 'EARLY'),
('2026-07-28', 'rubyrose', 'LATE'),
('2026-07-29', 'mon', 'EARLY'),
('2026-07-29', 'jurina', 'EARLY'),
('2026-07-29', 'mayvel', 'EARLY'),
('2026-07-29', 'kate', 'EARLY'),
('2026-07-29', 'rubyrose', 'LATE'),
('2026-07-30', 'mon', 'EARLY'),
('2026-07-30', 'jurina', 'EARLY'),
('2026-07-30', 'mayvel', 'EARLY'),
('2026-07-30', 'kate', 'EARLY'),
('2026-07-30', 'rubyrose', 'LATE'),
('2026-07-31', 'mon', 'EARLY'),
('2026-07-31', 'jurina', 'EARLY'),
('2026-07-31', 'mayvel', 'EARLY'),
('2026-07-31', 'kate', 'EARLY'),
('2026-07-31', 'rubyrose', 'LATE'),
('2026-08-01', 'mon', 'SAT'),
('2026-08-01', 'jurina', 'SAT'),
('2026-08-01', 'mayvel', 'OFF'),
('2026-08-01', 'kate', 'OFF'),
('2026-08-01', 'rubyrose', 'OFF'),
('2026-08-03', 'mon', 'EARLY'),
('2026-08-03', 'jurina', 'EARLY'),
('2026-08-03', 'mayvel', 'EARLY'),
('2026-08-03', 'kate', 'EARLY'),
('2026-08-03', 'rubyrose', 'EARLY'),
('2026-08-04', 'mon', 'EARLY'),
('2026-08-04', 'jurina', 'EARLY'),
('2026-08-04', 'mayvel', 'EARLY'),
('2026-08-04', 'kate', 'EARLY'),
('2026-08-04', 'rubyrose', 'EARLY'),
('2026-08-05', 'mon', 'EARLY'),
('2026-08-05', 'jurina', 'EARLY'),
('2026-08-05', 'mayvel', 'EARLY'),
('2026-08-05', 'kate', 'EARLY'),
('2026-08-05', 'rubyrose', 'EARLY'),
('2026-08-06', 'mon', 'EARLY'),
('2026-08-06', 'jurina', 'EARLY'),
('2026-08-06', 'mayvel', 'EARLY'),
('2026-08-06', 'kate', 'EARLY'),
('2026-08-06', 'rubyrose', 'EARLY'),
('2026-08-07', 'mon', 'EARLY'),
('2026-08-07', 'jurina', 'EARLY'),
('2026-08-07', 'mayvel', 'EARLY'),
('2026-08-07', 'kate', 'EARLY'),
('2026-08-07', 'rubyrose', 'EARLY'),
('2026-08-08', 'mon', 'OFF'),
('2026-08-08', 'jurina', 'OFF'),
('2026-08-08', 'mayvel', 'SAT'),
('2026-08-08', 'kate', 'SAT'),
('2026-08-08', 'rubyrose', 'OFF'),
('2026-08-10', 'mon', 'EARLY'),
('2026-08-10', 'jurina', 'LATE'),
('2026-08-10', 'mayvel', 'EARLY'),
('2026-08-10', 'kate', 'EARLY'),
('2026-08-10', 'rubyrose', 'EARLY'),
('2026-08-11', 'mon', 'EARLY'),
('2026-08-11', 'jurina', 'LATE'),
('2026-08-11', 'mayvel', 'EARLY'),
('2026-08-11', 'kate', 'EARLY'),
('2026-08-11', 'rubyrose', 'EARLY'),
('2026-08-12', 'mon', 'EARLY'),
('2026-08-12', 'jurina', 'LATE'),
('2026-08-12', 'mayvel', 'EARLY'),
('2026-08-12', 'kate', 'EARLY'),
('2026-08-12', 'rubyrose', 'EARLY'),
('2026-08-13', 'mon', 'EARLY'),
('2026-08-13', 'jurina', 'LATE'),
('2026-08-13', 'mayvel', 'EARLY'),
('2026-08-13', 'kate', 'EARLY'),
('2026-08-13', 'rubyrose', 'EARLY'),
('2026-08-14', 'mon', 'EARLY'),
('2026-08-14', 'jurina', 'LATE'),
('2026-08-14', 'mayvel', 'EARLY'),
('2026-08-14', 'kate', 'EARLY'),
('2026-08-14', 'rubyrose', 'EARLY'),
('2026-08-15', 'mon', 'SAT'),
('2026-08-15', 'jurina', 'OFF'),
('2026-08-15', 'mayvel', 'OFF'),
('2026-08-15', 'kate', 'OFF'),
('2026-08-15', 'rubyrose', 'SAT'),
('2026-08-17', 'mon', 'EARLY'),
('2026-08-17', 'jurina', 'EARLY'),
('2026-08-17', 'mayvel', 'EARLY'),
('2026-08-17', 'kate', 'LATE'),
('2026-08-17', 'rubyrose', 'EARLY'),
('2026-08-18', 'mon', 'EARLY'),
('2026-08-18', 'jurina', 'EARLY'),
('2026-08-18', 'mayvel', 'EARLY'),
('2026-08-18', 'kate', 'LATE'),
('2026-08-18', 'rubyrose', 'EARLY'),
('2026-08-19', 'mon', 'EARLY'),
('2026-08-19', 'jurina', 'EARLY'),
('2026-08-19', 'mayvel', 'EARLY'),
('2026-08-19', 'kate', 'LATE'),
('2026-08-19', 'rubyrose', 'EARLY'),
('2026-08-20', 'mon', 'EARLY'),
('2026-08-20', 'jurina', 'EARLY'),
('2026-08-20', 'mayvel', 'EARLY'),
('2026-08-20', 'kate', 'LATE'),
('2026-08-20', 'rubyrose', 'EARLY'),
('2026-08-21', 'mon', 'EARLY'),
('2026-08-21', 'jurina', 'EARLY'),
('2026-08-21', 'mayvel', 'EARLY'),
('2026-08-21', 'kate', 'LATE'),
('2026-08-21', 'rubyrose', 'EARLY'),
('2026-08-22', 'mon', 'OFF'),
('2026-08-22', 'jurina', 'SAT'),
('2026-08-22', 'mayvel', 'SAT'),
('2026-08-22', 'kate', 'OFF'),
('2026-08-22', 'rubyrose', 'OFF'),
('2026-08-24', 'mon', 'LATE'),
('2026-08-24', 'jurina', 'LATE'),
('2026-08-24', 'mayvel', 'EARLY'),
('2026-08-24', 'kate', 'EARLY'),
('2026-08-24', 'rubyrose', 'EARLY'),
('2026-08-25', 'mon', 'LATE'),
('2026-08-25', 'jurina', 'LATE'),
('2026-08-25', 'mayvel', 'EARLY'),
('2026-08-25', 'kate', 'EARLY'),
('2026-08-25', 'rubyrose', 'EARLY'),
('2026-08-26', 'mon', 'LATE'),
('2026-08-26', 'jurina', 'LATE'),
('2026-08-26', 'mayvel', 'EARLY'),
('2026-08-26', 'kate', 'EARLY'),
('2026-08-26', 'rubyrose', 'EARLY'),
('2026-08-27', 'mon', 'LATE'),
('2026-08-27', 'jurina', 'LATE'),
('2026-08-27', 'mayvel', 'EARLY'),
('2026-08-27', 'kate', 'EARLY'),
('2026-08-27', 'rubyrose', 'EARLY'),
('2026-08-28', 'mon', 'LATE'),
('2026-08-28', 'jurina', 'LATE'),
('2026-08-28', 'mayvel', 'EARLY'),
('2026-08-28', 'kate', 'EARLY'),
('2026-08-28', 'rubyrose', 'EARLY'),
('2026-08-29', 'mon', 'OFF'),
('2026-08-29', 'jurina', 'OFF'),
('2026-08-29', 'mayvel', 'OFF'),
('2026-08-29', 'kate', 'SAT'),
('2026-08-29', 'rubyrose', 'SAT'),
('2026-08-31', 'mon', 'EARLY'),
('2026-08-31', 'jurina', 'EARLY'),
('2026-08-31', 'mayvel', 'LATE'),
('2026-08-31', 'kate', 'LATE'),
('2026-08-31', 'rubyrose', 'EARLY'),
('2026-09-01', 'mon', 'EARLY'),
('2026-09-01', 'jurina', 'EARLY'),
('2026-09-01', 'mayvel', 'LATE'),
('2026-09-01', 'kate', 'LATE'),
('2026-09-01', 'rubyrose', 'EARLY'),
('2026-09-02', 'mon', 'EARLY'),
('2026-09-02', 'jurina', 'EARLY'),
('2026-09-02', 'mayvel', 'LATE'),
('2026-09-02', 'kate', 'LATE'),
('2026-09-02', 'rubyrose', 'EARLY'),
('2026-09-03', 'mon', 'EARLY'),
('2026-09-03', 'jurina', 'EARLY'),
('2026-09-03', 'mayvel', 'LATE'),
('2026-09-03', 'kate', 'LATE'),
('2026-09-03', 'rubyrose', 'EARLY'),
('2026-09-04', 'mon', 'EARLY'),
('2026-09-04', 'jurina', 'EARLY'),
('2026-09-04', 'mayvel', 'LATE'),
('2026-09-04', 'kate', 'LATE'),
('2026-09-04', 'rubyrose', 'EARLY'),
('2026-09-05', 'mon', 'SAT'),
('2026-09-05', 'jurina', 'SAT'),
('2026-09-05', 'mayvel', 'OFF'),
('2026-09-05', 'kate', 'OFF'),
('2026-09-05', 'rubyrose', 'OFF'),
('2026-09-07', 'mon', 'LATE'),
('2026-09-07', 'jurina', 'LATE'),
('2026-09-07', 'mayvel', 'EARLY'),
('2026-09-07', 'kate', 'EARLY'),
('2026-09-07', 'rubyrose', 'LATE'),
('2026-09-08', 'mon', 'LATE'),
('2026-09-08', 'jurina', 'LATE'),
('2026-09-08', 'mayvel', 'EARLY'),
('2026-09-08', 'kate', 'EARLY'),
('2026-09-08', 'rubyrose', 'LATE'),
('2026-09-09', 'mon', 'LATE'),
('2026-09-09', 'jurina', 'LATE'),
('2026-09-09', 'mayvel', 'EARLY'),
('2026-09-09', 'kate', 'EARLY'),
('2026-09-09', 'rubyrose', 'LATE'),
('2026-09-10', 'mon', 'LATE'),
('2026-09-10', 'jurina', 'LATE'),
('2026-09-10', 'mayvel', 'EARLY'),
('2026-09-10', 'kate', 'EARLY'),
('2026-09-10', 'rubyrose', 'LATE'),
('2026-09-11', 'mon', 'LATE'),
('2026-09-11', 'jurina', 'LATE'),
('2026-09-11', 'mayvel', 'EARLY'),
('2026-09-11', 'kate', 'EARLY'),
('2026-09-11', 'rubyrose', 'LATE'),
('2026-09-12', 'mon', 'OFF'),
('2026-09-12', 'jurina', 'OFF'),
('2026-09-12', 'mayvel', 'SAT'),
('2026-09-12', 'kate', 'SAT'),
('2026-09-12', 'rubyrose', 'OFF'),
('2026-09-14', 'mon', 'EARLY'),
('2026-09-14', 'jurina', 'EARLY'),
('2026-09-14', 'mayvel', 'LATE'),
('2026-09-14', 'kate', 'LATE'),
('2026-09-14', 'rubyrose', 'EARLY'),
('2026-09-15', 'mon', 'EARLY'),
('2026-09-15', 'jurina', 'EARLY'),
('2026-09-15', 'mayvel', 'LATE'),
('2026-09-15', 'kate', 'LATE'),
('2026-09-15', 'rubyrose', 'EARLY'),
('2026-09-16', 'mon', 'EARLY'),
('2026-09-16', 'jurina', 'EARLY'),
('2026-09-16', 'mayvel', 'LATE'),
('2026-09-16', 'kate', 'LATE'),
('2026-09-16', 'rubyrose', 'EARLY'),
('2026-09-17', 'mon', 'EARLY'),
('2026-09-17', 'jurina', 'EARLY'),
('2026-09-17', 'mayvel', 'LATE'),
('2026-09-17', 'kate', 'LATE'),
('2026-09-17', 'rubyrose', 'EARLY'),
('2026-09-18', 'mon', 'EARLY'),
('2026-09-18', 'jurina', 'EARLY'),
('2026-09-18', 'mayvel', 'LATE'),
('2026-09-18', 'kate', 'LATE'),
('2026-09-18', 'rubyrose', 'EARLY'),
('2026-09-19', 'mon', 'SAT'),
('2026-09-19', 'jurina', 'OFF'),
('2026-09-19', 'mayvel', 'OFF'),
('2026-09-19', 'kate', 'OFF'),
('2026-09-19', 'rubyrose', 'SAT'),
('2026-09-21', 'mon', 'LATE'),
('2026-09-21', 'jurina', 'EARLY'),
('2026-09-21', 'mayvel', 'EARLY'),
('2026-09-21', 'kate', 'EARLY'),
('2026-09-21', 'rubyrose', 'LATE'),
('2026-09-22', 'mon', 'LATE'),
('2026-09-22', 'jurina', 'EARLY'),
('2026-09-22', 'mayvel', 'EARLY'),
('2026-09-22', 'kate', 'EARLY'),
('2026-09-22', 'rubyrose', 'LATE'),
('2026-09-23', 'mon', 'LATE'),
('2026-09-23', 'jurina', 'EARLY'),
('2026-09-23', 'mayvel', 'EARLY'),
('2026-09-23', 'kate', 'EARLY'),
('2026-09-23', 'rubyrose', 'LATE'),
('2026-09-24', 'mon', 'LATE'),
('2026-09-24', 'jurina', 'EARLY'),
('2026-09-24', 'mayvel', 'EARLY'),
('2026-09-24', 'kate', 'EARLY'),
('2026-09-24', 'rubyrose', 'LATE'),
('2026-09-25', 'mon', 'LATE'),
('2026-09-25', 'jurina', 'EARLY'),
('2026-09-25', 'mayvel', 'EARLY'),
('2026-09-25', 'kate', 'EARLY'),
('2026-09-25', 'rubyrose', 'LATE'),
('2026-09-26', 'mon', 'OFF'),
('2026-09-26', 'jurina', 'SAT'),
('2026-09-26', 'mayvel', 'SAT'),
('2026-09-26', 'kate', 'OFF'),
('2026-09-26', 'rubyrose', 'OFF'),
('2026-09-28', 'mon', 'EARLY'),
('2026-09-28', 'jurina', 'EARLY'),
('2026-09-28', 'mayvel', 'LATE'),
('2026-09-28', 'kate', 'EARLY'),
('2026-09-28', 'rubyrose', 'EARLY'),
('2026-09-29', 'mon', 'EARLY'),
('2026-09-29', 'jurina', 'EARLY'),
('2026-09-29', 'mayvel', 'LATE'),
('2026-09-29', 'kate', 'EARLY'),
('2026-09-29', 'rubyrose', 'EARLY'),
('2026-09-30', 'mon', 'EARLY'),
('2026-09-30', 'jurina', 'EARLY'),
('2026-09-30', 'mayvel', 'LATE'),
('2026-09-30', 'kate', 'EARLY'),
('2026-09-30', 'rubyrose', 'EARLY'),
('2026-10-01', 'mon', 'EARLY'),
('2026-10-01', 'jurina', 'EARLY'),
('2026-10-01', 'mayvel', 'LATE'),
('2026-10-01', 'kate', 'EARLY'),
('2026-10-01', 'rubyrose', 'EARLY'),
('2026-10-02', 'mon', 'EARLY'),
('2026-10-02', 'jurina', 'EARLY'),
('2026-10-02', 'mayvel', 'LATE'),
('2026-10-02', 'kate', 'EARLY'),
('2026-10-02', 'rubyrose', 'EARLY'),
('2026-10-03', 'mon', 'OFF'),
('2026-10-03', 'jurina', 'OFF'),
('2026-10-03', 'mayvel', 'OFF'),
('2026-10-03', 'kate', 'SAT'),
('2026-10-03', 'rubyrose', 'SAT'),
('2026-10-05', 'mon', 'EARLY'),
('2026-10-05', 'jurina', 'EARLY'),
('2026-10-05', 'mayvel', 'EARLY'),
('2026-10-05', 'kate', 'EARLY'),
('2026-10-05', 'rubyrose', 'LATE'),
('2026-10-06', 'mon', 'EARLY'),
('2026-10-06', 'jurina', 'EARLY'),
('2026-10-06', 'mayvel', 'EARLY'),
('2026-10-06', 'kate', 'EARLY'),
('2026-10-06', 'rubyrose', 'LATE'),
('2026-10-07', 'mon', 'EARLY'),
('2026-10-07', 'jurina', 'EARLY'),
('2026-10-07', 'mayvel', 'EARLY'),
('2026-10-07', 'kate', 'EARLY'),
('2026-10-07', 'rubyrose', 'LATE'),
('2026-10-08', 'mon', 'EARLY'),
('2026-10-08', 'jurina', 'EARLY'),
('2026-10-08', 'mayvel', 'EARLY'),
('2026-10-08', 'kate', 'EARLY'),
('2026-10-08', 'rubyrose', 'LATE'),
('2026-10-09', 'mon', 'EARLY'),
('2026-10-09', 'jurina', 'EARLY'),
('2026-10-09', 'mayvel', 'EARLY'),
('2026-10-09', 'kate', 'EARLY'),
('2026-10-09', 'rubyrose', 'LATE'),
('2026-10-10', 'mon', 'SAT'),
('2026-10-10', 'jurina', 'SAT'),
('2026-10-10', 'mayvel', 'OFF'),
('2026-10-10', 'kate', 'OFF'),
('2026-10-10', 'rubyrose', 'OFF'),
('2026-10-12', 'mon', 'EARLY'),
('2026-10-12', 'jurina', 'EARLY'),
('2026-10-12', 'mayvel', 'EARLY'),
('2026-10-12', 'kate', 'EARLY'),
('2026-10-12', 'rubyrose', 'EARLY'),
('2026-10-13', 'mon', 'EARLY'),
('2026-10-13', 'jurina', 'EARLY'),
('2026-10-13', 'mayvel', 'EARLY'),
('2026-10-13', 'kate', 'EARLY'),
('2026-10-13', 'rubyrose', 'EARLY'),
('2026-10-14', 'mon', 'EARLY'),
('2026-10-14', 'jurina', 'EARLY'),
('2026-10-14', 'mayvel', 'EARLY'),
('2026-10-14', 'kate', 'EARLY'),
('2026-10-14', 'rubyrose', 'EARLY'),
('2026-10-15', 'mon', 'EARLY'),
('2026-10-15', 'jurina', 'EARLY'),
('2026-10-15', 'mayvel', 'EARLY'),
('2026-10-15', 'kate', 'EARLY'),
('2026-10-15', 'rubyrose', 'EARLY'),
('2026-10-16', 'mon', 'EARLY'),
('2026-10-16', 'jurina', 'EARLY'),
('2026-10-16', 'mayvel', 'EARLY'),
('2026-10-16', 'kate', 'EARLY'),
('2026-10-16', 'rubyrose', 'EARLY'),
('2026-10-17', 'mon', 'OFF'),
('2026-10-17', 'jurina', 'OFF'),
('2026-10-17', 'mayvel', 'SAT'),
('2026-10-17', 'kate', 'SAT'),
('2026-10-17', 'rubyrose', 'OFF'),
('2026-10-19', 'mon', 'EARLY'),
('2026-10-19', 'jurina', 'LATE'),
('2026-10-19', 'mayvel', 'EARLY'),
('2026-10-19', 'kate', 'EARLY'),
('2026-10-19', 'rubyrose', 'EARLY'),
('2026-10-20', 'mon', 'EARLY'),
('2026-10-20', 'jurina', 'LATE'),
('2026-10-20', 'mayvel', 'EARLY'),
('2026-10-20', 'kate', 'EARLY'),
('2026-10-20', 'rubyrose', 'EARLY'),
('2026-10-21', 'mon', 'EARLY'),
('2026-10-21', 'jurina', 'LATE'),
('2026-10-21', 'mayvel', 'EARLY'),
('2026-10-21', 'kate', 'EARLY'),
('2026-10-21', 'rubyrose', 'EARLY'),
('2026-10-22', 'mon', 'EARLY'),
('2026-10-22', 'jurina', 'LATE'),
('2026-10-22', 'mayvel', 'EARLY'),
('2026-10-22', 'kate', 'EARLY'),
('2026-10-22', 'rubyrose', 'EARLY'),
('2026-10-23', 'mon', 'EARLY'),
('2026-10-23', 'jurina', 'LATE'),
('2026-10-23', 'mayvel', 'EARLY'),
('2026-10-23', 'kate', 'EARLY'),
('2026-10-23', 'rubyrose', 'EARLY'),
('2026-10-24', 'mon', 'SAT'),
('2026-10-24', 'jurina', 'OFF'),
('2026-10-24', 'mayvel', 'OFF'),
('2026-10-24', 'kate', 'OFF'),
('2026-10-24', 'rubyrose', 'SAT'),
('2026-10-26', 'mon', 'EARLY'),
('2026-10-26', 'jurina', 'EARLY'),
('2026-10-26', 'mayvel', 'EARLY'),
('2026-10-26', 'kate', 'LATE'),
('2026-10-26', 'rubyrose', 'EARLY'),
('2026-10-27', 'mon', 'EARLY'),
('2026-10-27', 'jurina', 'EARLY'),
('2026-10-27', 'mayvel', 'EARLY'),
('2026-10-27', 'kate', 'LATE'),
('2026-10-27', 'rubyrose', 'EARLY'),
('2026-10-28', 'mon', 'EARLY'),
('2026-10-28', 'jurina', 'EARLY'),
('2026-10-28', 'mayvel', 'EARLY'),
('2026-10-28', 'kate', 'LATE'),
('2026-10-28', 'rubyrose', 'EARLY'),
('2026-10-29', 'mon', 'EARLY'),
('2026-10-29', 'jurina', 'EARLY'),
('2026-10-29', 'mayvel', 'EARLY'),
('2026-10-29', 'kate', 'LATE'),
('2026-10-29', 'rubyrose', 'EARLY'),
('2026-10-30', 'mon', 'EARLY'),
('2026-10-30', 'jurina', 'EARLY'),
('2026-10-30', 'mayvel', 'EARLY'),
('2026-10-30', 'kate', 'LATE'),
('2026-10-30', 'rubyrose', 'EARLY'),
('2026-10-31', 'mon', 'OFF'),
('2026-10-31', 'jurina', 'SAT'),
('2026-10-31', 'mayvel', 'SAT'),
('2026-10-31', 'kate', 'OFF'),
('2026-10-31', 'rubyrose', 'OFF'),
('2026-11-02', 'mon', 'LATE'),
('2026-11-02', 'jurina', 'LATE'),
('2026-11-02', 'mayvel', 'EARLY'),
('2026-11-02', 'kate', 'EARLY'),
('2026-11-02', 'rubyrose', 'EARLY'),
('2026-11-03', 'mon', 'LATE'),
('2026-11-03', 'jurina', 'LATE'),
('2026-11-03', 'mayvel', 'EARLY'),
('2026-11-03', 'kate', 'EARLY'),
('2026-11-03', 'rubyrose', 'EARLY'),
('2026-11-04', 'mon', 'LATE'),
('2026-11-04', 'jurina', 'LATE'),
('2026-11-04', 'mayvel', 'EARLY'),
('2026-11-04', 'kate', 'EARLY'),
('2026-11-04', 'rubyrose', 'EARLY'),
('2026-11-05', 'mon', 'LATE'),
('2026-11-05', 'jurina', 'LATE'),
('2026-11-05', 'mayvel', 'EARLY'),
('2026-11-05', 'kate', 'EARLY'),
('2026-11-05', 'rubyrose', 'EARLY'),
('2026-11-06', 'mon', 'LATE'),
('2026-11-06', 'jurina', 'LATE'),
('2026-11-06', 'mayvel', 'EARLY'),
('2026-11-06', 'kate', 'EARLY'),
('2026-11-06', 'rubyrose', 'EARLY'),
('2026-11-07', 'mon', 'OFF'),
('2026-11-07', 'jurina', 'OFF'),
('2026-11-07', 'mayvel', 'OFF'),
('2026-11-07', 'kate', 'SAT'),
('2026-11-07', 'rubyrose', 'SAT'),
('2026-11-09', 'mon', 'EARLY'),
('2026-11-09', 'jurina', 'EARLY'),
('2026-11-09', 'mayvel', 'LATE'),
('2026-11-09', 'kate', 'LATE'),
('2026-11-09', 'rubyrose', 'EARLY'),
('2026-11-10', 'mon', 'EARLY'),
('2026-11-10', 'jurina', 'EARLY'),
('2026-11-10', 'mayvel', 'LATE'),
('2026-11-10', 'kate', 'LATE'),
('2026-11-10', 'rubyrose', 'EARLY'),
('2026-11-11', 'mon', 'EARLY'),
('2026-11-11', 'jurina', 'EARLY'),
('2026-11-11', 'mayvel', 'LATE'),
('2026-11-11', 'kate', 'LATE'),
('2026-11-11', 'rubyrose', 'EARLY'),
('2026-11-12', 'mon', 'EARLY'),
('2026-11-12', 'jurina', 'EARLY'),
('2026-11-12', 'mayvel', 'LATE'),
('2026-11-12', 'kate', 'LATE'),
('2026-11-12', 'rubyrose', 'EARLY'),
('2026-11-13', 'mon', 'EARLY'),
('2026-11-13', 'jurina', 'EARLY'),
('2026-11-13', 'mayvel', 'LATE'),
('2026-11-13', 'kate', 'LATE'),
('2026-11-13', 'rubyrose', 'EARLY'),
('2026-11-14', 'mon', 'SAT'),
('2026-11-14', 'jurina', 'SAT'),
('2026-11-14', 'mayvel', 'OFF'),
('2026-11-14', 'kate', 'OFF'),
('2026-11-14', 'rubyrose', 'OFF'),
('2026-11-16', 'mon', 'LATE'),
('2026-11-16', 'jurina', 'LATE'),
('2026-11-16', 'mayvel', 'EARLY'),
('2026-11-16', 'kate', 'EARLY'),
('2026-11-16', 'rubyrose', 'LATE'),
('2026-11-17', 'mon', 'LATE'),
('2026-11-17', 'jurina', 'LATE'),
('2026-11-17', 'mayvel', 'EARLY'),
('2026-11-17', 'kate', 'EARLY'),
('2026-11-17', 'rubyrose', 'LATE'),
('2026-11-18', 'mon', 'LATE'),
('2026-11-18', 'jurina', 'LATE'),
('2026-11-18', 'mayvel', 'EARLY'),
('2026-11-18', 'kate', 'EARLY'),
('2026-11-18', 'rubyrose', 'LATE'),
('2026-11-19', 'mon', 'LATE'),
('2026-11-19', 'jurina', 'LATE'),
('2026-11-19', 'mayvel', 'EARLY'),
('2026-11-19', 'kate', 'EARLY'),
('2026-11-19', 'rubyrose', 'LATE'),
('2026-11-20', 'mon', 'LATE'),
('2026-11-20', 'jurina', 'LATE'),
('2026-11-20', 'mayvel', 'EARLY'),
('2026-11-20', 'kate', 'EARLY'),
('2026-11-20', 'rubyrose', 'LATE'),
('2026-11-21', 'mon', 'OFF'),
('2026-11-21', 'jurina', 'OFF'),
('2026-11-21', 'mayvel', 'SAT'),
('2026-11-21', 'kate', 'SAT'),
('2026-11-21', 'rubyrose', 'OFF'),
('2026-11-23', 'mon', 'EARLY'),
('2026-11-23', 'jurina', 'EARLY'),
('2026-11-23', 'mayvel', 'LATE'),
('2026-11-23', 'kate', 'LATE'),
('2026-11-23', 'rubyrose', 'EARLY'),
('2026-11-24', 'mon', 'EARLY'),
('2026-11-24', 'jurina', 'EARLY'),
('2026-11-24', 'mayvel', 'LATE'),
('2026-11-24', 'kate', 'LATE'),
('2026-11-24', 'rubyrose', 'EARLY'),
('2026-11-25', 'mon', 'EARLY'),
('2026-11-25', 'jurina', 'EARLY'),
('2026-11-25', 'mayvel', 'LATE'),
('2026-11-25', 'kate', 'LATE'),
('2026-11-25', 'rubyrose', 'EARLY'),
('2026-11-26', 'mon', 'EARLY'),
('2026-11-26', 'jurina', 'EARLY'),
('2026-11-26', 'mayvel', 'LATE'),
('2026-11-26', 'kate', 'LATE'),
('2026-11-26', 'rubyrose', 'EARLY'),
('2026-11-27', 'mon', 'EARLY'),
('2026-11-27', 'jurina', 'EARLY'),
('2026-11-27', 'mayvel', 'LATE'),
('2026-11-27', 'kate', 'LATE'),
('2026-11-27', 'rubyrose', 'EARLY'),
('2026-11-28', 'mon', 'SAT'),
('2026-11-28', 'jurina', 'OFF'),
('2026-11-28', 'mayvel', 'OFF'),
('2026-11-28', 'kate', 'OFF'),
('2026-11-28', 'rubyrose', 'SAT'),
('2026-11-30', 'mon', 'LATE'),
('2026-11-30', 'jurina', 'EARLY'),
('2026-11-30', 'mayvel', 'EARLY'),
('2026-11-30', 'kate', 'EARLY'),
('2026-11-30', 'rubyrose', 'LATE'),
('2026-12-01', 'mon', 'LATE'),
('2026-12-01', 'jurina', 'EARLY'),
('2026-12-01', 'mayvel', 'EARLY'),
('2026-12-01', 'kate', 'EARLY'),
('2026-12-01', 'rubyrose', 'LATE'),
('2026-12-02', 'mon', 'LATE'),
('2026-12-02', 'jurina', 'EARLY'),
('2026-12-02', 'mayvel', 'EARLY'),
('2026-12-02', 'kate', 'EARLY'),
('2026-12-02', 'rubyrose', 'LATE'),
('2026-12-03', 'mon', 'LATE'),
('2026-12-03', 'jurina', 'EARLY'),
('2026-12-03', 'mayvel', 'EARLY'),
('2026-12-03', 'kate', 'EARLY'),
('2026-12-03', 'rubyrose', 'LATE'),
('2026-12-04', 'mon', 'LATE'),
('2026-12-04', 'jurina', 'EARLY'),
('2026-12-04', 'mayvel', 'EARLY'),
('2026-12-04', 'kate', 'EARLY'),
('2026-12-04', 'rubyrose', 'LATE'),
('2026-12-05', 'mon', 'OFF'),
('2026-12-05', 'jurina', 'SAT'),
('2026-12-05', 'mayvel', 'SAT'),
('2026-12-05', 'kate', 'OFF'),
('2026-12-05', 'rubyrose', 'OFF'),
('2026-12-07', 'mon', 'EARLY'),
('2026-12-07', 'jurina', 'EARLY'),
('2026-12-07', 'mayvel', 'LATE'),
('2026-12-07', 'kate', 'EARLY'),
('2026-12-07', 'rubyrose', 'EARLY'),
('2026-12-08', 'mon', 'EARLY'),
('2026-12-08', 'jurina', 'EARLY'),
('2026-12-08', 'mayvel', 'LATE'),
('2026-12-08', 'kate', 'EARLY'),
('2026-12-08', 'rubyrose', 'EARLY'),
('2026-12-09', 'mon', 'EARLY'),
('2026-12-09', 'jurina', 'EARLY'),
('2026-12-09', 'mayvel', 'LATE'),
('2026-12-09', 'kate', 'EARLY'),
('2026-12-09', 'rubyrose', 'EARLY'),
('2026-12-10', 'mon', 'EARLY'),
('2026-12-10', 'jurina', 'EARLY'),
('2026-12-10', 'mayvel', 'LATE'),
('2026-12-10', 'kate', 'EARLY'),
('2026-12-10', 'rubyrose', 'EARLY'),
('2026-12-11', 'mon', 'EARLY'),
('2026-12-11', 'jurina', 'EARLY'),
('2026-12-11', 'mayvel', 'LATE'),
('2026-12-11', 'kate', 'EARLY'),
('2026-12-11', 'rubyrose', 'EARLY'),
('2026-12-12', 'mon', 'OFF'),
('2026-12-12', 'jurina', 'OFF'),
('2026-12-12', 'mayvel', 'OFF'),
('2026-12-12', 'kate', 'SAT'),
('2026-12-12', 'rubyrose', 'SAT'),
('2026-12-14', 'mon', 'EARLY'),
('2026-12-14', 'jurina', 'EARLY'),
('2026-12-14', 'mayvel', 'EARLY'),
('2026-12-14', 'kate', 'EARLY'),
('2026-12-14', 'rubyrose', 'LATE'),
('2026-12-15', 'mon', 'EARLY'),
('2026-12-15', 'jurina', 'EARLY'),
('2026-12-15', 'mayvel', 'EARLY'),
('2026-12-15', 'kate', 'EARLY'),
('2026-12-15', 'rubyrose', 'LATE'),
('2026-12-16', 'mon', 'EARLY'),
('2026-12-16', 'jurina', 'EARLY'),
('2026-12-16', 'mayvel', 'EARLY'),
('2026-12-16', 'kate', 'EARLY'),
('2026-12-16', 'rubyrose', 'LATE'),
('2026-12-17', 'mon', 'EARLY'),
('2026-12-17', 'jurina', 'EARLY'),
('2026-12-17', 'mayvel', 'EARLY'),
('2026-12-17', 'kate', 'EARLY'),
('2026-12-17', 'rubyrose', 'LATE'),
('2026-12-18', 'mon', 'EARLY'),
('2026-12-18', 'jurina', 'EARLY'),
('2026-12-18', 'mayvel', 'EARLY'),
('2026-12-18', 'kate', 'EARLY'),
('2026-12-18', 'rubyrose', 'LATE'),
('2026-12-19', 'mon', 'SAT'),
('2026-12-19', 'jurina', 'SAT'),
('2026-12-19', 'mayvel', 'OFF'),
('2026-12-19', 'kate', 'OFF'),
('2026-12-19', 'rubyrose', 'OFF'),
('2026-12-21', 'mon', 'EARLY'),
('2026-12-21', 'jurina', 'EARLY'),
('2026-12-21', 'mayvel', 'EARLY'),
('2026-12-21', 'kate', 'EARLY'),
('2026-12-21', 'rubyrose', 'EARLY'),
('2026-12-22', 'mon', 'EARLY'),
('2026-12-22', 'jurina', 'EARLY'),
('2026-12-22', 'mayvel', 'EARLY'),
('2026-12-22', 'kate', 'EARLY'),
('2026-12-22', 'rubyrose', 'EARLY'),
('2026-12-23', 'mon', 'EARLY'),
('2026-12-23', 'jurina', 'EARLY'),
('2026-12-23', 'mayvel', 'EARLY'),
('2026-12-23', 'kate', 'EARLY'),
('2026-12-23', 'rubyrose', 'EARLY'),
('2026-12-24', 'mon', 'EARLY'),
('2026-12-24', 'jurina', 'EARLY'),
('2026-12-24', 'mayvel', 'EARLY'),
('2026-12-24', 'kate', 'EARLY'),
('2026-12-24', 'rubyrose', 'EARLY'),
('2026-12-25', 'mon', 'EARLY'),
('2026-12-25', 'jurina', 'EARLY'),
('2026-12-25', 'mayvel', 'EARLY'),
('2026-12-25', 'kate', 'EARLY'),
('2026-12-25', 'rubyrose', 'EARLY'),
('2026-12-26', 'mon', 'OFF'),
('2026-12-26', 'jurina', 'OFF'),
('2026-12-26', 'mayvel', 'SAT'),
('2026-12-26', 'kate', 'SAT'),
('2026-12-26', 'rubyrose', 'OFF'),
('2026-12-28', 'mon', 'EARLY'),
('2026-12-28', 'jurina', 'LATE'),
('2026-12-28', 'mayvel', 'EARLY'),
('2026-12-28', 'kate', 'EARLY'),
('2026-12-28', 'rubyrose', 'EARLY'),
('2026-12-29', 'mon', 'EARLY'),
('2026-12-29', 'jurina', 'LATE'),
('2026-12-29', 'mayvel', 'EARLY'),
('2026-12-29', 'kate', 'EARLY'),
('2026-12-29', 'rubyrose', 'EARLY'),
('2026-12-30', 'mon', 'EARLY'),
('2026-12-30', 'jurina', 'LATE'),
('2026-12-30', 'mayvel', 'EARLY'),
('2026-12-30', 'kate', 'EARLY'),
('2026-12-30', 'rubyrose', 'EARLY'),
('2026-12-31', 'mon', 'EARLY'),
('2026-12-31', 'jurina', 'LATE'),
('2026-12-31', 'mayvel', 'EARLY'),
('2026-12-31', 'kate', 'EARLY'),
('2026-12-31', 'rubyrose', 'EARLY')on conflict (shift_date, agent_id) do update
  set shift_code = excluded.shift_code, updated_at = now();

-- ============================================================
-- The 4 valid pending PTO requests (5th excluded, see header above)
-- ============================================================

insert into public.time_off_requests (agent_id, request_type, start_date, end_date, status) values
  ('mon',      'PREFERRED', '2026-06-26', '2026-06-26', 'pending'),
  ('mayvel',   'PREFERRED', '2026-09-15', '2026-09-17', 'pending'),
  ('rubyrose', 'PREFERRED', '2026-08-29', '2026-08-29', 'pending'),
  ('mon',      'PREFERRED', '2026-09-02', '2026-09-05', 'pending');

-- ============================================================
-- Self-verification guards
-- ============================================================

do $migration_guard$
declare
  schedule_count int;
  pending_count int;
begin
  -- >= not = -- a first run found 11 pre-existing schedule rows for
  -- these agents/dates that predate this import (old seed/test data on
  -- dates the legacy scrape didn't produce, e.g. a Sunday), which this
  -- migration correctly leaves untouched. The guard's job is to catch
  -- a real failure (0 rows, or far short of 1100), not to demand this
  -- table was empty beforehand.
  select count(*) into schedule_count from public.schedule
    where shift_date between '2026-04-20' and '2026-12-31'
      and agent_id in ('mon', 'jurina', 'mayvel', 'kate', 'rubyrose');
  if schedule_count < 1100 then
    raise exception 'Aborting 0044: expected at least 1100 schedule rows for Apr 20 - Dec 31 2026 across the 5 agents, found %', schedule_count;
  end if;

  select count(*) into pending_count from public.time_off_requests
    where status = 'pending'
      and start_date >= '2026-06-01'
      and agent_id in ('mon', 'mayvel', 'rubyrose');
  if pending_count < 4 then
    raise exception 'Aborting 0044: expected at least 4 newly-imported pending time_off_requests, found %', pending_count;
  end if;
end $migration_guard$;