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