data_importer/db/migrate/20220411181501_create_github_advisories.rb

21 lines
515 B
Ruby

# frozen_string_literal: true
class CreateGithubAdvisories < ActiveRecord::Migration[7.0]
def change
create_table :github_advisories do |t|
t.string :schema_version
t.string :ghsa_id
t.index :ghsa_id, unique: true
t.date :modified
t.date :published
t.string :aliases, array: true
t.string :summary
t.string :details
t.jsonb :severity
t.jsonb :affected
t.jsonb :references
t.jsonb :database_specific
t.timestamps
end
end
end