diff --git a/sql/upgrades/117.sql b/sql/upgrades/117.sql --- a/sql/upgrades/117.sql +++ b/sql/upgrades/117.sql @@ -3,6 +3,9 @@ -- to_version: 117 -- description: Add fulltext search index for origin intrinsic metadata +insert into dbversion(version, release, description) +values(117, now(), 'Work In Progress'); + alter table origin_intrinsic_metadata add column metadata_tsvector tsvector; update origin_intrinsic_metadata set metadata_tsvector = to_tsvector('pg_catalog.simple', metadata); create index origin_intrinsic_metadata_fulltext_idx on origin_intrinsic_metadata using gin (metadata_tsvector); diff --git a/swh/indexer/sql/30-swh-schema.sql b/swh/indexer/sql/30-swh-schema.sql --- a/swh/indexer/sql/30-swh-schema.sql +++ b/swh/indexer/sql/30-swh-schema.sql @@ -14,7 +14,7 @@ ); insert into dbversion(version, release, description) - values(116, now(), 'Work In Progress'); + values(117, now(), 'Work In Progress'); -- Computing metadata on sha1's contents -- a SHA1 checksum (not necessarily originating from Git)