package migrate

import (
	"fmt"

	"gorm.io/gorm"
)

const caseSensitiveUserEmailDDL = `
	ALTER TABLE tidbcloud_users
	MODIFY COLUMN email varchar(320)
	CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
`

var _ = addRecord("202607301300", makeUserEmailCaseSensitive)

func makeUserEmailCaseSensitive(db *gorm.DB) error {
	if db.Dialector.Name() != "mysql" {
		return nil
	}
	if err := db.Exec(caseSensitiveUserEmailDDL).Error; err != nil {
		return fmt.Errorf("make user email case-sensitive: %w", err)
	}
	return nil
}