D89.id287.diff
No OneTemporary
Actions

Size

819 B

Subscribers

None

D89.id287.diff
View Options

	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';