aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate/039_request_url_names.rb
blob: 5227b887a0640ef22c6e043952eb6af581ee21e0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
class RequestUrlNames < ActiveRecord::Migration
    def self.up
        add_column :info_requests, :url_title, :text

        InfoRequest.find(:all).each do |info_request|
            info_request.update_url_title
            info_request.save!
        end
        # MySQL cannot index text blobs like this
        if ActiveRecord::Base.connection.adapter_name != "MySQL"
            add_index :info_requests, :url_title, :unique => true
        end
        change_column :info_requests, :url_title, :text, :null => false
    end

    def self.down
        remove_column :info_requests, :url_title
    end
end