volontariat/voluntary_ranking

# This migration comes from voluntary_ranking_engine (originally 20130817115303)
class AddRankingProduct < ActiveRecord::Migration
  def up
    Product::Ranking.create(name: 'Ranking', text: 'Ranking')
    
    create_table :rankings, force:  true do |t|
      t.string :adjective # best
      t.string :topic
      t.string :scope
      t.string :negative_adjective # worst
      t.timestamps
    end
    
    create_table :ranking_items, force:  true do |t|
      t.integer :position
      t.integer :ranking_id
      t.integer :thing_id
      t.boolean :best
      t.integer :user_ranking_items_count, default: 0
      t.integer :stars_sum, default: 0
      t.integer :stars, default: 0
      t.timestamps
    end
    
    add_index :ranking_items, [:ranking_id, :thing_id], unique: true
    add_index :ranking_items, [:ranking_id, :stars_sum]
    add_index :ranking_items, [:ranking_id, :position]
    
    create_table :user_ranking_items, force:  true do |t|
      t.integer :user_id
      t.integer :ranking_item_id
      t.integer :position
      t.boolean :best
      t.integer :stars, default: 0
      t.integer :ranking_id # cache column
      t.integer :thing_id # cache column
      t.timestamps
    end
    
    add_index :user_ranking_items, [:user_id, :ranking_id, :thing_id], unique: true
    add_index :user_ranking_items, [:user_id, :ranking_id, :position]
  end
  
  def down
    Product::Ranking.first.destroy
    
    [:rankings, :ranking_items, :user_ranking_items].each do |table|
      drop_table table
    end
  end
end