Differential D1838 Diff 6673 swh/indexer/sql/60-swh-indexes.sql

Changeset View

Standalone View

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

	Show All 12 Lines
	-- content_ctags			-- content_ctags
	create index on content_ctags(id);			create index on content_ctags(id);
	create index on content_ctags(hash_sha1(name));			create index on content_ctags(hash_sha1(name));
	create unique index on content_ctags(id, hash_sha1(name), kind, line, lang, indexer_configuration_id);			create unique index on content_ctags(id, hash_sha1(name), kind, line, lang, indexer_configuration_id);

	alter table content_ctags add constraint content_ctags_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;			alter table content_ctags add constraint content_ctags_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;
	alter table content_ctags validate constraint content_ctags_indexer_configuration_id_fkey;			alter table content_ctags validate constraint content_ctags_indexer_configuration_id_fkey;

	-- content_metadata
	create unique index content_metadata_pkey on content_metadata(id, indexer_configuration_id);
	alter table content_metadata add primary key using index content_metadata_pkey;

	alter table content_metadata add constraint content_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;
	alter table content_metadata validate constraint content_metadata_indexer_configuration_id_fkey;

	-- revision_intrinsic_metadata			-- revision_intrinsic_metadata
	create unique index revision_intrinsic_metadata_pkey on revision_intrinsic_metadata(id, indexer_configuration_id);			create unique index revision_intrinsic_metadata_pkey on revision_intrinsic_metadata(id, indexer_configuration_id);
	alter table revision_intrinsic_metadata add primary key using index revision_intrinsic_metadata_pkey;			alter table revision_intrinsic_metadata add primary key using index revision_intrinsic_metadata_pkey;

	alter table revision_intrinsic_metadata add constraint revision_intrinsic_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;			alter table revision_intrinsic_metadata add constraint revision_intrinsic_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid;
	alter table revision_intrinsic_metadata validate constraint revision_intrinsic_metadata_indexer_configuration_id_fkey;			alter table revision_intrinsic_metadata validate constraint revision_intrinsic_metadata_indexer_configuration_id_fkey;

	-- content_mimetype			-- content_mimetype
	Show All 32 Lines