-- 1. Tambah kolom media
ALTER TABLE announcements ADD COLUMN IF NOT EXISTS image_url TEXT;
ALTER TABLE announcements ADD COLUMN IF NOT EXISTS link_url TEXT;
ALTER TABLE school_events ADD COLUMN IF NOT EXISTS image_url TEXT;
ALTER TABLE school_events ADD COLUMN IF NOT EXISTS link_url TEXT;

-- 2. Buat storage bucket
INSERT INTO storage.buckets (id, name, public) 
VALUES ('announcements-events', 'announcements-events', true)
ON CONFLICT (id) DO NOTHING;

-- 3. Kebijakan akses storage
CREATE POLICY "Public Access" ON storage.objects FOR SELECT USING (bucket_id = 'announcements-events');
CREATE POLICY "Authenticated Upload" ON storage.objects FOR INSERT WITH CHECK (bucket_id = 'announcements-events' AND auth.role() = 'authenticated');
CREATE POLICY "Authenticated Update" ON storage.objects FOR UPDATE WITH CHECK (bucket_id = 'announcements-events' AND auth.role() = 'authenticated');
CREATE POLICY "Authenticated Delete" ON storage.objects FOR DELETE USING (bucket_id = 'announcements-events' AND auth.role() = 'authenticated');