annotate .svn/pristine/1d/1d1a40d68d66d098f38161f4b90f0e887e1b73d9.svn-base @ 1298:4f746d8966dd redmine_2.3_integration

Merge from redmine-2.3 branch to create new branch redmine-2.3-integration
author Chris Cannam
date Fri, 14 Jun 2013 09:28:30 +0100
parents 622f24f53b42
children
rev   line source
Chris@1295 1 class AddUniqueIndexOnTokensValue < ActiveRecord::Migration
Chris@1295 2 def up
Chris@1295 3 say_with_time "Adding unique index on tokens, this may take some time..." do
Chris@1295 4 # Just in case
Chris@1295 5 duplicates = Token.connection.select_values("SELECT value FROM #{Token.table_name} GROUP BY value HAVING COUNT(id) > 1")
Chris@1295 6 Token.where(:value => duplicates).delete_all
Chris@1295 7
Chris@1295 8 add_index :tokens, :value, :unique => true, :name => 'tokens_value'
Chris@1295 9 end
Chris@1295 10 end
Chris@1295 11
Chris@1295 12 def down
Chris@1295 13 remove_index :tokens, :name => 'tokens_value'
Chris@1295 14 end
Chris@1295 15 end