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