From 8b010e85e362245eece363682895fa0c445dc83b Mon Sep 17 00:00:00 2001
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: Fri, 1 Feb 2013 20:04:38 +0000
Subject: Add unique index on tokens.value.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@11295 e93f8b46-1217-0410-a6f0-8f06a7374b81
---
.../20130201184705_add_unique_index_on_tokens_value.rb | 15 +++++++++++++++
1 file changed, 15 insertions(+)
create mode 100644 db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
diff --git a/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb b/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
new file mode 100644
index 000000000..fdec9f8ee
--- /dev/null
+++ b/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
@@ -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
--
cgit v1.2.3