package migration

import (
	"gorm.io/gorm"

	"github.com/tidbcloud/tidb-management-service/nextgen-global-service/infra/repoimpl/schema"
)

// add enum value to backup_settings.state and update indexes
var _ = AddDBMigrateRecord(
	"202507180001",
	func(db *gorm.DB) error {
		return db.Transaction(func(tx *gorm.DB) error {
			if err := tx.Exec(
				"ALTER TABLE backup_settings MODIFY COLUMN state ENUM('pending', 'created', 'deleted', 'expired', 'cleanup') NOT NULL;",
			).Error; err != nil {
				return err
			}
			return db.AutoMigrate(&schema.BackupSetting{})
		})
	},
)