class EnrichmentsSchema

Public Instance Methods

change() click to toggle source
# File lib/mihari/database.rb, line 42
def change
  create_table :autonomous_systems, if_not_exists: true do |t|
    t.integer :asn, null: false
    t.belongs_to :artifact, foreign_key: true
  end

  create_table :geolocations, if_not_exists: true do |t|
    t.string :country, null: false
    t.string :country_code, null: false
    t.belongs_to :artifact, foreign_key: true
  end

  create_table :whois_records, if_not_exists: true do |t|
    t.string :domain, null: false
    t.date :created_on
    t.date :updated_on
    t.date :expires_on
    t.json :registrar
    t.json :contacts
    t.belongs_to :artifact, foreign_key: true
  end

  create_table :dns_records, if_not_exists: true do |t|
    t.string :resource, null: false
    t.string :value, null: false
    t.belongs_to :artifact, foreign_key: true
  end

  create_table :reverse_dns_names, if_not_exists: true do |t|
    t.string :name, null: false
    t.belongs_to :artifact, foreign_key: true
  end
end