Sha256: 5c15ec3244c5c3598a63ca74504c8426fd788d4225815fced8382088e2d7254f

Contents?: true

Size: 512 Bytes

Versions: 34

Compression:

Stored size: 512 Bytes

Contents

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

Version data entries

34 entries across 34 versions & 1 rubygems

Version Path
redmine_extensions-0.0.39 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.38 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.37 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.11 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.10 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.36 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.34 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.09 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.07 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.06 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.05 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.04 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.03 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.33 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.02 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.1.01 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.29 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.28 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.27 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb
redmine_extensions-0.0.24 spec/redmine/db/migrate/20130201184705_add_unique_index_on_tokens_value.rb