No OneTemporary
Actions

Size

2 KB

Subscribers

None

View Options

	diff --git a/sql/archiver/swh-archiver-schema.sql b/sql/archiver/swh-archiver-schema.sql
	index 3fe6da8..859f6eb 100644
	--- a/sql/archiver/swh-archiver-schema.sql
	+++ b/sql/archiver/swh-archiver-schema.sql
	@@ -1,48 +1,49 @@
	-- In order to archive the content of the object storage, add
	-- some tables to keep trace of what have already been archived.

	create table dbversion
	(
	version int primary key,
	release timestamptz,
	description text
	);

	comment on table dbversion is 'Schema update tracking';

	INSERT INTO dbversion(version, release, description)
	VALUES(1, now(), 'Work In Progress');

	CREATE TYPE archive_id AS ENUM (
	'uffizi',
	'banco'
	);

	CREATE TABLE archive (
	id archive_id PRIMARY KEY,
	url TEXT
	);

	comment on table archive is 'Possible archives';
	comment on column archive.id is 'Short identifier for the archive';
	comment on column archive.url is 'Url identifying the archiver api';

	CREATE TYPE archive_status AS ENUM (
	'missing',
	'ongoing',
	- 'present'
	+ 'present',
	+ 'corrupted'
	);

	comment on type archive_status is 'Status of a given archive';

	-- a SHA1 checksum (not necessarily originating from Git)
	CREATE DOMAIN sha1 AS bytea CHECK (LENGTH(VALUE) = 20);

	CREATE TABLE content_archive (
	content_id sha1 unique,
	copies jsonb
	);

	comment on table content_archive is 'Referencing the status and whereabouts of a content';
	comment on column content_archive.content_id is 'content identifier';
	comment on column content_archive.copies is 'map archive_id -> { "status": archive_status, "mtime": epoch timestamp }'
	diff --git a/sql/archiver/upgrades/002.sql b/sql/archiver/upgrades/002.sql
	new file mode 100644
	index 0000000..d83db02
	--- /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';

File Metadata

Mime Type: text/x-diff
Expires: Fri, Jul 4, 3:21 PM (5 d, 4 h ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3289649

No OneTemporaryActions

View Options

File Metadata

Event Timeline

No OneTemporary
Actions