package migration

import (
	"gorm.io/gorm"
)

var _ = AddDBMigrateRecord(
	"202409291700",
	func(db *gorm.DB) error {
		if err := db.Exec("ALTER TABLE `private_link_endpoints` DROP INDEX `uniq_cid_epid`").Error; err != nil {
			return err
		}

		if err := db.Exec(
			"ALTER TABLE `private_link_endpoints` ADD UNIQUE INDEX `uniq_cid_epid_del` (`cluster_id`, `endpoint_id`, `deleted_at`);",
		).Error; err != nil {
			return err
		}

		return nil
	},
)