package migrate

import (
	"gorm.io/gorm"
)

// add index for tabel 'core_events'
var _ = AddCoreMigrateRecord(
	"202307061143",
	func(db *gorm.DB) error {
		if err := db.Exec("alter table core_events modify column `topic` varchar(255) NOT NULL;").Error; err != nil {
			return err
		}
		if err := db.Exec("alter table core_events modify column `uuid` varchar(255) NOT NULL;").Error; err != nil {
			return err
		}
		return db.Exec("ALTER TABLE core_events ADD INDEX `idx_topic_status_created_at` (`topic`, `status`, `created_at`)").Error
	},
)