🌿 GreenScan

Führe dieses SQL in deinem Supabase SQL Editor aus:

CREATE TABLE profiles (
  id UUID PRIMARY KEY REFERENCES auth.users(id) ON DELETE CASCADE,
  display_name TEXT, avatar_emoji TEXT DEFAULT '🌿',
  xp INTEGER DEFAULT 0, login_streak INTEGER DEFAULT 0,
  longest_streak INTEGER DEFAULT 0, last_login_date TEXT,
  total_logins INTEGER DEFAULT 0, max_level_reached INTEGER DEFAULT 1,
  milestones TEXT[] DEFAULT '{}', stats JSONB DEFAULT '{}',
  created_at TIMESTAMPTZ DEFAULT now(), updated_at TIMESTAMPTZ DEFAULT now()
);
ALTER TABLE profiles ENABLE ROW LEVEL SECURITY;
CREATE POLICY "sel" ON profiles FOR SELECT TO authenticated USING (auth.uid()=id);
CREATE POLICY "ins" ON profiles FOR INSERT TO authenticated WITH CHECK (auth.uid()=id);
CREATE POLICY "upd" ON profiles FOR UPDATE TO authenticated USING (auth.uid()=id);