diff --git a/sql/upgrades/176.sql b/sql/upgrades/176.sql new file mode 100644 --- /dev/null +++ b/sql/upgrades/176.sql @@ -0,0 +1,10 @@ +-- SWH DB schema upgrade +-- from_version: 175 +-- to_version: 176 +-- description: Add revision type cvs + +insert into dbversion(version, release, description) + values(176, now(), 'Work In Progress'); + +ALTER TYPE revision_type + ADD VALUE 'cvs'; -- added at the end by default 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(175, now(), 'Work In Progress'); + values(176, now(), 'Work In Progress'); -- a SHA1 checksum create domain sha1 as bytea check (length(value) = 20);