Add Column
Current Schema
CREATE TABLE audit_log (
id TEXT PRIMARY KEY,
event_type TEXT NOT NULL,
entity_type TEXT NOT NULL,
entity_id TEXT NOT NULL,
entity_data TEXT,
performed_by TEXT,
performed_at DATETIME DEFAULT CURRENT_TIMESTAMP,
organisation_id TEXT,
FOREIGN KEY (performed_by) REFERENCES users(id) ON DELETE SET NULL,
FOREIGN KEY (organisation_id) REFERENCES organisations(id) ON DELETE CASCADE
)