blob: 84aad9cc8dc0255ef0a656287e14be1384c31439 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
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
# MySQL cannot index text blobs like this
if ActiveRecord::Base.connection.adapter_name != "MySQL"
add_index :public_bodies, :url_name, :unique => true
end
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
|