+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop