package migrate

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

var _ = AddDBMigrateRecord(
	"202306291500",
	func(db *gorm.DB) error {
		err := db.Exec(`CREATE TABLE IF NOT EXISTS downtimes (
			cluster_id varchar(191) NOT NULL,
			down_time timestamp NOT NULL,
			down_rate decimal(20,2) NOT NULL,
			region longtext NOT NULL,
			month varchar(191) NOT NULL,
			updated_at timestamp NOT NULL,
			PRIMARY KEY (cluster_id,down_time),
			KEY idx_month (month)
		  )`).Error
		if err != nil {
			log.Error("failed to create table downtimes", zap.Error(err))
		}
		return nil
	},
)