Add Column
Current Schema
CREATE TABLE commands (
id INTEGER PRIMARY KEY AUTOINCREMENT,
command_type TEXT NOT NULL,
target_entity TEXT,
target_id TEXT,
parameters TEXT,
status TEXT DEFAULT 'pending',
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
executed_at DATETIME,
result TEXT,
error TEXT,
cmd_id TEXT,
cmd_type TEXT,
target_ref TEXT,
payload_json TEXT,
requested_by TEXT DEFAULT 'system',
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
attempts INTEGER DEFAULT 0,
last_error TEXT,
assigned_to TEXT
)