mirror of
https://github.com/TracksApp/tracks.git
synced 2025-12-16 07:10:12 +01:00
23 lines
739 B
Ruby
23 lines
739 B
Ruby
class AddIndices < ActiveRecord::Migration[5.2]
|
|
def self.up
|
|
add_index :todos, [:user_id, :state]
|
|
add_index :todos, [:user_id, :project_id]
|
|
add_index :todos, [:project_id]
|
|
add_index :todos, [:context_id]
|
|
add_index :todos, [:user_id, :context_id]
|
|
add_index :preferences, :user_id
|
|
add_index :projects, :user_id
|
|
add_index :contexts, :user_id
|
|
end
|
|
|
|
def self.down
|
|
remove_index :contexts, :user_id
|
|
remove_index :projects, :user_id
|
|
remove_index :preferences, :user_id
|
|
remove_index :todos, [:user_id, :context_id]
|
|
remove_index :todos, [:project_id]
|
|
remove_index :todos, [:context_id]
|
|
remove_index :todos, [:user_id, :project_id]
|
|
remove_index :todos, [:user_id, :state]
|
|
end
|
|
end
|