Query

app.db — bulk_recipients

SQL

CREATE TABLE bulk_recipients  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  campaign_id INTEGER NOT NULL,
  phone_number TEXT NOT NULL,
  recipient_name TEXT,
  custom_fields TEXT,
  status TEXT DEFAULT 'pending',
  error_message TEXT,
  sent_at TEXT,
  retry_count INTEGER DEFAULT 0,
  FOREIGN KEY (campaign_id) REFERENCES bulk_campaigns(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
campaign_id INTEGER Rename | Drop
phone_number TEXT Rename | Drop
recipient_name TEXT ✓ Rename | Drop
custom_fields TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
error_message TEXT ✓ Rename | Drop
sent_at TEXT ✓ Rename | Drop
retry_count INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
campaign_id bulk_campaigns.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_bulk_recipients_campaign_id campaign_id SQL 
CREATE INDEX idx_bulk_recipients_campaign_id
ON bulk_recipients(campaign_id)
Drop
idx_bulk_recipients_status status SQL 
CREATE INDEX idx_bulk_recipients_status
ON bulk_recipients(status)
Drop