diff --git a/sql/upgrades/147.sql b/sql/upgrades/147.sql --- a/sql/upgrades/147.sql +++ b/sql/upgrades/147.sql @@ -16,6 +16,9 @@ alter type origin_visit_status rename to origin_visit_state; comment on type origin_visit_state IS 'Possible visit status'; +alter type origin_visit_state add value 'created' before 'ongoing'; +comment on type origin_visit_state IS 'Possible origin visit state values'; + -- Update origin visit comment on deprecated columns comment on column origin_visit.status is '(Deprecated) Visit status'; comment on column origin_visit.metadata is '(Deprecated) Optional origin visit metadata'; diff --git a/swh/storage/sql/20-swh-enums.sql b/swh/storage/sql/20-swh-enums.sql --- a/swh/storage/sql/20-swh-enums.sql +++ b/swh/storage/sql/20-swh-enums.sql @@ -15,8 +15,9 @@ comment on type snapshot_target is 'Types of targets for snapshot branches'; create type origin_visit_state as enum ( + 'created', 'ongoing', 'full', 'partial' ); -comment on type origin_visit_state IS 'Possible visit status'; +comment on type origin_visit_state IS 'Possible origin visit values';