Contents

class CreateFlexibleFeedsEvents < ActiveRecord::Migration
  def change
    create_table :flexible_feeds_events do |t|
      t.string :eventable_type
      t.integer :eventable_id
      t.integer :creator_id
      t.string :creator_type

      t.integer :parent_id
      t.integer :ancestor_id
      t.integer :children_count, null: false, default: 0
      
      t.integer :votes_sum, null: false, default: 0
      t.integer :votes_for, null: false, default: 0
      t.integer :votes_against, null: false, default: 0
      t.float :controversy, null: false, default: 0, precision: 5, scale: 2
      t.float :popularity, null: false, default: 0, precision: 5, scale: 2

      t.timestamps
    end

    add_index :flexible_feeds_events, :votes_sum
    add_index :flexible_feeds_events, :votes_for
    add_index :flexible_feeds_events, :votes_against
    add_index :flexible_feeds_events, :controversy
    add_index :flexible_feeds_events, :popularity
    add_index :flexible_feeds_events, :children_count
    add_index :flexible_feeds_events, :ancestor_id
    add_index :flexible_feeds_events, :parent_id
    add_index :flexible_feeds_events,
      [:eventable_id, :eventable_type],
      name: "flexible_feeds_events_on_eventable"
    add_index :flexible_feeds_events,
      [:creator_id, :creator_type],
      name: "flexible_feeds_events_on_creator"
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
flexible_feeds-0.3.6	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.5	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.4	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.3	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.2	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.1	db/migrate/20140227194816_create_flexible_feeds_events.rb
flexible_feeds-0.3.0	db/migrate/20140227194816_create_flexible_feeds_events.rb