Class: AddIndexes

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/tmis/engine/migrations/12_add_indexes.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
27
28
29
30
31
# File 'lib/tmis/engine/migrations/12_add_indexes.rb', line 2

def change
  add_index(:groups, :title)

  add_index(:subgroups, :group_id)
  add_index(:subgroups, :number)

  add_index(:subjects, :title)

  add_index(:cabinets, :title)

  add_index(:lecturers, :surname)

  add_index(:studies, :subject_id)
  add_index(:studies, :lecturer_id)
  add_index(:studies, :cabinet_id)
  add_index(:studies, [:groupable_id, :groupable_type])

  add_index(:courses, :number)

  add_index(:specialities, :title)

  add_index(:semesters, :course_id)
  add_index(:semesters, :title)

  add_index(:speciality_subjects, :subject_id)
  add_index(:speciality_subjects, :lecturer_id)
  add_index(:speciality_subjects, [:speciality_id, :semester_id])

  add_index(:emails, [:emailable_id, :emailable_type])
end