diff --git a/sql/archiver/upgrades/002.sql b/sql/archiver/upgrades/002.sql new file mode 100644 --- /dev/null +++ b/sql/archiver/upgrades/002.sql @@ -0,0 +1,9 @@ +-- SWH DB schema upgrade +-- from_version: 1 +-- to_version: 2 +-- description: Add a 'corrupted' status into the archive_content status + +INSERT INTO dbversion(version, release, description) +VALUES(2, now(), 'Work In Progress'); + +ALTER TYPE archive_status ADD VALUE 'corrupted';