Forgot this.

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
+