Class: CreateNameSearchTables

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

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



29
30
31
32
33
34
 
# File 'lib/generators/name_search/migration/templates/migration.rb', line 29

def self.down
  drop_table :name_search_names
  drop_table :name_search_nick_name_family_joins
  drop_table :name_search_nick_name_families
  drop_table :name_search_searchables
end

.up ⇒ Object 



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
27
 
# File 'lib/generators/name_search/migration/templates/migration.rb', line 2

def self.up
  create_table :name_search_names do |t|
    t.string  :value
  end
  add_index :name_search_names, :value

  create_table :name_search_nick_name_family_joins do |t|
    t.integer :name_id
    t.integer :nick_name_family_id
  end
  add_index :name_search_nick_name_family_joins, :name_id
  add_index :name_search_nick_name_family_joins, :nick_name_family_id, name: 'index_name_search_nick_name_family_joins_on_nick_name_family'
   
  create_table :name_search_nick_name_families do |t|
  end

  create_table :name_search_searchables do |t|
    t.integer :name_id
    t.integer :searchable_id
    t.string  :searchable_type
  end
  add_index :name_search_searchables, :name_id
  add_index :name_search_searchables,
    [:searchable_id, :searchable_type],
    :name => 'index_name_search_searchable'
end