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

  def up do
    execute("""
    CREATE TABLE IF NOT EXISTS pos_terminal (
      id INT NOT NULL AUTO_INCREMENT,
      terminalid VARCHAR(15) NOT NULL,
      serial_number VARCHAR(45) DEFAULT NULL,
      pos_merchant_id INT DEFAULT NULL,
      PRIMARY KEY (id),
      KEY pos_merchant_id_fk_idx (pos_merchant_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    """)
  end

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