gohub/database/migrations/2025_06_03_101326_add_users_table.go

package migrations

import (
	"gorm.io/gorm"

	"github.com/runningwater/gohub/app/models"
	"github.com/runningwater/gohub/pkg/migrate"
)

func init() {

	type User struct {
		models.BaseModel

		Name     string `gorm:"type:varchar(255);not null;index"`
		Email    string `gorm:"type:varchar(255);index;default:null"`
		Phone    string `gorm:"type:varchar(20);index;default:null"`
		Password string `gorm:"type:varchar(255)"`

		models.CommonTimestampsField
	}

	up := func(migrator gorm.Migrator, DB *gorm.DB) {
		_ = DB.Set("gorm:table_options", "ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci").AutoMigrate(&User{})
	}

	down := func(migrator gorm.Migrator, DB *gorm.DB) {
		_ = migrator.DropTable(&User{})
	}

	migrate.Add(up, down, "2025_06_03_101326_add_users_table")
}