Differential D692 Diff 2243 swh/storage/sql/30-swh-schema.sql

Changeset View

Standalone View

	---			---
	--- SQL implementation of the Software Heritage data model			--- SQL implementation of the Software Heritage data model
	---			---

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

	-- latest schema version			-- latest schema version
	insert into dbversion(version, release, description)			insert into dbversion(version, release, description)
	values(128, now(), 'Work In Progress');			values(129, now(), 'Work In Progress');

	-- a SHA1 checksum			-- a SHA1 checksum
	create domain sha1 as bytea check (length(value) = 20);			create domain sha1 as bytea check (length(value) = 20);

	-- a Git object ID, i.e., a Git-style salted SHA1 checksum			-- a Git object ID, i.e., a Git-style salted SHA1 checksum
	create domain sha1_git as bytea check (length(value) = 20);			create domain sha1_git as bytea check (length(value) = 20);

	-- a SHA256 checksum			-- a SHA256 checksum
	▲ Show 20 Lines • Show All 323 Lines • Show Last 20 Lines