 INSERT INTO schedules (name, code, is_default, valid_start) VALUES ('Easter Day', 'easter-day', true, '2014-01-01 00:00:00' AT TIME ZONE 'America/New_York'); -- 45
 INSERT INTO schedules (name, code, is_default, valid_start, valid_end) VALUES ('Easter Day', 'easter-day', true, '2008-01-01 00:00:00' AT TIME ZONE 'America/New_York', '2013-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 46
 INSERT INTO schedules (name, code, is_default, valid_end) VALUES ('Easter Day', 'easter-day', true, '2007-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 47
+INSERT INTO schedules (name, code, is_default, valid_start) VALUES ('Ash Wednesday', 'ash-wednesday', true, '2013-01-01 00:00:00' AT TIME ZONE 'America/New_York'); -- 48
+INSERT INTO schedules (name, code, is_default, valid_start, valid_end) VALUES ('Ash Wednesday', 'ash-wednesday', true, '2007-01-01 00:00:00' AT TIME ZONE 'America/New_York', '2012-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 49
+INSERT INTO schedules (name, code, is_default, valid_end) VALUES ('Ash Wednesday', 'ash-wednesday', true, '2006-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 50
+
+INSERT INTO schedules (name, code, is_default, valid_start) VALUES ('Good Friday', 'good-friday', true, '2015-01-01 00:00:00' AT TIME ZONE 'America/New_York'); -- 51
+INSERT INTO schedules (name, code, is_default, valid_start, valid_end) VALUES ('Good Friday', 'good-friday', true, '2011-01-01 00:00:00' AT TIME ZONE 'America/New_York', '2014-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 52
+INSERT INTO schedules (name, code, is_default, valid_end) VALUES ('Good Friday', 'good-friday', true, '2010-12-31 23:59:59' AT TIME ZONE 'America/New_York'); -- 53
 
 -- TODO: old summer sunday schedule
 -- TODO: old weekday schedule (with 6:20 Mass after evening prayer)

INSERT INTO schedule_services (schedule_id, service_id) VALUES (47, 50); -- easter-day (oldest)
INSERT INTO schedule_services (schedule_id, service_id) VALUES (47, 13); -- easter-day (oldest)
INSERT INTO schedule_services (schedule_id, service_id) VALUES (47, 52); -- easter-day (oldest)

--
-- Define service patterns for seasons, fixed feasts, and moveable feasts that vary by day of the week

INSERT INTO services (name, start_time, is_default) VALUES ('Sung Mass', '10:00:00', false); -- 50
INSERT INTO services (name, start_time, is_default) VALUES ('Organ Recital', '16:30:00', true); -- 51
INSERT INTO services (name, start_time, is_default) VALUES ('Solemn Paschal Evensong & Benediction', '17:00:00', true); -- 52
INSERT INTO services (name, start_time, is_default) VALUES ('Mass', '07:00:00', false); -- 53
INSERT INTO services (name, start_time, is_default) VALUES ('Mass', '08:00:00', false); -- 54
INSERT INTO services (name, start_time, is_default) VALUES ('Said Mass', '07:00:00', false); -- 55
INSERT INTO services (name, start_time, is_default) VALUES ('Said Mass', '08:00:00', false); -- 56

INSERT INTO services (name, start_time, is_default) VALUES ('Liturgy of Good Friday', '12:30:00', false); -- 57
INSERT INTO services (name, start_time, is_default) VALUES ('Liturgy of Good Friday', '18:00:00', false); -- 58
INSERT INTO services (name, start_time, is_default) VALUES ('Celebration of the Passion', '12:30:00', false); -- 59
INSERT INTO services (name, start_time, is_default) VALUES ('Celebration of the Passion', '18:00:00', false); -- 60
INSERT INTO services (name, start_time, is_default) VALUES ('The Celebration of the Passion of the Lord', '12:30:00', false); -- 61
INSERT INTO services (name, start_time, is_default) VALUES ('The Celebration of the Passion of the Lord', '18:00:00', false); -- 62

CREATE TABLE schedule_services (
    schedule_id integer NOT NULL,
