diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/066_add_first_letter.rb | 12 | ||||
| -rw-r--r-- | db/schema.rb | 4 |
2 files changed, 15 insertions, 1 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 diff --git a/db/schema.rb b/db/schema.rb index 193e50378..496df6f0c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -9,7 +9,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 65) do +ActiveRecord::Schema.define(:version => 66) do create_table "acts_as_xapian_jobs", :force => true do |t| t.string "model", :null => false @@ -111,8 +111,10 @@ ActiveRecord::Schema.define(:version => 65) do t.text "url_name", :null => false t.text "home_page", :default => "", :null => false t.text "notes", :default => "", :null => false + t.string "first_letter", :null => false end + add_index "public_bodies", ["first_letter"], :name => "index_public_bodies_on_first_letter" add_index "public_bodies", ["url_name"], :name => "index_public_bodies_on_url_name", :unique => true create_table "public_body_tags", :force => true do |t| |