aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--db/migrate/039_request_url_names.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/039_request_url_names.rb b/db/migrate/039_request_url_names.rb
new file mode 100644
index 000000000..0572cab7e
--- /dev/null
+++ b/db/migrate/039_request_url_names.rb
@@ -0,0 +1,17 @@
+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
+ add_index :info_requests, :url_title, :unique => true
+ change_column :info_requests, :url_title, :text, :null => false
+ end
+
+ def self.down
+ remove_column :info_requests, :url_title
+ end
+end
+