package migration

import (
	"gorm.io/gorm"

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

// drop point_in_time_ts column from restores table and update indexes
var _ = AddDBMigrateRecord(
	"202507220001",
	func(db *gorm.DB) error {
		return db.Transaction(func(tx *gorm.DB) error {
			if err := tx.Exec("ALTER TABLE restores DROP COLUMN point_in_time_ts").Error; err != nil {
				return err
			}
			return db.AutoMigrate(&schema.Restore{})
		})
	},
)