Differential D2938 Diff 10933 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

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

	Show First 20 Lines • Show All 124 Lines • ▼ Show 20 Lines
	alter table origin_visit add primary key using index origin_visit_pkey;			alter table origin_visit add primary key using index origin_visit_pkey;

	create index concurrently on origin_visit(date);			create index concurrently on origin_visit(date);
	create index concurrently on origin_visit(type, status, date);			create index concurrently on origin_visit(type, status, date);

	alter table origin_visit add constraint origin_visit_origin_fkey foreign key (origin) references origin(id) not valid;			alter table origin_visit add constraint origin_visit_origin_fkey foreign key (origin) references origin(id) not valid;
	alter table origin_visit validate constraint origin_visit_origin_fkey;			alter table origin_visit validate constraint origin_visit_origin_fkey;

				-- origin_visit_status

				create unique index concurrently origin_visit_status_pkey on origin_visit_status(origin, visit, date);
				alter table origin_visit_status add primary key using index origin_visit_status_pkey;

				alter table origin_visit_status
				add constraint origin_visit_status_origin_visit_fkey
				foreign key (origin, visit)
				references origin_visit(origin, visit) not valid;
				alter table origin_visit_status validate constraint origin_visit_status_origin_visit_fkey;

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

	create index concurrently on release(target, target_type);			create index concurrently on release(target, target_type);
	create unique index concurrently on release(object_id);			create unique index concurrently on release(object_id);

	alter table release add constraint release_author_fkey foreign key (author) references person(id) not valid;			alter table release add constraint release_author_fkey foreign key (author) references person(id) not valid;
	Show All 40 Lines