-- Fix import for bulletins and staff

-- 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, order_index, 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());
