defmodule DaProductApp.Repo.Migrations.CreateMiddlelayerAcquirer do
  use Ecto.Migration

  def up do
    execute("""
    CREATE TABLE IF NOT EXISTS acquirer (
      id INT NOT NULL AUTO_INCREMENT,
      name VARCHAR(45) NOT NULL,
      description VARCHAR(45) DEFAULT NULL,
      nii VARCHAR(5) DEFAULT NULL,
      acquirerInstitutionCode VARCHAR(45) DEFAULT NULL,
      PRIMARY KEY (id),
      UNIQUE KEY name_UNIQUE (name)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    """)
  end

  def down do
    execute("DROP TABLE IF EXISTS acquirer")
  end
end