package migrate_record

import (
	"github.com/pingcap/dbaas/billing2/db/entity"
	"gorm.io/gorm"
)

var _ = AddMigrateRecord(
	"2023-10-20-1",
	func(db *gorm.DB) error {
		err := db.AutoMigrate(entity.Models...)
		if err != nil {
			return err
		}
		alterIndex1 := "DROP INDEX tenant_recharge_plan on `tenant_recharge_credits_plans`;"
		alterIndex2 := "ALTER TABLE `tenant_recharge_credits_plans` ADD UNIQUE tenant_recharge_plan (`tenant_id`, `main_plan_id`, `filter_ids`, `deleted_unique_key_mark`);"
		return db.Exec(alterIndex1).Exec(alterIndex2).Error
	},
)