Escala Multimidia - SQL import abril 2026

004_import_abril_2026.sql

DROP POLICY IF EXISTS anon_read_schedule_entries ON schedule_entries;
DROP POLICY IF EXISTS anon_read_schedule_meta ON schedule_meta;
DROP POLICY IF EXISTS anon_read_event_areas ON event_areas;
DROP POLICY IF EXISTS anon_read_unavailabilities ON unavailabilities;
CREATE POLICY anon_read_schedule_entries ON schedule_entries FOR SELECT USING (true);
CREATE POLICY anon_read_schedule_meta ON schedule_meta FOR SELECT USING (true);
CREATE POLICY anon_read_event_areas ON event_areas FOR SELECT USING (true);
CREATE POLICY anon_read_unavailabilities ON unavailabilities FOR SELECT USING (true);
DELETE FROM schedule_entries WHERE event_id IN (SELECT id FROM events WHERE month = 4 AND year = 2026);
DELETE FROM event_areas WHERE event_id IN (SELECT id FROM events WHERE month = 4 AND year = 2026);
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Escola%' AND areas.name IN ('Fotografia', 'Projecao');
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Infantil%' AND areas.name IN ('Fotografia', 'Projecao');
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Teleios%' AND areas.name = 'Fotografia';
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Casais%' AND areas.name IN ('Fotografia', 'Projecao');
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Cantata%' AND areas.name IN ('Fotografia', 'Projecao', 'Transmissao', 'Camera 2', 'Camera 3', 'Camera 4', 'Iluminacao');
INSERT INTO event_areas (event_id, area_id) SELECT events.id, areas.id FROM events CROSS JOIN areas WHERE events.month = 4 AND events.year = 2026 AND events.name LIKE '%Adora%' AND areas.name IN ('Fotografia', 'Projecao', 'Transmissao', 'Camera 2', 'Camera 3', 'Iluminacao');
WITH schedule_data(event_id, area_name, member_name) AS (VALUES ('22b9b947-0346-497a-8f9b-4ba4f014744a', 'Fotografia', 'Tayna'), ('22b9b947-0346-497a-8f9b-4ba4f014744a', 'Projecao', 'Laisa'), ('79680ff0-7ea5-4861-8fa3-0e736a01c62b', 'Fotografia', 'Thais'), ('79680ff0-7ea5-4861-8fa3-0e736a01c62b', 'Projecao', 'Joseane'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Fotografia', 'Bruno'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Projecao', 'Rayssa'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Transmissao', 'Jonatas'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Camera 2', 'Maria Paula'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Camera 3', 'Victor'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Camera 4', 'Ivan'), ('c83b090f-ab8d-4733-a79d-44cf0afe5017', 'Iluminacao', 'Tayna'), ('b5626a77-942f-4e7f-9554-33b99f49b624', 'Fotografia', 'Thais'), ('b5626a77-942f-4e7f-9554-33b99f49b624', 'Projecao', 'Joseane'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Fotografia', 'Bruno'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Projecao', 'Michele'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Transmissao', 'Walisson'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Camera 2', 'Gustavo'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Camera 3', 'Eduarda'), ('4d4732ad-2ed4-42ef-9f58-b2cb2d4f0a71', 'Iluminacao', 'Giovanna'), ('03c9d203-2ce5-4da1-8bb6-a0a4d4baabf5', 'Fotografia', 'Bruno'), ('294e169d-e5d3-4616-b12d-a24da7baf8c1', 'Fotografia', 'Thais'), ('294e169d-e5d3-4616-b12d-a24da7baf8c1', 'Projecao', 'Laisa'), ('62aad45f-4bef-417b-a4e0-018fe8a052ad', 'Fotografia', 'Ana Beatriz'), ('62aad45f-4bef-417b-a4e0-018fe8a052ad', 'Projecao', 'Giovanna'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Fotografia', 'Amanda'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Projecao', 'Ana Beatriz'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Transmissao', 'Gustavo'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Camera 2', 'Davi'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Camera 3', 'Andressa'), ('90e9e44e-8f5a-4223-a600-7bb004d788d9', 'Iluminacao', 'Tayna'), ('231995bd-42b2-472a-aef2-5860c4349289', 'Fotografia', 'Tayna'), ('231995bd-42b2-472a-aef2-5860c4349289', 'Projecao', 'Joseane'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Fotografia', 'Diego'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Projecao', 'Claricy'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Transmissao', 'Maria Eduarda'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Camera 2', 'Esther'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Camera 3', 'Walisson'), ('ee4f4cb2-af86-43ed-bae9-91f59c744089', 'Iluminacao', 'Victor'), ('7e452f3b-1fdf-4a6a-b41b-9120d0d66c85', 'Fotografia', 'Tayna'), ('7e452f3b-1fdf-4a6a-b41b-9120d0d66c85', 'Projecao', 'Laisa')) INSERT INTO schedule_entries (event_id, area_id, member_id, status) SELECT schedule_data.event_id::uuid, areas.id, members.id, 'scheduled' FROM schedule_data JOIN areas ON areas.name = schedule_data.area_name JOIN members ON members.name = schedule_data.member_name;
INSERT INTO schedule_meta (month, year, status, published_at) VALUES (4, 2026, 'published', now());

new