069.sql
No OneTemporary
Actions

Size

618 B

Subscribers

None

069.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 68
	-- to_version: 69
	-- description: add tables for the archiver.

	insert into dbversion(version, release, description)
	values(69, now(), 'Work In Progress');

	CREATE DOMAIN archive_id AS TEXT;

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

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

	CREATE TABLE content_archive (
	content_id sha1 REFERENCES content(sha1),
	archive_id archive_id REFERENCES archives(id),
	status archive_status,
	mtime timestamptz,
	PRIMARY KEY (content_id, archive_id)
	);