diff --git a/sql/archiver/swh-archiver-schema.sql b/sql/archiver/swh-archiver-schema.sql
--- a/sql/archiver/swh-archiver-schema.sql
+++ b/sql/archiver/swh-archiver-schema.sql
@@ -30,7 +30,8 @@
 CREATE TYPE archive_status AS ENUM (
   'missing',
   'ongoing',
-  'present'
+  'present',
+  'corrupted'
 );
 
 comment on type archive_status is 'Status of a given archive';
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';