R&C TRACKER
Configuration Supabase⚙️ Connect to the database
Enter your Supabase credentials. You can find them in Settings → API.
Pas de projet ? Create a free account →
📋 Script SQL (Supabase → SQL Editor)
-- Supprimer l'ancienne table si elle existe DROP TABLE IF EXISTS items; CREATE TABLE items ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, name TEXT NOT NULL, type TEXT DEFAULT '', edition TEXT DEFAULT '', manufacturer TEXT DEFAULT '', platform TEXT DEFAULT '', region TEXT DEFAULT 'PAL', condition TEXT DEFAULT 'occasion', status TEXT NOT NULL DEFAULT 'owned', has_box BOOLEAN DEFAULT false, has_manual BOOLEAN DEFAULT false, has_disc BOOLEAN DEFAULT false, has_sleeve BOOLEAN DEFAULT false, has_docs BOOLEAN DEFAULT false, buy_price NUMERIC(10,2), cur_value NUMERIC(10,2), img_url TEXT DEFAULT '', rating INTEGER DEFAULT NULL, notes TEXT DEFAULT '', wish_url TEXT DEFAULT '', comment TEXT DEFAULT '', created_at TIMESTAMPTZ DEFAULT NOW() ); ALTER TABLE items ENABLE ROW LEVEL SECURITY; CREATE POLICY "Users see own items" ON items FOR ALL USING (auth.uid() = user_id) WITH CHECK (auth.uid() = user_id);