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

  def up do
    execute("""
    CREATE TABLE IF NOT EXISTS transaction (
      id INT NOT NULL AUTO_INCREMENT,
      pan VARCHAR(45) DEFAULT NULL,
      proc_code VARCHAR(45) DEFAULT NULL,
      amount VARCHAR(45) DEFAULT NULL,
      stan VARCHAR(45) DEFAULT NULL,
      date_time VARCHAR(45) DEFAULT NULL,
      settlement_date VARCHAR(45) DEFAULT NULL,
      mcc VARCHAR(45) DEFAULT NULL,
      terminal_id VARCHAR(45) DEFAULT NULL,
      merchant_id VARCHAR(45) DEFAULT NULL,
      reference_id VARCHAR(45) DEFAULT NULL,
      auth_code VARCHAR(45) DEFAULT NULL,
      response_code VARCHAR(45) DEFAULT NULL,
      upi_url VARCHAR(511) DEFAULT NULL,
      upi_info VARCHAR(1023) DEFAULT NULL,
      meta_data VARCHAR(45) DEFAULT NULL,
      date_added DATETIME DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (id)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    """)
  end

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