Class: CreateTables

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/000_create_tables.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



69
70
71
72
73
74
75
76
77
 
# File 'db/migrate/000_create_tables.rb', line 69

def self.down
	drop_table :hosts
	drop_table :clients
	drop_table :services
	drop_table :vulns
	drop_table :refs
	drop_table :vulns_refs
	drop_table :notes
end

.up ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'db/migrate/000_create_tables.rb', line 3

def self.up
	
	create_table :hosts do |t|
		t.timestamp :created
		t.string    :address, :limit => 16 # unique
		t.string    :address6
		t.string    :mac
		t.string    :comm
		t.string    :name
		t.string    :state
		t.string    :info, :limit => 1024
		t.string    :os_name
		t.string    :os_flavor
		t.string    :os_sp
		t.string    :os_lang
		t.string    :arch
	end
	
	add_index :hosts, :address, :unique => true
	
	create_table :clients do |t|
		t.integer   :host_id
		t.timestamp :created
		t.string    :ua_string, :limit => 1024, :null => false
		t.string    :ua_name, :limit => 64
		t.string    :ua_ver, :limit => 32
	end
	
	create_table :services do |t|
		t.integer   :host_id
		t.timestamp :created
		t.integer   :port, :null => false
		t.string    :proto, :limit => 16, :null => false
		t.string    :state
		t.string    :name
		t.string    :info, :limit => 1024
	end
	
	create_table :vulns do |t|
		t.integer   :host_id
		t.integer   :service_id
		t.timestamp :created
		t.string    :name
		t.text      :data
	end
	
	create_table :refs do |t|
		t.integer   :ref_id
		t.timestamp :created
		t.string    :name, :limit => 512
	end
	
	create_table :vulns_refs, :id => false do |t|
		t.integer   :ref_id
		t.integer   :vuln_id
	end
	
	create_table :notes do |t|
		t.integer   :host_id
		t.timestamp :created
		t.string    :ntype, :limit => 512
		t.text      :data
	end
	
end