package migrate

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

var _ = AddDBMigrateRecord(
	"202404101100",
	func(db *gorm.DB) error {
		err := db.Exec("ALTER TABLE `exports` ADD COLUMN `estimated_size` bigint(20) NOT NULL DEFAULT 0;").Error
		if err != nil {
			log.Error("add column `estimated_size` failed", zap.Error(err))
		}
		err = db.Exec("ALTER TABLE `exports` ADD COLUMN `metering_times` int NOT NULL DEFAULT 0;").Error
		if err != nil {
			log.Error("add column `metering_times` failed", zap.Error(err))
		}
		err = db.Exec("ALTER TABLE `exports` ADD COLUMN `snapshot_time` timestamp NULL DEFAULT NULL;").Error
		if err != nil {
			log.Error("add column `snapshot_time` failed", zap.Error(err))
		}
		return nil
	},
)