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

  def up do
    execute("""
    CREATE TABLE IF NOT EXISTS address (
      id INT NOT NULL AUTO_INCREMENT,
      line1 VARCHAR(45) DEFAULT NULL,
      line2 VARCHAR(45) DEFAULT NULL,
      line3 VARCHAR(45) DEFAULT NULL,
      line4 VARCHAR(45) DEFAULT NULL,
      city VARCHAR(45) DEFAULT NULL,
      state VARCHAR(45) DEFAULT NULL,
      country VARCHAR(45) DEFAULT NULL,
      postalcode VARCHAR(45) DEFAULT NULL,
      PRIMARY KEY (id)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    """)
  end

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