class Kekkan::Base::Schema

Kekkan database Schema

Public Class Methods

down() click to toggle source

Deletes all of the database tables created

# File lib/kekkan/base/schema.rb, line 91
def self.down
        drop_table :entries
        #drop_table :vulnerable_configurations
        drop_table :vulnerable_software_lists
        drop_table :cvsses
        drop_table :references
        drop_table :assessment_checks
        drop_table :scanners
        drop_table :versions
end
up() click to toggle source

Creates all of the database tables required by the parser

# File lib/kekkan/base/schema.rb, line 29
def self.up
        create_table :entries do |t|
                t.string :cve
                t.string :published_datetime
                t.string :last_modified_datetime
                t.string :summary
                t.string :cwe
                t.string :security_protection
        end

        #create_table :vulnerable_configurations do |t|
                #ignoring for now
        #end

        create_table :vulnerable_software_lists do |t|
                t.integer :entry_id
                t.string :product
        end

        create_table :cvsses do |t|
                t.integer :entry_id
                t.string :score
                t.string :access_vector
                t.string :access_complexity
                t.string :authenication
                t.string :confidentiality_impact
                t.string :integrity_impact
                t.string :availability_impact
                t.string :source
                t.string :generated_on_datetime
        end

        create_table :references do |t|
                t.integer :entry_id
                t.string :source
                t.string :ref_type
                t.string :reference
                t.string :href
                t.string :language
        end

        create_table :assessment_checks do |t|
                t.integer :entry_id
                t.string :name
                t.string :href
                t.string :system
        end

        create_table :scanners do |t|
                t.integer :entry_id
                t.string :name
                t.string :href
                t.string :system
        end

        create_table :versions do |t|
                t.string :version
        end
end