aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate/037_add_url_name.rb
blob: 0a667e0d3ee41872f026bcef3d993e661976e0a4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
class AddUrlName < ActiveRecord::Migration
    def self.up
        add_column :public_bodies, :url_name, :text
        add_column :public_body_versions, :url_name, :text

        PublicBody.find(:all).each do |public_body|
            public_body.update_url_name
            public_body.save!
        end
        add_index :public_bodies, :url_name, :unique => true
        change_column :public_bodies, :url_name, :text, :null => false
    end

    def self.down
        remove_column :public_bodies, :url_name
        remove_column :public_body_versions, :url_name
    end
end