SQL

CREATE TABLE system_logs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  job_id TEXT,
  entity_id TEXT,
  status TEXT,
  -- 'success',
  'error',
  'pending'
    details TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
job_id TEXT ✓ Rename | Drop
entity_id TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
details TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_system_logs_job_id job_id SQL 
CREATE INDEX idx_system_logs_job_id
ON system_logs(job_id)
Drop