CREATE TABLE oficina_handoff_clock (
 id INTEGER PRIMARY KEY CHECK (id = 1),
 observed INTEGER NOT NULL
);
INSERT INTO oficina_handoff_clock (id, observed) VALUES (1, 0);
CREATE TABLE oficina_handoff_pending (
 secret_hash TEXT PRIMARY KEY,
 nonce_hash TEXT NOT NULL UNIQUE,
 sealed_path BLOB NOT NULL,
 created_at INTEGER NOT NULL,
 expires_at INTEGER NOT NULL
);
CREATE INDEX oficina_handoff_pending_expiry ON oficina_handoff_pending(expires_at);
CREATE TABLE oficina_handoff_inbox (
 handle_hash TEXT PRIMARY KEY,
 jti_hash TEXT NOT NULL UNIQUE,
 sealed_token BLOB NOT NULL,
 created_at INTEGER NOT NULL,
 expires_at INTEGER NOT NULL
);
CREATE INDEX oficina_handoff_inbox_expiry ON oficina_handoff_inbox(expires_at);
CREATE TABLE oficina_handoff_replay (
 jti_hash TEXT PRIMARY KEY,
 expires_at INTEGER NOT NULL
);
CREATE INDEX oficina_handoff_replay_expiry ON oficina_handoff_replay(expires_at);