20160502220701_add_login_preference_to_customers.rb

class AddLoginPreferenceToCustomers < ActiveRecord::Migration
  def up
    execute <<-SQL
      CREATE TYPE loginpreference AS ENUM ('lz', 'clever');
    SQL

    add_column :customers, :loginpreference, :loginpreference, index: true
  end

  def down
    remove_column :customers, :loginpreference

    execute <<-SQL
      DROP TYPE loginpreference;
    SQL
  end
end

db:migrate

** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
== 20160502220701 AddLoginPreferenceToCustomers: migrating ====================
-- execute("      CREATE TYPE loginpreference AS ENUM ('lz', 'clever');\n")
   -> 0.0144s
-- add_column(:customers, :loginpreference, :loginpreference, {:index=>true})
   -> 0.0166s
== 20160502220701 AddLoginPreferenceToCustomers: migrated (0.0311s) ===========

** Invoke db:_dump (first_time)
** Execute db:_dump
** Invoke db:schema:dump (first_time)
** Invoke environment
** Invoke db:load_config
** Invoke schema_plus:load (first_time)
** Execute schema_plus:load
** Execute db:schema:dump
unknown OID 199556: failed to recognize type of 'loginpreference'. It will be treated as String.