package migrate

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

var _ = AddDBMigrateRecord(
	"202607191200",
	func(db *gorm.DB) error {
		sql := "ALTER TABLE `exports` " +
			"MODIFY COLUMN `state` enum('preparing','running','succeed','canceled','failed','deleted') NULL DEFAULT NULL, " +
			"ADD COLUMN `encrypted_create_payload` text NULL, " +
			"ADD COLUMN `proxy_endpoint` varchar(1024) NULL"
		if err := db.Exec(sql).Error; err != nil {
			log.Error(
				"add preparing export state, encrypted create payload, and proxy endpoint failed",
				zap.String("sql", sql),
				zap.Error(err),
			)
			return err
		}
		return nil
	},
)