swh-content.sql
No OneTemporary
Actions

Size

534 B

Subscribers

None

swh-content.sql
View Options

	create domain sha1 as bytea
	check (length(value) = 20);
	create domain sha1_git as bytea
	check (length(value) = 20);
	create domain sha256 as bytea
	check (length(value) = 32);

	create table content (
	sha1 sha1 primary key,
	sha1_git sha1_git not null,
	sha256 sha256 not null,
	length bigint not null,
	ctime timestamptz not null default now(),
	status content_status not null default 'visible',
	object_id bigserial
	);

	create unique index on content(sha1_git);
	create unique index on content(sha256);

File Metadata

Mime Type: text/plain
Expires: Jul 4 2025, 9:52 AM (5 w, 1 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3242965

Event Timeline