Query

billing.db — trouble_reports

SQL

CREATE TABLE trouble_reports  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  phone TEXT,
  name TEXT,
  location TEXT,
  category TEXT,
  description TEXT,
  status TEXT DEFAULT 'pending',
  assigned_to INTEGER,
  resolution TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
phone TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
location TEXT ✓ Rename | Drop
category TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
assigned_to INTEGER ✓ Rename | Drop
resolution TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_trouble_reports_assigned_to assigned_to SQL 
CREATE INDEX idx_trouble_reports_assigned_to
ON trouble_reports(assigned_to)
Drop
idx_trouble_reports_category category SQL 
CREATE INDEX idx_trouble_reports_category
ON trouble_reports(category)
Drop
idx_trouble_reports_created_at created_at SQL 
CREATE INDEX idx_trouble_reports_created_at
ON trouble_reports(created_at)
Drop
idx_trouble_reports_phone phone SQL 
CREATE INDEX idx_trouble_reports_phone
ON trouble_reports(phone)
Drop
idx_trouble_reports_status status SQL 
CREATE INDEX idx_trouble_reports_status
ON trouble_reports(status)
Drop