Class: AddWebTables

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/20101001000000_add_web_tables.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



49
50
51
52
53
54
 
# File 'db/migrate/20101001000000_add_web_tables.rb', line 49

def self.down
	drop_table :web_sites
	drop_table :web_pages
	drop_table :web_forms
	drop_table :web_vulns
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
 
# File 'db/migrate/20101001000000_add_web_tables.rb', line 3

def self.up
	create_table :web_sites do |t|
		t.integer   :service_id, :null => false
		t.timestamps 
		t.string    :vhost, :limit => 2048
		t.text      :comments
		t.text      :options
	end
	
	create_table :web_pages do |t|
		t.integer   :web_site_id, :null => false
		t.timestamps 
		t.text      :path
		t.text      :query
		t.integer   :code, :null => false
		t.text      :cookie
		t.text      :auth
		t.text      :ctype
		t.timestamp :mtime				
		t.text      :location
		t.text      :body
		t.text      :headers
	end	

	create_table :web_forms do |t|
		t.integer   :web_site_id, :null => false
		t.timestamps 
		t.text      :path
		t.string    :method, :limit => 1024
		t.text      :params
	end	

	create_table :web_vulns do |t|
		t.integer   :web_site_id, :null => false
		t.timestamps 
		t.text      :path
		t.string    :method, :limit => 1024
		t.text      :params
		t.text      :pname
		t.text      :proof
		t.integer   :risk
		t.string    :name,    :limit => 1024	
	end	
						
end