Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/60-swh-indexes.sql
Show First 20 Lines • Show All 119 Lines • ▼ Show 20 Lines | |||||
alter table snapshot_branches add constraint snapshot_branches_branch_id_fkey foreign key (branch_id) references snapshot_branch(object_id) not valid; | alter table snapshot_branches add constraint snapshot_branches_branch_id_fkey foreign key (branch_id) references snapshot_branch(object_id) not valid; | ||||
alter table snapshot_branches validate constraint snapshot_branches_branch_id_fkey; | alter table snapshot_branches validate constraint snapshot_branches_branch_id_fkey; | ||||
-- origin_visit | -- origin_visit | ||||
create unique index concurrently origin_visit_pkey on origin_visit(origin, visit); | create unique index concurrently origin_visit_pkey on origin_visit(origin, visit); | ||||
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); | |||||
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; | ||||
-- 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; | ||||
▲ Show 20 Lines • Show All 44 Lines • Show Last 20 Lines |