diff --git a/sql/upgrades/125.sql b/sql/upgrades/125.sql index 4d3cdd8..ecbe54d 100644 --- a/sql/upgrades/125.sql +++ b/sql/upgrades/125.sql @@ -1,41 +1,41 @@ -- SWH Indexer DB schema upgrade -- from_version: 124 -- to_version: 125 -- description: Add 'origin_url' column to origin_intrinsic_metadata. insert into dbversion(version, release, description) values(125, now(), 'Work In Progress'); -alter origin_intrinsic_metadata - add column origin_url type text; +alter table origin_intrinsic_metadata + add column origin_url text; create or replace function swh_origin_intrinsic_metadata_add( conflict_update boolean) returns void language plpgsql as $$ begin perform swh_origin_intrinsic_metadata_compute_tsvector(); if conflict_update then insert into origin_intrinsic_metadata (id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings) select id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings from tmp_origin_intrinsic_metadata on conflict(id, indexer_configuration_id) do update set metadata = excluded.metadata, mappings = excluded.mappings; else insert into origin_intrinsic_metadata (id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings) select id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings from tmp_origin_intrinsic_metadata on conflict(id, indexer_configuration_id) do nothing; end if; return; end $$; comment on function swh_origin_intrinsic_metadata_add(boolean) IS 'Add new origin intrinsic metadata';