

-- Daily Readings
INSERT INTO daily_readings (date, liturgical_day, first_reading_reference, first_reading_text, responsorial_psalm_reference, responsorial_psalm_text, second_reading_reference, second_reading_text, gospel_reference, gospel_text, created_at, updated_at)
VALUES 
('2025-03-20', 'Thursday of the 3rd Week of Lent', 'Jeremiah 7:23-28', 'Thus says the LORD: This is what I commanded my people: Listen to my voice; then I will be your God and you shall be my people. Walk in all the ways that I command you, so that you may prosper.', 'Psalm 95:1-2, 6-7, 8-9', 'If today you hear his voice, harden not your hearts.', NULL, NULL, 'Luke 11:14-23', 'Jesus was driving out a demon that was mute, and when the demon had gone out, the mute man spoke and the crowds were amazed.', NOW(), NOW()),
('2025-03-21', 'Friday of the 3rd Week of Lent', 'Hosea 14:2-10', 'Thus says the LORD: Return, O Israel, to the LORD, your God; you have collapsed through your guilt. Take with you words, and return to the LORD.', 'Psalm 81:6c-8a, 8bc-9, 10-11ab, 14 and 17', 'I am the Lord your God: hear my voice.', NULL, NULL, 'Mark 12:28-34', 'One of the scribes came to Jesus and asked him, "Which is the first of all the commandments?" Jesus replied, "The first is this: Hear, O Israel! The Lord our God is Lord alone!"', NOW(), NOW()),
('2025-03-22', 'Saturday of the 3rd Week of Lent', 'Hosea 6:1-6', 'Come, let us return to the LORD, it is he who has rent, but he will heal us; he has struck us, but he will bind our wounds.', 'Psalm 51:3-4, 18-19, 20-21ab', 'It is mercy I desire, and not sacrifice.', NULL, NULL, 'Luke 18:9-14', 'Jesus addressed this parable to those who were convinced of their own righteousness and despised everyone else.', NOW(), NOW());

-- Announcements
INSERT INTO announcements (title, content, start_date, end_date, created_by, created_at, updated_at)
VALUES 
('Easter Mass Schedule', 'Join us for Easter Sunday Mass at 8:00 AM, 10:00 AM, and 12:00 PM. There will also be a Vigil Mass on Saturday at 8:00 PM.', '2025-03-15', '2025-04-05', 1, NOW(), NOW()),
('Parish Picnic', 'Our annual parish picnic will be held on Sunday, April 27th after the 12:00 PM Mass. Please bring a dish to share and join us for food, games, and fellowship.', '2025-03-20', '2025-04-27', 1, NOW(), NOW()),
('Confession Schedule Change', 'Please note that confessions will be heard on Wednesday evenings from 6:00 PM to 7:00 PM during Lent, in addition to the regular Saturday times.', '2025-03-01', '2025-04-10', 1, NOW(), NOW());

-- Events
INSERT INTO events (title, description, category, start_datetime, end_datetime, location, created_by, created_at, updated_at)
VALUES 
('Easter Sunday Mass', 'Celebrate the Resurrection of Our Lord Jesus Christ', 'Mass', '2025-04-05 10:00:00', '2025-04-05 11:30:00', 'Main Church', 1, NOW(), NOW()),
('First Communion Preparation', 'Preparation class for children receiving their First Holy Communion', 'Sacrament', '2025-04-12 09:00:00', '2025-04-12 11:00:00', 'Parish Hall', 1, NOW(), NOW()),
('Bible Study Group', 'Weekly Bible study focusing on the upcoming Sunday readings', 'Formation', '2025-03-25 19:00:00', '2025-03-25 20:30:00', 'Meeting Room 2', 1, NOW(), NOW());

-- Mass Recordings
INSERT INTO mass_recordings (title, date, celebrant, audio_file, duration, download_count, created_at, updated_at)
VALUES 
('Sunday Mass', '2025-03-16', 'Fr. John Smith', '/uploads/audio/mass_20250316.mp3', '01:15:30', 0, NOW(), NOW()),
('Daily Mass', '2025-03-17', 'Fr. Michael Johnson', '/uploads/audio/mass_20250317.mp3', '00:45:20', 0, NOW(), NOW()),
('Feast of St. Joseph', '2025-03-19', 'Fr. John Smith', '/uploads/audio/mass_20250319.mp3', '01:05:15', 0, NOW(), NOW());

-- Mass Schedule
INSERT INTO mass_schedule (day_of_week, time, language, location, active, created_at, updated_at)
VALUES 
('Sunday', '08:00:00', 'English', 'Main Church', 1, NOW(), NOW()),
('Sunday', '10:00:00', 'English', 'Main Church', 1, NOW(), NOW()),
('Sunday', '12:00:00', 'Spanish', 'Main Church', 1, NOW(), NOW()),
('Monday', '07:30:00', 'English', 'Chapel', 1, NOW(), NOW()),
('Wednesday', '07:30:00', 'English', 'Chapel', 1, NOW(), NOW()),
('Friday', '07:30:00', 'English', 'Chapel', 1, NOW(), NOW()),
('Saturday', '17:00:00', 'English', 'Main Church', 1, NOW(), NOW());

-- Confession Schedule
INSERT INTO confession_schedule (day_of_week, start_time, end_time, location, notes, active, created_at, updated_at)
VALUES 
('Saturday', '15:30:00', '16:30:00', 'Confessional', 'Before Saturday evening Mass', 1, NOW(), NOW()),
('Wednesday', '17:00:00', '18:00:00', 'Confessional', 'Evening confessions', 1, NOW(), NOW()),
('Friday', '08:00:00', '09:00:00', 'Confessional', 'Morning confessions', 1, NOW(), NOW());

-- Bulletins
INSERT INTO bulletins (title, issue_date, file_path, description, created_at, updated_at)
VALUES 
('Weekly Bulletin', '2025-03-16', '/uploads/bulletins/bulletin_20250316.pdf', 'Parish bulletin for March 16, 2025', NOW(), NOW()),
('Weekly Bulletin', '2025-03-09', '/uploads/bulletins/bulletin_20250309.pdf', 'Parish bulletin for March 9, 2025', NOW(), NOW()),
('Weekly Bulletin', '2025-03-02', '/uploads/bulletins/bulletin_20250302.pdf', 'Parish bulletin for March 2, 2025', NOW(), NOW());

-- Parish Staff
INSERT INTO staff (name, position, bio, photo, email, phone, display_order, created_at, updated_at)
VALUES 
('Fr. John Smith', 'Pastor', 'Fr. John has been serving as pastor of St. Gerard''s since 2020. He was ordained in 2005 and has served in several parishes throughout the diocese.', '/uploads/images/staff/fr_john.jpg', 'frjohn@stgerards.com', '555-123-4567', 1, NOW(), NOW()),
('Fr. Michael Johnson', 'Associate Pastor', 'Fr. Michael joined St. Gerard''s in 2022 after his ordination. He has a background in education and youth ministry.', '/uploads/images/staff/fr_michael.jpg', 'frmichael@stgerards.com', '555-123-4568', 2, NOW(), NOW()),
('Jane Doe', 'Parish Secretary', 'Jane has been the parish secretary for over 10 years and is often the first person you''ll meet when visiting the parish office.', '/uploads/images/staff/jane.jpg', 'office@stgerards.com', '555-123-4569', 3, NOW(), NOW());

-- Prayers
INSERT INTO prayers (title, content, category, audio_file, created_at, updated_at)
VALUES 
('Our Father', 'Our Father, who art in heaven, hallowed be thy name; thy kingdom come; thy will be done on earth as it is in heaven. Give us this day our daily bread; and forgive us our trespasses as we forgive those who trespass against us; and lead us not into temptation, but deliver us from evil. Amen.', 'Common', '/uploads/audio/prayers/our_father.mp3', NOW(), NOW()),
('Hail Mary', 'Hail Mary, full of grace, the Lord is with thee; blessed art thou among women, and blessed is the fruit of thy womb, Jesus. Holy Mary, Mother of God, pray for us sinners, now and at the hour of our death. Amen.', 'Marian', '/uploads/audio/prayers/hail_mary.mp3', NOW(), NOW()),
('Glory Be', 'Glory be to the Father, and to the Son, and to the Holy Spirit. As it was in the beginning, is now, and ever shall be, world without end. Amen.', 'Common', '/uploads/audio/prayers/glory_be.mp3', NOW(), NOW());

-- Confession Times
INSERT INTO confession_times (day_of_week, start_time, end_time, notes, active, created_at, updated_at)
VALUES 
('Wednesday', '18:00:00', '19:00:00', 'During Lent only', 1, NOW(), NOW()),
('Saturday', '15:30:00', '16:30:00', 'Or by appointment', 1, NOW(), NOW());

-- Resources
INSERT INTO resources (title, description, file_url, category, download_count, created_at, updated_at)
VALUES 
('Introduction to Catholic Faith', 'A beginner''s guide to understanding the Catholic faith and traditions.', '/uploads/resources/intro_catholic_faith.pdf', 'Formation', 0, NOW(), NOW()),
('Lenten Reflection Guide', 'Daily reflections and prayers for the Lenten season.', '/uploads/resources/lenten_reflections.pdf', 'Seasonal', 0, NOW(), NOW()),
('Marriage Preparation Checklist', 'A checklist for couples preparing for the Sacrament of Matrimony.', '/uploads/resources/marriage_prep.pdf', 'Sacraments', 0, NOW(), NOW());
