package migrate

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

var _ = AddDBMigrateRecord(
	"202609041200",
	func(db *gorm.DB) error {
		const statement = "ALTER TABLE `branches` ADD INDEX `idx_branches_status_created_at` (`status`, `created_at`)"
		if err := db.Exec(statement).Error; err != nil {
			log.Error("add branch lifecycle polling index failed", zap.Error(err))
			return err
		}
		return nil
	},
)