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

  def up do
    execute("""
    CREATE TABLE IF NOT EXISTS acquirer_connection (
      id INT NOT NULL AUTO_INCREMENT,
      acquirer_id INT DEFAULT NULL,
      ip_address VARCHAR(45) NOT NULL,
      port INT NOT NULL,
      is_ssl TINYINT DEFAULT NULL,
      keystore_path VARCHAR(255) DEFAULT NULL,
      keystore_password VARCHAR(45) DEFAULT NULL,
      truststore_path VARCHAR(255) DEFAULT NULL,
      truststore_password VARCHAR(45) DEFAULT NULL,
      tpdu VARCHAR(45) DEFAULT NULL,
      length_mode VARCHAR(45) DEFAULT NULL,
      PRIMARY KEY (id),
      KEY id_idx (acquirer_id)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    """)
  end

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