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);