diff --git a/sql/upgrades/177.sql b/sql/upgrades/177.sql new file mode 100644 --- /dev/null +++ b/sql/upgrades/177.sql @@ -0,0 +1,9 @@ +-- SWH DB schema upgrade +-- from_version: 176 +-- to_version: 177 +-- description: add cvs to revision_type values + +insert into dbversion(version, release, description) + values(177, now(), 'Work In Progress'); + +alter type revision_type add value 'cvs'; diff --git a/swh/storage/postgresql/db.py b/swh/storage/postgresql/db.py --- a/swh/storage/postgresql/db.py +++ b/swh/storage/postgresql/db.py @@ -30,7 +30,7 @@ """ - current_version = 176 + current_version = 177 def mktemp_dir_entry(self, entry_type, cur=None): self._cursor(cur).execute( diff --git a/swh/storage/sql/20-enums.sql b/swh/storage/sql/20-enums.sql --- a/swh/storage/sql/20-enums.sql +++ b/swh/storage/sql/20-enums.sql @@ -5,7 +5,7 @@ create type content_status as enum ('absent', 'visible', 'hidden'); 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', 'cvs'); comment on type revision_type is 'Possible revision types'; create type object_type as enum ('content', 'directory', 'revision', 'release', 'snapshot'); diff --git a/swh/storage/sql/30-schema.sql b/swh/storage/sql/30-schema.sql --- a/swh/storage/sql/30-schema.sql +++ b/swh/storage/sql/30-schema.sql @@ -17,7 +17,7 @@ -- latest schema version insert into dbversion(version, release, description) - values(176, now(), 'Work In Progress'); + values(177, now(), 'Work In Progress'); -- a SHA1 checksum create domain sha1 as bytea check (length(value) = 20);