package migrate

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

var _ = AddDBMigrateRecord(
	"202507071930",
	func(db *gorm.DB) error {
		err := db.Exec(`ALTER TABLE audit_log_schedules
		        ADD COLUMN rotation_interval_seconds bigint(20) NULL DEFAULT 3600,
				ADD COLUMN rotation_size_bytes bigint(20) NULL DEFAULT 104857600,
				ADD COLUMN cloud_storage_type varchar(64) NULL DEFAULT NULL,
				ADD COLUMN unredacted boolean NULL DEFAULT false,
				ADD COLUMN cloud_storage json NULL DEFAULT NULL;`).Error
		if err != nil {
			log.Error("failed to alter table audit_log_schedules", zap.Error(err))
			return err
		}
		return nil
	},
)