Differential D3159 Diff 11221 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

swh/storage/sql/60-swh-indexes.sql

	Show First 20 Lines • Show All 160 Lines • ▼ Show 20 Lines

	create unique index on tool(name, version, configuration);			create unique index on tool(name, version, configuration);

	-- metadata_provider			-- metadata_provider
	create unique index concurrently metadata_provider_pkey on metadata_provider(id);			create unique index concurrently metadata_provider_pkey on metadata_provider(id);
	alter table metadata_provider add primary key using index metadata_provider_pkey;			alter table metadata_provider add primary key using index metadata_provider_pkey;

	create index concurrently on metadata_provider(provider_name, provider_url);			create index concurrently on metadata_provider(provider_name, provider_url);
				create unique index metadata_provider_type_url
				on metadata_provider(provider_type, provider_url);

	-- origin_metadata			-- origin_metadata
	create unique index concurrently origin_metadata_pkey on origin_metadata(id);			create unique index concurrently origin_metadata_pkey on origin_metadata(id);
	alter table origin_metadata add primary key using index origin_metadata_pkey;			alter table origin_metadata add primary key using index origin_metadata_pkey;


	create index concurrently on origin_metadata(origin_id, provider_id, tool_id);			create index concurrently on origin_metadata(origin_id, provider_id, tool_id);

	alter table origin_metadata add constraint origin_metadata_origin_fkey foreign key (origin_id) references origin(id) not valid;			alter table origin_metadata add constraint origin_metadata_origin_fkey foreign key (origin_id) references origin(id) not valid;
	alter table origin_metadata validate constraint origin_metadata_origin_fkey;			alter table origin_metadata validate constraint origin_metadata_origin_fkey;

	alter table origin_metadata add constraint origin_metadata_provider_fkey foreign key (provider_id) references metadata_provider(id) not valid;			alter table origin_metadata add constraint origin_metadata_provider_fkey foreign key (provider_id) references metadata_provider(id) not valid;
	alter table origin_metadata validate constraint origin_metadata_provider_fkey;			alter table origin_metadata validate constraint origin_metadata_provider_fkey;

	Show All 10 Lines