Contents

class CreateAppstatsResults < ActiveRecord::Migration
  def self.up
    create_table :appstats_results do |t|
      t.string :name
      t.string :result_type
      t.text :query
      t.text :query_as_sql
      t.integer :count
      t.string :action
      t.string :host
      t.integer :page
      t.datetime :from_date
      t.datetime :to_date
      t.timestamps
    end
    
    add_index :appstats_results, :name
    add_index :appstats_results, :action
    add_index :appstats_results, :host
    add_index :appstats_results, :page
    
  end

  def self.down
    
    remove_index :appstats_results, :name
    remove_index :appstats_results, :action
    remove_index :appstats_results, :host
    remove_index :appstats_results, :page
    
    drop_table :appstats_results
  end
end

Version data entries

75 entries across 75 versions & 1 rubygems

Version	Path
appstats-0.25.1	db/migrate/20110210225606_create_appstats_results.rb
appstats-0.25.0	db/migrate/20110210225606_create_appstats_results.rb
appstats-0.24.0	db/migrate/20110210225606_create_appstats_results.rb
appstats-0.23.5	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.23.4	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.23.3	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.23.2	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.23.1	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.23.0	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.6	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.5	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.4	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.3	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.2	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.1	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.22.0	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.21.3	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.21.2	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.21.1	db/migrations/20110210225606_create_appstats_results.rb
appstats-0.20.12	db/migrations/20110210225606_create_appstats_results.rb