D7978.id.diff
No OneTemporary
Actions

Size

1 KB

Subscribers

None

D7978.id.diff
View Options

	diff --git a/swh/indexer/sql/upgrades/134.sql b/swh/indexer/sql/upgrades/134.sql
	--- a/swh/indexer/sql/upgrades/134.sql
	+++ b/swh/indexer/sql/upgrades/134.sql
	@@ -143,3 +143,12 @@
	alter table directory_intrinsic_metadata add constraint directory_intrinsic_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;
	alter table directory_intrinsic_metadata validate constraint directory_intrinsic_metadata_indexer_configuration_id_fkey;

	+-- origin_intrinsic_metadata
	+create unique index origin_intrinsic_metadata_pkey on origin_intrinsic_metadata(id, indexer_configuration_id);
	+alter table origin_intrinsic_metadata add primary key using index origin_intrinsic_metadata_pkey;
	+
	+alter table origin_intrinsic_metadata add constraint origin_intrinsic_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;
	+alter table origin_intrinsic_metadata validate constraint origin_intrinsic_metadata_indexer_configuration_id_fkey;
	+
	+create index origin_intrinsic_metadata_fulltext_idx on origin_intrinsic_metadata using gin (metadata_tsvector);
	+create index origin_intrinsic_metadata_mappings_idx on origin_intrinsic_metadata using gin (mappings);

File Metadata

Mime Type: text/plain
Expires: Fri, Jun 20, 6:46 PM (2 w, 1 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3216558

Event Timeline