-- Aggie-server counterpart of add_mail_account_backfill_completed_at.sql.
-- Idempotent — safe to re-run.
-- Deploy: mysql -u <user> -p 'stacie_Aggie_v1.0' < db/aggie_add_mail_account_backfill_completed_at.sql

USE `stacie_Aggie_v1.0`;

SET @col_exists = (
  SELECT COUNT(*) FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = 'stacie_Aggie_v1.0' AND TABLE_NAME = 'dim_mail_account' AND COLUMN_NAME = 'backfill_completed_at'
);

SET @ddl = IF(@col_exists = 0,
  'ALTER TABLE dim_mail_account ADD COLUMN backfill_completed_at TIMESTAMP NULL AFTER sync_cursor',
  'SELECT 1'
);

PREPARE stmt FROM @ddl;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;