Query
CREATE TABLE payment_status_changes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
patrocinio_id INTEGER NOT NULL REFERENCES patrocinios(id) ON DELETE CASCADE,
old_status TEXT,
new_status TEXT NOT NULL,
changed_by INTEGER REFERENCES users(id) ON DELETE SET NULL,
created_at TEXT NOT NULL DEFAULT (datetime('now','localtime'))
)