package migrate

import (
	"github.com/pingcap/log"
	"go.uber.org/zap"
	"gorm.io/gorm"
)

var _ = AddDBMigrateRecord(
	"202603161900",
	func(db *gorm.DB) error {
		sql := "ALTER TABLE `cdc_changefeeds` ADD INDEX `idx_cdc_changefeeds_state_failed_time` (`state`, `failed_time`)"
		if err := db.Exec(sql).Error; err != nil {
			log.Error("add cdc failed_time index failed", zap.String("sql", sql), zap.Error(err))
			return err
		}

		sql = "ALTER TABLE `dm_tasks` ADD INDEX `idx_dm_tasks_stage_failed_time` (`stage`, `failed_time`)"
		if err := db.Exec(sql).Error; err != nil {
			log.Error("add dm failed_time index failed", zap.String("sql", sql), zap.Error(err))
			return err
		}
		return nil
	},
)