Changeset View

Standalone View

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