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

package migrations

import "time"

// Id              int64
// Login           string `xorm:"UNIQUE NOT NULL"`
// Email           string `xorm:"UNIQUE NOT NULL"`
// Name            string
// FullName        string
// Password        string
// IsAdmin         bool
// Salt            string `xorm:"VARCHAR(10)"`
// Company         string
// NextDashboardId int
// UsingAccountId  int64
// Created         time.Time
// Updated         time.Time

func AddMigrations(mg *Migrator) {

	// TABLE Account
	// -------------------------------
	mg.AddMigration("create account table", new(RawSqlMigration).
		Sqlite(`
		  CREATE TABLE account (
		  	id                INTEGER PRIMARY KEY AUTOINCREMENT,
		  	login             TEXT NOT NULL,
		  	email             TEXT NOT NULL,
		  	name						  TEXT NULL,
		  	password		 		  TEXT NULL,
		  	salt							TEXT NULL,
		  	company						TEXT NULL,
		  	using_account_id  INTEGER NULL,
		  	is_admin					INTEGER NOT NULL,
		  	created           INTEGER NOT NULL,
		  	updated           INTEGER NOT NULL
			)
		`).
		Mysql(`
		  CREATE TABLE account (
		  	id								BIGINT NOT NULL AUTO_INCREMENT, PRIMARY KEY (id),
		  	login							VARCHAR(255) NOT NULL,
		  	email							VARCHAR(255) NOT NULL,
		  	name							VARCHAR(255) NULL,
		    password					VARCHAR(50) NULL,
				salt    					VARCHAR(50) NULL,
				company      			VARCHAR(255) NULL,
				using_account_id	BIGINT NULL,
				is_admin	        BOOL NOT NULL,
				created	          DATETIME NOT NULL,
				update	          DATETIME NOT NULL
		  )
		`))
	// ------------------------------
	mg.AddMigration("add index UIX_account.login", new(AddIndexMigration).
		Name("UIX_account_login").Table("account").Columns("login"))
	// ------------------------------
	// mg.AddMigration("add column", new(AddColumnMigration).
	// 	Table("account").Column("name").Type(DB_TYPE_STRING).Length(255))
}

type MigrationLog struct {
	Id          int64
	MigrationId string
	Sql         string
	Success     bool
	Error       string
	Timestamp   time.Time
}