Sha256: 35f63434d26e159c45e2bc024ee93e8fd0d150e1471cf9b76a656a81bd353171

Contents?: true

Size: 1.77 KB

Versions: 53

Compression:

Stored size: 1.77 KB

Contents

class CreateImpressionsTable < ActiveRecord::Migration
  def self.up
    create_table :impressions, :force => true do |t|
      t.string :impressionable_type
      t.integer :impressionable_id
      t.integer :user_id
      t.string :controller_name
      t.string :action_name
      t.string :view_name
      t.string :request_hash
      t.string :session_hash
      t.string :ip_address
      t.string :message
      t.string :referrer
      t.timestamps
    end
    add_index :impressions, [:impressionable_type, :impressionable_id, :request_hash], :name => "poly_request_index", :unique => false
    add_index :impressions, [:impressionable_type, :impressionable_id, :ip_address], :name => "poly_ip_index", :unique => false
    add_index :impressions, [:impressionable_type, :impressionable_id, :session_hash], :name => "poly_session_index", :unique => false    
    add_index :impressions, [:controller_name,:action_name,:request_hash], :name => "controlleraction_request_index", :unique => false
    add_index :impressions, [:controller_name,:action_name,:ip_address], :name => "controlleraction_ip_index", :unique => false
    add_index :impressions, [:controller_name,:action_name,:session_hash], :name => "controlleraction_session_index", :unique => false        
    add_index :impressions, :user_id
  end

  def self.down
    remove_index :impressions, :name => :poly_request_index
    remove_index :impressions, :name => :poly_ip_index
    remove_index :impressions, :name => :poly_session_index        
    remove_index :impressions, :name => :controlleraction_request_index
    remove_index :impressions, :name => :controlleraction_ip_index
    remove_index :impressions, :name => :controlleraction_session_index        
    remove_index :impressions, :user_id
    
    drop_table :impressions
  end
end

Version data entries

53 entries across 53 versions & 3 rubygems

Version Path
rostra-0.3.6 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.3.5 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.3.4 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.3.3 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.3.2 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.3.1 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.2.1 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.2.0 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.26 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.25 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.24 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.23 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.22 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.21 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.20 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.19 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.18 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.17 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.16 db/migrate/20111016021105_create_impressions_table.rb
rostra-0.1.15 db/migrate/20111016021105_create_impressions_table.rb