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
)