SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
command_type TEXT Rename | Drop
target_entity TEXT ✓ Rename | Drop
target_id TEXT ✓ Rename | Drop
parameters TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
executed_at DATETIME ✓ Rename | Drop
result TEXT ✓ Rename | Drop
error TEXT ✓ Rename | Drop
cmd_id TEXT ✓ Rename | Drop
cmd_type TEXT ✓ Rename | Drop
target_ref TEXT ✓ Rename | Drop
payload_json TEXT ✓ Rename | Drop
requested_by TEXT ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop
attempts INTEGER ✓ Rename | Drop
last_error TEXT ✓ Rename | Drop
assigned_to TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_commands_assigned_to assigned_to SQL 
CREATE INDEX idx_commands_assigned_to
ON commands(assigned_to)
Drop
idx_commands_cmd_id cmd_id SQL 
CREATE INDEX idx_commands_cmd_id
ON commands(cmd_id)
Drop
idx_commands_status
  • status
  • created_at
 SQL 
CREATE INDEX idx_commands_status
ON commands(status, created_at)
Drop