Class: V72Schema

Inherits:
Object
  • Object
show all
Defined in:
lib/mihari/database.rb

Instance Method Summary collapse

Instance Method Details

#changeObject



108
109
110
111
112
113
114
115
116
117
118
119
120
121
# File 'lib/mihari/database.rb', line 108

def change
  create_table :vulnerabilities, if_not_exists: true do |t|
    t.string :name, null: false
    t.datetime :created_at

    t.belongs_to :artifact, foreign_key: true, null: false
  end

  rename_column :cpes, :cpe, :name if ActiveRecord::Base.connection.column_exists?(:cpes, :cpe)
  rename_column :autonomous_systems, :asn, :number if ActiveRecord::Base.connection.column_exists?(
    :autonomous_systems, :asn
  )
  rename_column :ports, :port, :number if ActiveRecord::Base.connection.column_exists?(:ports, :port)
end