Differential D1432 Diff 4711 swh/indexer/sql/60-swh-indexes.sql

Changeset View

Standalone View

swh/indexer/sql/60-swh-indexes.sql

	Show First 20 Lines • Show All 56 Lines • ▼ Show 20 Lines
	alter table content_fossology_license validate constraint content_fossology_license_indexer_configuration_id_fkey;			alter table content_fossology_license validate constraint content_fossology_license_indexer_configuration_id_fkey;

	-- origin_intrinsic_metadata			-- origin_intrinsic_metadata
	create unique index origin_intrinsic_metadata_pkey on origin_intrinsic_metadata(id, indexer_configuration_id);			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 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 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;			alter table origin_intrinsic_metadata validate constraint origin_intrinsic_metadata_indexer_configuration_id_fkey;
	alter table origin_intrinsic_metadata add constraint origin_intrinsic_metadata_revision_metadata_fkey foreign key (from_revision, indexer_configuration_id) references revision_intrinsic_metadata(id, indexer_configuration_id) not valid;
	alter table origin_intrinsic_metadata validate constraint origin_intrinsic_metadata_revision_metadata_fkey;

	create index origin_intrinsic_metadata_fulltext_idx on origin_intrinsic_metadata using gin (metadata_tsvector);			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);			create index origin_intrinsic_metadata_mappings_idx on origin_intrinsic_metadata using gin (mappings);