Files
app__cliphoard/migrations/001_initial.sql

13 lines
419 B
SQL

CREATE TABLE entries (
id INTEGER PRIMARY KEY,
content TEXT NOT NULL,
content_hash TEXT NOT NULL,
created_at INTEGER NOT NULL,
last_used_at INTEGER NOT NULL,
pinned INTEGER NOT NULL DEFAULT 0 CHECK (pinned IN (0, 1))
);
CREATE INDEX idx_entries_hash ON entries(content_hash);
CREATE INDEX idx_entries_last_used ON entries(last_used_at DESC);
CREATE INDEX idx_entries_pinned ON entries(pinned);