Page MenuHomeSoftware Heritage

No OneTemporary

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

Event Timeline