PRAGMA journal_mode = WAL; PRAGMA foreign_keys = ON; CREATE TABLE reservations ( id INTEGER PRIMARY KEY, room TEXT NOT NULL, starts_at TEXT NOT NULL, request TEXT NOT NULL ); CREATE TABLE outbox ( reservation_id INTEGER PRIMARY KEY REFERENCES reservations(id), done INTEGER NOT NULL DEFAULT 0 CHECK (done IN (0, 1)) ); CREATE TABLE receipts ( reservation_id INTEGER PRIMARY KEY REFERENCES reservations(id) );