marky

Lightweight bookmarking + plaintext archive
Log | Files | Refs | README | LICENSE

0002_bookmarks.sql (455B)

      1 -- Bookmarks table (owned by users)
      2 CREATE TABLE IF NOT EXISTS bookmarks (
      3   id INTEGER PRIMARY KEY AUTOINCREMENT,
      4   url TEXT NOT NULL,
      5   title TEXT NOT NULL,
      6   description TEXT,
      7   public INTEGER NOT NULL DEFAULT 0,
      8   user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
      9   created_at TEXT NOT NULL,
     10   updated_at TEXT NOT NULL
     11 );
     12 
     13 -- Per-user URL uniqueness
     14 CREATE UNIQUE INDEX IF NOT EXISTS idx_bookmarks_user_url ON bookmarks(user_id, url);
     15