From d9565811f075273fbc3318af173fe4a21e14ae58 Mon Sep 17 00:00:00 2001 From: Alex Handley Date: Sat, 16 Apr 2016 13:26:05 +0100 Subject: [ci skip] docs for add_references index option - Add link for finding the addional options for index. - Add example for unique index as this is a common requirement. - Add link in guide for index options. --- .../connection_adapters/abstract/schema_statements.rb | 11 ++++++++++- guides/source/active_record_migrations.md | 3 ++- 2 files changed, 12 insertions(+), 2 deletions(-) diff --git a/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb b/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb index 020d9bbdca..da0c961142 100644 --- a/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb +++ b/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb @@ -776,7 +776,8 @@ module ActiveRecord # [:type] # The reference column type. Defaults to +:integer+. # [:index] - # Add an appropriate index. Defaults to false. + # Add an appropriate index. Defaults to false. + # See #add_index for usage of this option. # [:foreign_key] # Add an appropriate foreign key constraint. Defaults to false. # [:polymorphic] @@ -796,6 +797,14 @@ module ActiveRecord # # add_reference(:products, :supplier, polymorphic: true, index: true) # + # ====== Create a supplier_id column with a unique index + # + # add_reference(:products, :supplier, index: { unique: true }) + # + # ====== Create a supplier_id column with a named index + # + # add_reference(:products, :supplier, index: { name: "my_supplier_index" }) + # # ====== Create a supplier_id column and appropriate foreign key # # add_reference(:products, :supplier, foreign_key: true) diff --git a/guides/source/active_record_migrations.md b/guides/source/active_record_migrations.md index cd6b7fdd67..31f6f26b2a 100644 --- a/guides/source/active_record_migrations.md +++ b/guides/source/active_record_migrations.md @@ -246,7 +246,8 @@ class AddUserRefToProducts < ActiveRecord::Migration[5.0] end ``` -This migration will create a `user_id` column and appropriate index. +This migration will create a `user_id` column and appropriate index. +For more `add_reference` options, visit the [API documentation](http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/SchemaStatements.html#method-i-add_reference). There is also a generator which will produce join tables if `JoinTable` is part of the name: -- cgit v1.2.3