diff options
Diffstat (limited to 'db/migrate')
| -rw-r--r-- | db/migrate/066_add_first_letter.rb | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/db/migrate/066_add_first_letter.rb b/db/migrate/066_add_first_letter.rb new file mode 100644 index 000000000..7878098e0 --- /dev/null +++ b/db/migrate/066_add_first_letter.rb @@ -0,0 +1,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 |