1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/042_unique_user_urls.rb b/db/migrate/042_unique_user_urls.rb
new file mode 100644
index 000000000..1350d1580
--- /dev/null
+++ b/db/migrate/042_unique_user_urls.rb
@@ -0,0 +1,17 @@
+class UniqueUserUrls < ActiveRecord::Migration
+    def self.up
+        # do last registered ones first, so the last ones get rubbish URLs
+        User.find(:all, :order => "id desc").each do |user|
+            user.update_url_name
+            user.save!
+        end
+        remove_index :users, :url_name
+        add_index :users, :url_name, :unique => true
+    end
+
+    def self.down
+        remove_index :users, :url_name
+        add_index :users, :url_name, :unique => false
+    end
+
+end