-- Adds Schedule Campaign fields to existing MailMax installs.
ALTER TABLE campaigns_data ADD COLUMN schedule_enabled INTEGER NOT NULL DEFAULT 0;
ALTER TABLE campaigns_data ADD COLUMN schedule_start_time TEXT NULL;
ALTER TABLE campaigns_data ADD COLUMN schedule_stop_time TEXT NULL;
ALTER TABLE campaigns_data ADD COLUMN schedule_days_json TEXT NULL;
ALTER TABLE campaigns_data ADD COLUMN schedule_batch_quantity INTEGER NOT NULL DEFAULT 100;
ALTER TABLE campaigns_data ADD COLUMN schedule_timezone TEXT NULL;
ALTER TABLE campaigns_data ADD COLUMN schedule_last_run_at TEXT NULL;
ALTER TABLE campaigns_data ADD COLUMN schedule_next_run_at TEXT NULL;