Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/20-swh-enums.sql
--- | --- | ||||
--- Software Heritage Data Types | --- Software Heritage Data Types | ||||
--- | --- | ||||
create type content_status as enum ('absent', 'visible', 'hidden'); | create type content_status as enum ('absent', 'visible', 'hidden'); | ||||
comment on type content_status is 'Content visibility'; | comment on type content_status is 'Content visibility'; | ||||
create type revision_type as enum ('git', 'tar', 'dsc', 'svn', 'hg'); | create type revision_type as enum ('git', 'tar', 'dsc', 'svn', 'hg'); | ||||
comment on type revision_type is 'Possible revision types'; | comment on type revision_type is 'Possible revision types'; | ||||
create type object_type as enum ('content', 'directory', 'revision', 'release', 'snapshot'); | create type object_type as enum ('content', 'directory', 'revision', 'release', 'snapshot'); | ||||
comment on type object_type is 'Data object types stored in data model'; | comment on type object_type is 'Data object types stored in data model'; | ||||
create type snapshot_target as enum ('content', 'directory', 'revision', 'release', 'snapshot', 'alias'); | create type snapshot_target as enum ('content', 'directory', 'revision', 'release', 'snapshot', 'alias'); | ||||
comment on type snapshot_target is 'Types of targets for snapshot branches'; | comment on type snapshot_target is 'Types of targets for snapshot branches'; | ||||
create type origin_visit_status as enum ( | create type origin_visit_state as enum ( | ||||
'ongoing', | 'ongoing', | ||||
'full', | 'full', | ||||
'partial' | 'partial' | ||||
); | ); | ||||
comment on type origin_visit_status IS 'Possible visit status'; | comment on type origin_visit_state IS 'Possible visit status'; |