energylink/pkg/services/sqlstore/migrations/login_attempt_mig.go

package migrations

import . "github.com/grafana/grafana/pkg/services/sqlstore/migrator"

func addLoginAttemptMigrations(mg *Migrator) {
	loginAttemptV1 := Table{
		Name: "login_attempt",
		Columns: []*Column{
			{Name: "id", Type: DB_BigInt, IsPrimaryKey: true, IsAutoIncrement: true},
			{Name: "username", Type: DB_NVarchar, Length: 190, Nullable: false},
			{Name: "ip_address", Type: DB_NVarchar, Length: 30, Nullable: false},
			{Name: "created", Type: DB_DateTime, Nullable: false},
		},
		Indices: []*Index{
			{Cols: []string{"username"}},
		},
	}

	// create table
	mg.AddMigration("create login attempt table", NewAddTableMigration(loginAttemptV1))
	// add indices
	mg.AddMigration("add index login_attempt.username", NewAddIndexMigration(loginAttemptV1, loginAttemptV1.Indices[0]))

	loginAttemptV2 := Table{
		Name: "login_attempt",
		Columns: []*Column{
			{Name: "id", Type: DB_BigInt, IsPrimaryKey: true, IsAutoIncrement: true},
			{Name: "username", Type: DB_NVarchar, Length: 190, Nullable: false},
			{Name: "ip_address", Type: DB_NVarchar, Length: 30, Nullable: false},
			{Name: "created", Type: DB_Int, Default: "0", Nullable: false},
		},
		Indices: []*Index{
			{Cols: []string{"username"}},
		},
	}

	addTableReplaceMigrations(mg, loginAttemptV1, loginAttemptV2, 2, map[string]string{
		"id":         "id",
		"username":   "username",
		"ip_address": "ip_address",
	})
}