Differential D3355 Diff 11980 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

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

	Show First 20 Lines • Show All 162 Lines • ▼ Show 20 Lines
	create unique index metadata_fetcher_name_version on metadata_fetcher(name, version);			create unique index metadata_fetcher_name_version on metadata_fetcher(name, version);

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

	create unique index metadata_authority_type_url on metadata_authority(type, url);			create unique index metadata_authority_type_url on metadata_authority(type, url);

	-- origin_metadata			-- object_metadata
	create unique index concurrently origin_metadata_pkey on origin_metadata(id);			create unique index concurrently object_metadata_content_authority_date_fetcher on object_metadata(id, authority_id, discovery_date, fetcher_id);
	alter table origin_metadata add primary key using index origin_metadata_pkey;

	create unique index concurrently origin_metadata_origin_authority_date_fetcher on origin_metadata(origin_id, authority_id, discovery_date, fetcher_id);			alter table object_metadata add constraint object_metadata_authority_fkey foreign key (authority_id) references metadata_authority(id) not valid;
				alter table object_metadata validate constraint object_metadata_authority_fkey;

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

	alter table origin_metadata add constraint origin_metadata_authority_fkey foreign key (authority_id) references metadata_authority(id) not valid;
	alter table origin_metadata validate constraint origin_metadata_authority_fkey;

	alter table origin_metadata add constraint origin_metadata_fetcher_fkey foreign key (fetcher_id) references metadata_fetcher(id) not valid;
	alter table origin_metadata validate constraint origin_metadata_fetcher_fkey;

	-- object_counts			-- object_counts
	create unique index concurrently object_counts_pkey on object_counts(object_type);			create unique index concurrently object_counts_pkey on object_counts(object_type);
	alter table object_counts add primary key using index object_counts_pkey;			alter table object_counts add primary key using index object_counts_pkey;

	-- object_counts_bucketed			-- object_counts_bucketed
	create unique index concurrently object_counts_bucketed_pkey on object_counts_bucketed(line);			create unique index concurrently object_counts_bucketed_pkey on object_counts_bucketed(line);
	alter table object_counts_bucketed add primary key using index object_counts_bucketed_pkey;			alter table object_counts_bucketed add primary key using index object_counts_bucketed_pkey;