Contents

class ErrdoCreateErrs < ActiveRecord::Migration
  def change
    create_table :errs do |t|
      t.string :exception_class_name
      t.string :exception_message
      t.string :http_method
      t.string :host_name
      t.string :url

      t.text :backtrace

      t.string :backtrace_hash
      t.integer :occurrence_count, default: 0
      t.datetime :last_occurred_at

      t.string :last_experiencer_type
      t.integer :last_experiencer_id

      t.integer :status, default: 0
      t.string :importance, default: "error"


      t.timestamps null: false
    end

    create_table :err_occurrences do |t|
      t.integer :err_id

      t.string :experiencer_type
      t.integer :experiencer_id

      t.string :ip
      t.string :user_agent
      t.string :referer
      t.string :query_string
      t.text :form_values
      t.text :param_values
      t.text :cookie_values
      t.text :header_values

      t.integer :ocurrence_count, default: 1
      t.timestamps null: false
    end

    add_index :errs, :backtrace_hash, unique: true
    add_index :errs, :importance
    add_index :errs, :last_experiencer_id
    add_index :errs, :last_experiencer_type

    add_index :err_occurrences, :experiencer_id
    add_index :err_occurrences, :experiencer_type
    add_index :err_occurrences, :err_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
errdo-0.11.1	test/tmp/db/migrate/20161020165703_errdo_create_errs.rb