4c812986f8
The page lacked structured resource information. I evaluated various options: extracting UBIDs from the summary using regex, adding a 'resource_id' column, or introducing a JSONB column. By adding a 'details' column, we can associate multiple UBIDs with a single page. Additionally, we can enrich the page details to facilitate easier future investigations.
10 lines
169 B
Ruby
10 lines
169 B
Ruby
# frozen_string_literal: true
|
|
|
|
Sequel.migration do
|
|
change do
|
|
alter_table(:page) do
|
|
add_column :details, :jsonb, null: false, default: "{}"
|
|
end
|
|
end
|
|
end
|