Query

billing.db — voucher_delivery_logs

SQL

CREATE TABLE voucher_delivery_logs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  purchase_id INTEGER NOT NULL,
  phone TEXT NOT NULL,
  status TEXT NOT NULL CHECK (status IN ('sent', 'failed', 'error')),
  error_message TEXT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (purchase_id) REFERENCES voucher_purchases (id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
purchase_id INTEGER Rename | Drop
phone TEXT Rename | Drop
status TEXT Rename | Drop
error_message TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
purchase_id voucher_purchases.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_voucher_delivery_logs_created_at created_at SQL 
CREATE INDEX idx_voucher_delivery_logs_created_at
ON voucher_delivery_logs(created_at)
Drop
idx_voucher_delivery_logs_purchase_id purchase_id SQL 
CREATE INDEX idx_voucher_delivery_logs_purchase_id
ON voucher_delivery_logs(purchase_id)
Drop
idx_voucher_delivery_logs_status status SQL 
CREATE INDEX idx_voucher_delivery_logs_status
ON voucher_delivery_logs(status)
Drop