package migrate

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

var _ = AddDBMigrateRecord(
	"202601270930",
	func(db *gorm.DB) error {
		addHostedZoneID := "ALTER TABLE `plc_attach_domains` ADD COLUMN `hosted_zone_id` VARCHAR(255) DEFAULT NULL"
		if err := db.Exec(addHostedZoneID).Error; err != nil {
			log.Error("add column 'hosted_zone_id' to `plc_attach_domains` failed", zap.Error(err))
			return err
		}
		addVPCAttached := "ALTER TABLE `plc_attach_domains` ADD COLUMN `vpc_attached` TINYINT(1) NOT NULL DEFAULT 0"
		if err := db.Exec(addVPCAttached).Error; err != nil {
			log.Error("add column 'vpc_attached' to `plc_attach_domains` failed", zap.Error(err))
			return err
		}
		return nil
	},
)