Sha256: 85f521fecdfd318fa66e7401e9f324af8e2df6bb4b9ab196facfb43b31ef646c

Contents?: true

Size: 816 Bytes

Versions: 6

Compression:

Stored size: 816 Bytes

Contents

class CreateMonocleViews < ActiveRecord::Migration
  def self.up
    create_table :views do |t|
      t.string :viewable_type
      t.integer :viewable_id
      t.string :type
      t.date :viewed_on_start_date
      t.integer :views, :default => 0
      t.timestamps
    end

    add_index :views, [ :type, :viewable_type, :viewable_id, :views ], :name => :viewable_type_views
    add_index :views, [ :type, :viewable_type, :viewed_on_start_date, :viewable_id, :views ], :name => :viewable_type_start_date_views
    add_index :views, [ :type, :viewable_type, :viewed_on_start_date, :viewable_id ], :name => :unique_time_period_views, :unique => true
    add_index :views, [ :viewable_type, :viewable_id], :name => :index_views_on_viewable_type_and_viewable_id
  end

  def self.down
    drop_table :views
  end
end

Version data entries

6 entries across 3 versions & 1 rubygems

Version Path
monocle-0.1.1 lib/generators/monocle/templates/migration.rb
monocle-0.1.1 spec/db/migrate/20110502223022_create_monocle_views.rb
monocle-0.1.0 lib/generators/monocle/templates/migration.rb
monocle-0.1.0 spec/db/migrate/20110502223022_create_monocle_views.rb
monocle-0.0.1 lib/generators/monocle/templates/migration.rb
monocle-0.0.1 spec/db/migrate/20110502223022_create_monocle_views.rb