20160502173036_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
== 20160502173036 AddLoginPreferenceToCustomers: migrating ====================
-- execute("      CREATE TYPE login_preference AS ENUM ('lz', 'clever');\n")
   -> 0.0145s
-- add_column(:customers, :login_preference, :login_preference, {:index=>true})
   -> 0.0160s
== 20160502173036 AddLoginPreferenceToCustomers: migrated (0.0307s) ===========

** 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 199548: failed to recognize type of 'login_preference'. It will be treated as String.