class Kekkan::Base::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