117.sql
No OneTemporary
Actions

Size

530 B

Subscribers

None

117.sql
View Options

	-- SWH Indexer DB schema upgrade
	-- from_version: 116
	-- 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);