SET NAMES utf8mb4;

ALTER TABLE scheduled_posts
  ADD COLUMN ab_experiment_id BIGINT UNSIGNED NULL AFTER tracked_link_id,
  ADD COLUMN ab_variant_id BIGINT UNSIGNED NULL AFTER ab_experiment_id,
  ADD INDEX idx_sp_ab_experiment(ab_experiment_id),
  ADD INDEX idx_sp_ab_variant(ab_variant_id),
  ADD CONSTRAINT fk_sp_ab_experiment FOREIGN KEY(ab_experiment_id) REFERENCES ab_experiments(id) ON DELETE SET NULL,
  ADD CONSTRAINT fk_sp_ab_variant FOREIGN KEY(ab_variant_id) REFERENCES ab_experiment_variants(id) ON DELETE SET NULL;
