13 lines
419 B
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);
|