Migration file

20150616044727_add_auth_info_to_users.exs

defmodule HelloPhoenix.Repo.Migrations.AddAuthInfoToUsers do
  use Ecto.Migration

  def up do
  	"""
  	  ALTER TABLE users ADD COLUMN username varchar(200);
  	  ALTER TABLE users ADD COLUMN hash varchar(130);
  	  ALTER TABLE users ADD COLUMN recovery_hash varchar(130);
  	  ALTER TABLE users ADD CONSTRAINT u_constraint UNIQUE (email);
		"""
  end

  def down do
  	"""
  	  ALTER TABLE users DROP COLUMN username varchar(200);
  	  ALTER TABLE users DROP COLUMN hash varchar(130);
  	  ALTER TABLE users DROP COLUMN recovery_hash varchar(130);
  	  ALTER TABLE users DROP CONSTRAINT u_constraint UNIQUE (email);
		"""
  end
end