1
2
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

class CreateVulnerabilities < ActiveRecord::Migration
  def self.up
    create_table :vulnerabilities do |t|
      #private
      t.integer  :publish_id 
      t.integer :publish_rev

      #public
      t.string  :cveid
      t.date    :vendor_published
      t.string  :name
      t.text    :filter
      t.string  :announcement_origin
      t.string  :announcement_url
      t.text    :references
      t.text    :remediation
      t.text    :recommendation
      t.text    :summary
      t.text    :details
      t.text    :vulnerable
      t.float   :cve_severity
      t.integer :cve_status
      t.integer :netmri_severity
      #open
      t.text    :notes
      t.string  :created_by
      t.string  :updated_by 
      t.timestamps
    end
  end

  def self.down
    drop_table :vulnerabilities
  end
end