package migrate

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

var _ = AddDBMigrateRecord(
	"202412181630",
	func(db *gorm.DB) error {
		backupScheduleCheckJobs := "CREATE TABLE IF NOT EXISTS `backup_schedule_check_jobs` (" +
			"  `id` bigint(20) NOT NULL AUTO_INCREMENT," +
			"  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP," +
			"  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP," +
			"  `check_date` varchar(255) NOT NULL," +
			"  `state` enum('pending','succeeded','failed') NOT NULL DEFAULT 'pending'," +
			"  `execute_times` int NOT NULL DEFAULT 1," +
			"  `log_id` varchar(255) NULL," +
			"  PRIMARY KEY (`id`)," +
			"  UNIQUE INDEX `uk_check_date`(`check_date`)" +
			")"
		err := db.Exec(backupScheduleCheckJobs).Error
		if err != nil {
			log.Error("create table backup_schedule_check_jobs failed", zap.Error(err))
		}
		return nil
	},
)