diff .svn/pristine/1d/1d1a40d68d66d098f38161f4b90f0e887e1b73d9.svn-base @ 1295:622f24f53b42 redmine-2.3

Update to Redmine SVN revision 11972 on 2.3-stable branch

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/.svn/pristine/1d/1d1a40d68d66d098f38161f4b90f0e887e1b73d9.svn-base	Fri Jun 14 09:02:21 2013 +0100
@@ -0,0 +1,15 @@
+class AddUniqueIndexOnTokensValue < ActiveRecord::Migration
+  def up
+    say_with_time "Adding unique index on tokens, this may take some time..." do
+      # Just in case
+      duplicates = Token.connection.select_values("SELECT value FROM #{Token.table_name} GROUP BY value HAVING COUNT(id) > 1")
+      Token.where(:value => duplicates).delete_all
+  
+      add_index :tokens, :value, :unique => true, :name => 'tokens_value'
+    end
+  end
+
+  def down
+    remove_index :tokens, :name => 'tokens_value'
+  end
+end