Query

billing.db — installation_job_stat...

SQL

CREATE TABLE installation_job_status_history  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  job_id INTEGER NOT NULL,
  old_status VARCHAR(50),
  new_status VARCHAR(50) NOT NULL,
  changed_by_type VARCHAR(20) NOT NULL,
  changed_by_id INTEGER NOT NULL,
  notes TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (job_id) REFERENCES installation_jobs(id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
job_id INTEGER Rename | Drop
old_status VARCHAR(50) ✓ Rename | Drop
new_status VARCHAR(50) Rename | Drop
changed_by_type VARCHAR(20) Rename | Drop
changed_by_id INTEGER Rename | Drop
notes TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
job_id installation_jobs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_job_history_job_id job_id SQL 
CREATE INDEX idx_job_history_job_id
ON installation_job_status_history(job_id)
Drop
idx_job_status_history_job job_id SQL 
CREATE INDEX idx_job_status_history_job
ON installation_job_status_history(job_id)
Drop