Query

app.db — bulk_campaigns

SQL

CREATE TABLE bulk_campaigns  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  instance_id INTEGER NOT NULL,
  name TEXT NOT NULL,
  message_template TEXT NOT NULL,
  is_personalized INTEGER DEFAULT 0,
  min_delay_seconds INTEGER DEFAULT 5,
  max_delay_seconds INTEGER DEFAULT 15,
  status TEXT DEFAULT 'pending',
  total_recipients INTEGER DEFAULT 0,
  sent_count INTEGER DEFAULT 0,
  failed_count INTEGER DEFAULT 0,
  created_at TEXT NOT NULL,
  started_at TEXT,
  completed_at TEXT,
  created_by INTEGER NOT NULL,
  send_after_seconds INTEGER,
  scheduled_start_at TEXT,
  media_file_id INTEGER,
  media_type TEXT,
  media_caption TEXT,
  run_at TEXT,
  task_enqueued_at TEXT,
  message_type TEXT NOT NULL DEFAULT 'text',
  meta_connection_id INTEGER,
  meta_template_name TEXT,
  meta_template_language TEXT,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (instance_id) REFERENCES evolution_instances(id) ON DELETE CASCADE,
  FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
instance_id INTEGER Rename | Drop
name TEXT Rename | Drop
message_template TEXT Rename | Drop
is_personalized INTEGER ✓ Rename | Drop
min_delay_seconds INTEGER ✓ Rename | Drop
max_delay_seconds INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
total_recipients INTEGER ✓ Rename | Drop
sent_count INTEGER ✓ Rename | Drop
failed_count INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
started_at TEXT ✓ Rename | Drop
completed_at TEXT ✓ Rename | Drop
created_by INTEGER Rename | Drop
send_after_seconds INTEGER ✓ Rename | Drop
scheduled_start_at TEXT ✓ Rename | Drop
media_file_id INTEGER ✓ Rename | Drop
media_type TEXT ✓ Rename | Drop
media_caption TEXT ✓ Rename | Drop
run_at TEXT ✓ Rename | Drop
task_enqueued_at TEXT ✓ Rename | Drop
message_type TEXT Rename | Drop
meta_connection_id INTEGER ✓ Rename | Drop
meta_template_name TEXT ✓ Rename | Drop
meta_template_language TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
created_by users.id
instance_id evolution_instances.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_bulk_campaigns_chatbot_id chatbot_id SQL 
CREATE INDEX idx_bulk_campaigns_chatbot_id
ON bulk_campaigns(chatbot_id)
Drop
idx_bulk_campaigns_created_at created_at SQL 
CREATE INDEX idx_bulk_campaigns_created_at
ON bulk_campaigns(created_at)
Drop
idx_bulk_campaigns_status status SQL 
CREATE INDEX idx_bulk_campaigns_status
ON bulk_campaigns(status)
Drop