Inscription à l’événement
Remplissez ce formulaire pour participer.
-- ① Exécutez ce SQL dans l'éditeur SQL de Supabase ――――――――――――――――
-- Table des événements
CREATE TABLE IF NOT EXISTS events (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
name TEXT NOT NULL,
date DATE,
time TIME,
venue TEXT,
address TEXT,
capacity INTEGER,
created_at TIMESTAMPTZ DEFAULT now()
);
ALTER TABLE events ADD COLUMN IF NOT EXISTS time TIME;
ALTER TABLE events ADD COLUMN IF NOT EXISTS address TEXT;
ALTER TABLE events ADD COLUMN IF NOT EXISTS capacity INTEGER;
-- Table des invités
CREATE TABLE IF NOT EXISTS guests (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
name TEXT NOT NULL,
email TEXT,
phone TEXT,
event_id UUID REFERENCES events(id) ON DELETE CASCADE,
qr_code TEXT UNIQUE,
status TEXT DEFAULT 'pending'
CHECK (status IN ('pending','present')),
email_sent BOOLEAN DEFAULT false,
checkin_time TIMESTAMPTZ,
created_at TIMESTAMPTZ DEFAULT now()
);
ALTER TABLE guests ADD COLUMN IF NOT EXISTS phone TEXT;
-- Sécurité (ouvert pour démo — restreindre en production)
ALTER TABLE events ENABLE ROW LEVEL SECURITY;
ALTER TABLE guests ENABLE ROW LEVEL SECURITY;
CREATE POLICY "open_events" ON events FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "open_guests" ON guests FOR ALL USING (true) WITH CHECK (true);
-- Activer le Realtime sur la table guests
ALTER PUBLICATION supabase_realtime ADD TABLE guests;
ALTER PUBLICATION supabase_realtime ADD TABLE events;