Suivi de grossesse

-- Si vous migrez d'anciennes tables, supprimez d'abord les policies existantes :
-- DROP POLICY IF EXISTS "Allow all" ON pregnancy_events;
-- DROP POLICY IF EXISTS "Allow all" ON pregnancy_settings;

CREATE TABLE IF NOT EXISTS pregnancy_events (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  title TEXT NOT NULL,
  category TEXT NOT NULL DEFAULT 'note',
  event_date DATE, week INTEGER, description TEXT,
  completed BOOLEAN DEFAULT false,
  created_at TIMESTAMPTZ DEFAULT now(),
  updated_at TIMESTAMPTZ DEFAULT now()
);
ALTER TABLE pregnancy_events ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Auth only" ON pregnancy_events FOR ALL
  USING (auth.role() = 'authenticated')
  WITH CHECK (auth.role() = 'authenticated');

CREATE TABLE IF NOT EXISTS pregnancy_settings (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  due_date DATE, baby_name TEXT, start_date DATE,
  created_at TIMESTAMPTZ DEFAULT now(),
  updated_at TIMESTAMPTZ DEFAULT now()
);
ALTER TABLE pregnancy_settings ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Auth only" ON pregnancy_settings FOR ALL
  USING (auth.role() = 'authenticated')
  WITH CHECK (auth.role() = 'authenticated');