db/migrate/066_add_first_letter.rb


1
2
3
4
5
6
7
8
9
10
11
12

class AddFirstLetter < ActiveRecord::Migration
    def self.up
        add_column :public_bodies, :first_letter, :string
        add_index :public_bodies, :first_letter
        PublicBody.update_all "first_letter = upper(substr(name, 1, 1))"
        change_column :public_bodies, :first_letter, :string, :null => false
    end

    def self.down
        remove_column :public_bodies, :first_letter
    end
end