package migration

import (
	"gorm.io/gorm"
)

// Migration 202601240001: Add cloud_admin to cluster_passwords user enum
// Note: The data migration (creating cloud_admin password records and setting passwords in TiDB)
// is handled by the backfill worker, not in this migration.
var _ = AddDBMigrateRecord(
	"202601240001",
	func(db *gorm.DB) error {
		// Only do schema change: add 'cloud_admin' to the user enum
		// GORM AutoMigrate doesn't modify existing enum types, so we use raw SQL
		return db.Exec(
			"ALTER TABLE cluster_passwords MODIFY COLUMN user ENUM('root','platform_admin','maintenance_admin','cloud_admin') NOT NULL",
		).Error
	},
)