CREATE TABLE domains (
    id          TEXT          PRIMARY KEY,
    tenant      TEXT NOT NULL REFERENCES tenants(id) ON DELETE CASCADE,
    domain      TEXT NOT NULL,
    verified_at DATETIME
);

CREATE INDEX idx_domains_tenant ON domains(tenant);

CREATE TABLE domain_verification_tasks (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    payload TEXT NOT NULL,
    status TEXT NOT NULL DEFAULT 'pending',
    attempts INTEGER NOT NULL DEFAULT 0,
    run_after TEXT NOT NULL DEFAULT (datetime('now')),
    lease_until TEXT,
    created_at TEXT NOT NULL DEFAULT (datetime('now'))
);