package migrate

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

var _ = AddDBMigrateRecord(
	"202401031300",
	func(db *gorm.DB) error {
		ddl := "CREATE TABLE IF NOT EXISTS `backups` (" +
			" `id` bigint unsigned NOT NULL AUTO_INCREMENT," +
			" `created_at` timestamp NOT NULL," +
			" `updated_at` timestamp NULL DEFAULT NULL," +
			" `deleted_at` timestamp NULL DEFAULT NULL," +
			" `region` varchar(64) NOT NULL," +
			" `name` varchar(255) NOT NULL," +
			" `backup_id` bigint unsigned NOT NULL," +
			" `backup_time` timestamp NOT NULL," +
			" PRIMARY KEY (`id`)," +
			" KEY `idx_region_time` (`region`,`backup_time`)" +
			")"
		err := db.Exec(ddl).Error
		if err != nil {
			log.Error("create table backups failed", zap.Error(err))
		}
		return nil
	},
)