Class: AddExploitAttempts

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/20120625000007_add_exploit_attempts.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



22
23
24
25
 
# File 'db/migrate/20120625000007_add_exploit_attempts.rb', line 22

def self.down
  drop_table :exploit_attempts
  remove_column :hosts, :exploit_attempt_count
end

.up ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
# File 'db/migrate/20120625000007_add_exploit_attempts.rb', line 3

def self.up
  create_table :exploit_attempts do |t|
    t.integer   :host_id       # Host table reference (primary)
    t.integer   :service_id    # Service table reference (optional)
    t.integer   :vuln_id       # Vuln table reference (optional)
    t.timestamp   :attempted_at  # Timestamp of when the session was opened or the module exited
    t.boolean   :exploited     # Whether or not the attempt succeeded
    t.string    :fail_reason   # Short string corresponding to a Msf::Exploit::Failure constant
    t.string    :username      # The user that tested this vulnerability
    t.text      :module        # The specific module name that was used
    t.integer   :session_id    # Database identifier of any opened session
    t.integer   :loot_id       # Database identifier of any 'proof' loot (for non-session exploits)
    t.integer       :port          # Port     -> Services are created/destroyed frequently and failed
    t.string        :proto         # Protocol |  attempts may be against closed ports.
  end

  add_column :hosts, :exploit_attempt_count, :integer, :default => 0
end