Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/147.sql
Show All 10 Lines | insert into dbversion(version, release, description) | ||||
values(147, now(), 'Work In Progress'); | values(147, now(), 'Work In Progress'); | ||||
-- schema change | -- schema change | ||||
-- Rename old enum | -- Rename old enum | ||||
alter type origin_visit_status rename to origin_visit_state; | alter type origin_visit_status rename to origin_visit_state; | ||||
comment on type origin_visit_state IS 'Possible visit status'; | 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 | -- Update origin visit comment on deprecated columns | ||||
comment on column origin_visit.status is '(Deprecated) Visit status'; | comment on column origin_visit.status is '(Deprecated) Visit status'; | ||||
comment on column origin_visit.metadata is '(Deprecated) Optional origin visit metadata'; | comment on column origin_visit.metadata is '(Deprecated) Optional origin visit metadata'; | ||||
comment on column origin_visit.snapshot is '(Deprecated) Optional, possibly partial, snapshot of the origin visit.'; | comment on column origin_visit.snapshot is '(Deprecated) Optional, possibly partial, snapshot of the origin visit.'; | ||||
-- Crawling history of software origin visits by Software Heritage. Each | -- Crawling history of software origin visits by Software Heritage. Each | ||||
-- visit see its history change through new origin visit status updates | -- visit see its history change through new origin visit status updates | ||||
Show All 38 Lines |