schema.sql

PRAGMA foreign_keys = OFF;

BEGIN TRANSACTION;

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

COMMIT;