Class: AddModuleDetails

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
db/migrate/20120625000006_add_module_details.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
 
# File 'db/migrate/20120625000006_add_module_details.rb', line 75

def self.down
  remove_index :module_details, :refname
  remove_index :module_details, :name
  remove_index :module_details, :description
  remove_index :module_details, :mtype

  remove_index :module_authors, :module_detail_id
  remove_index :module_mixins, :module_detail_id
  remove_index :module_targets, :module_detail_id
  remove_index :module_actions, :module_detail_id
  remove_index :module_refs, :module_detail_id
  remove_index :module_refs, :name
  remove_index :module_archs, :module_detail_id
  remove_index :module_platform, :module_detail_id

  drop_table :module_details
  drop_table :module_authors
  drop_table :module_mixins
  drop_table :module_targets
  drop_table :module_actions
  drop_table :module_refs
  drop_table :module_archs
  drop_table :module_platforms

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
68
69
70
71
72
73
 
# File 'db/migrate/20120625000006_add_module_details.rb', line 3

def self.up

  create_table :module_details do |t|
    t.timestamp :mtime             # disk modified time
    t.text      :file              # location on disk
    t.string    :mtype             # exploit, auxiliary, post, etc
    t.text      :refname           # module path (no type)
    t.text      :fullname          # module path with type
    t.text      :name              # module title
    t.integer   :rank              # exploit rank
    t.text      :description       #
    t.string  :license           # MSF_LICENSE
    t.boolean :privileged        # true or false
    t.timestamp :disclosure_date   # Mar 10 2004
    t.integer :default_target    # 0
    t.text    :default_action    # "scan"
    t.string  :stance            # "passive"
    t.boolean :ready             # true/false
  end

  add_index :module_details, :refname
  add_index :module_details, :name
  add_index :module_details, :description
  add_index :module_details, :mtype

  create_table :module_authors do |t|
    t.integer :module_detail_id
    t.text :name
    t.text :email
  end
  add_index :module_authors, :module_detail_id

  create_table :module_mixins do |t|
    t.integer :module_detail_id
    t.text :name
  end
  add_index :module_mixins, :module_detail_id

  create_table :module_targets do |t|
    t.integer :module_detail_id
    t.integer :index
    t.text :name
  end
  add_index :module_targets, :module_detail_id

  create_table :module_actions do |t|
    t.integer :module_detail_id
    t.text :name
  end
  add_index :module_actions, :module_detail_id

  create_table :module_refs do |t|
    t.integer :module_detail_id
    t.text :name
  end
  add_index :module_refs, :module_detail_id
  add_index :module_refs, :name

  create_table :module_archs do |t|
    t.integer :module_detail_id
    t.text :name
  end
  add_index :module_archs, :module_detail_id

  create_table :module_platforms do |t|
    t.integer :module_detail_id
    t.text :name
  end
  add_index :module_platforms, :module_detail_id

end