Supabase Baglantisi

SQL Şema

CREATE TABLE books (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  user_id UUID REFERENCES auth.users(id),
  title TEXT NOT NULL, author TEXT NOT NULL,
  isbn TEXT, publisher TEXT, year INTEGER CHECK (year BETWEEN 1 AND 2099),
  pages INTEGER CHECK (pages > 0), genre TEXT, location TEXT,
  status TEXT DEFAULT 'available' CHECK (status IN ('available','borrowed','lost')),
  copies INTEGER DEFAULT 1 CHECK (copies > 0),
  description TEXT, notes TEXT,
  rating INTEGER DEFAULT 0 CHECK (rating BETWEEN 0 AND 5),
  read_status TEXT DEFAULT 'unread' CHECK (read_status IN ('unread','reading','read','want','paused')),
  current_page INTEGER DEFAULT 0 CHECK (current_page >= 0),
  language TEXT DEFAULT 'Türkçe',
  cover_url TEXT, buy_url TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE books ENABLE ROW LEVEL SECURITY;
CREATE POLICY "owner" ON books FOR ALL
  USING (auth.uid() = user_id)
  WITH CHECK (auth.uid() = user_id);

-- Raflar tablosu
CREATE TABLE IF NOT EXISTS shelves (
  code TEXT, name TEXT NOT NULL,
  user_id UUID REFERENCES auth.users(id),
  created_at TIMESTAMPTZ DEFAULT NOW(),
  PRIMARY KEY (code, user_id)
);
ALTER TABLE shelves ENABLE ROW LEVEL SECURITY;
CREATE POLICY "owner" ON shelves FOR ALL
  USING (auth.uid() = user_id)
  WITH CHECK (auth.uid() = user_id);

-- Alıntılar tablosu
CREATE TABLE IF NOT EXISTS highlights (
  id TEXT PRIMARY KEY,
  user_id UUID REFERENCES auth.users(id),
  "bookId" TEXT, text TEXT, page INTEGER,
  type TEXT DEFAULT 'quote',
  "createdAt" TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE highlights ENABLE ROW LEVEL SECURITY;
CREATE POLICY "owner" ON highlights FOR ALL
  USING (auth.uid() = user_id)
  WITH CHECK (auth.uid() = user_id);

Veri Yönetimi