Catatan Migrasi Database

Fitur kontak ini memerlukan tabel konten_kontak di database Supabase Anda. Jika proses penyimpanan gagal atau terjadi error, silakan jalankan query SQL berikut di menu SQL Editor di dashboard Supabase Anda:

CREATE TABLE IF NOT EXISTS public.konten_kontak (
    id bigint PRIMARY KEY DEFAULT 1,
    alamat text,
    gmaps_link text,
    whatsapp text,
    telepon_display text,
    email text,
    facebook_link text,
    facebook_display text,
    instagram_link text,
    instagram_display text,
    CONSTRAINT single_row CHECK (id = 1)
);

ALTER TABLE public.konten_kontak ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Allow public read access" ON public.konten_kontak FOR SELECT USING (true);
CREATE POLICY "Allow auth upsert" ON public.konten_kontak FOR ALL TO authenticated USING (true) WITH CHECK (true);

INSERT INTO public.konten_kontak (id, alamat, gmaps_link, whatsapp, telepon_display, email, facebook_link, facebook_display, instagram_link, instagram_display)
VALUES (1, 'Jl. Tondano - Touliang, Kiniar, Tondano', 'https://maps.app.goo.gl/DkWLz7nQpP1LwzXz9', '628972393666', '+62 897-2393-666', 'phdiminahasa2022@gmail.com', 'https://facebook.com', 'Pura Danu Mandara', 'https://instagram.com/puradanumandara', '@puradanumandara')
ON CONFLICT (id) DO NOTHING;