schema.sql

PRAGMA foreign_keys = OFF;

BEGIN TRANSACTION;

CREATE TABLE cache (
    url TEXT PRIMARY KEY NOT NULL,
    title TEXT NOT NULL,
    entries json,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);

COMMIT;