Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Files
F9345455
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
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
Details
Attached
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
Attached To
rDSTOC swh-storage-cassandra
Event Timeline
Log In to Comment