package migrate

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

var _ = AddDBMigrateRecord(
	"202604031600",
	func(db *gorm.DB) error {
		sql := "CREATE TABLE IF NOT EXISTS `instance_capacity_checkpoints` (" +
			"  `id` bigint unsigned NOT NULL," +
			"  `checkpoint` bigint NOT NULL," +
			"  `created_at` timestamp NOT NULL," +
			"  `updated_at` timestamp NULL DEFAULT NULL," +
			"  PRIMARY KEY (`id`)" +
			")"
		if err := db.Exec(sql).Error; err != nil {
			log.Error("create instance_capacity_checkpoints table failed", zap.String("sql", sql), zap.Error(err))
			return err
		}
		return nil
	},
)