Class: CreateJoinTables

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/reso/templates/create_join_tables.rb

Instance Method Summary collapse

Instance Method Details

#changeObject



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
# File 'lib/generators/reso/templates/create_join_tables.rb', line 2

def change
  create_join_table :businesses, :listings
  add_index(:businesses_listings, [:business_id, :listing_id], unique: true)
  add_index(:businesses_listings, :listing_id)

  create_join_table :enumerations, :listings
  add_index(:enumerations_listings, [:enumeration_id, :listing_id], unique: true)
  add_index(:enumerations_listings, :listing_id)

  create_join_table :listing_offices, :listings
  add_index(:listing_offices_listings, [:listing_office_id, :listing_id], unique: true, name: "index_listings_offices_listing_id_office_id")
  add_index(:listing_offices_listings, :listing_id)

  create_join_table :listings, :participants
  add_index(:listings_participants, [:participant_id, :listing_id], unique: true)
  add_index(:listings_participants, :listing_id)

  create_join_table :listings, :places
  add_index(:listings_places, [:listing_id, :place_id], unique: true)
  add_index(:listings_places, :listing_id)

  create_join_table :places, :schools
  add_index(:places_schools, [:place_id, :school_id], unique: true)

end