marky

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

0003_archives.sql (290B)

      1 -- Archives table for plaintext dumps
      2 CREATE TABLE IF NOT EXISTS archives (
      3   bookmark_id INTEGER PRIMARY KEY REFERENCES bookmarks(id) ON DELETE CASCADE,
      4   content TEXT NOT NULL,
      5   archived_at TEXT NOT NULL
      6 );
      7 
      8 CREATE INDEX IF NOT EXISTS idx_archives_archived_at ON archives(archived_at);
      9