How do I make a column unique and index it in a Ruby on Rails migration?

by

The short answer for old versions of Rails (see other answers for Rails 4+):

add_index :table_name, :column_name, unique: true

To index multiple columns together, you pass an array of column names instead of a single column name,

add_index :table_name, [:column_name_a, :column_name_b], unique: true

If you get “index name… is too long”, you can add name: "whatever" to the add_index method to make the name shorter.

For fine-grained control, there’s a “execute” method that executes straight SQL.

That’s it!

If you are doing this as a replacement for regular old model validations, check to see how it works. The error reporting to the user will likely not be as nice without model-level validations. You can always do both.

More Related Contents:

  1. Explain like I'm LITERALLY five…what does it mean to "format" a string? [closed]
  2. How to change default timezone for Active Record in Rails?
  3. Understanding the Rails Authenticity Token
  4. form_for with nested resources
  5. Why do routes with a dot in a parameter fail to match?
  6. Passing parameters in rails redirect_to
  7. Installing Bootstrap 3 on Rails App
  8. Rails 4 Authenticity Token
  9. Rails 5: ActiveRecord OR query
  10. Convert a Ruby on Rails app from sqlite to MySQL?
  11. Rails association with multiple foreign keys
  12. How to fix the uninitialized constant Rake::DSL problem on Heroku?
  13. Heroku/devise – Missing host to link to! Please provide :host parameter or set default_url_options[:host]
  14. Rails 3 submit a form with multiple records
  15. How do I wrap link_to around some html ruby code?
  16. Getting fields_for and accepts_nested_attributes_for to work with a belongs_to relationship
  17. Ruby-on-Rails: Multiple has_many :through possible?
  18. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  19. Rails Paperclip how to delete attachment?
  20. Scope with join on :has_many :through association
  21. Ruby on Rails – Validate a Cost
  22. How to implement bulk insert in Rails 3
  23. Adding extra registration fields with Devise
  24. String.force_encoding() in Ruby 1.8.7 (or Rails 2.x)
  25. Changing a column type to longer strings in rails
  26. Error message: Make sure that `gem install pg -v ‘0.18.1’` succeeds before bundling
  27. Non persistent ActiveRecord model attributes
  28. Rails 4.0 expire_fragment/cache expiration not working
  29. Why won’t Heroku accept my Gemfile.lock in Windows?
  30. How to skip a before_filter for Devise’s SessionsController?

Leave a Comment