Changeset View

Standalone View

Show First 20 Lines • Show All 74 Lines • ▼ Show 20 Lines	CREATE TABLE IF NOT EXISTS content (
sha1 blob,		sha1 blob,
sha1_git blob,		sha1_git blob,
sha256 blob,		sha256 blob,
blake2s256 blob,		blake2s256 blob,
length bigint,		length bigint,
ctime timestamp,		ctime timestamp,
-- creation time, i.e. time of (first) injection into the storage		-- creation time, i.e. time of (first) injection into the storage
status ascii,		status ascii,
PRIMARY KEY ((sha1, sha1_git, sha256, blake2s256))		PRIMARY KEY ((sha256), sha1, sha1_git, blake2s256)
);""",		);""",
"""		"""
CREATE TABLE IF NOT EXISTS skipped_content (		CREATE TABLE IF NOT EXISTS skipped_content (
sha1 blob,		sha1 blob,
sha1_git blob,		sha1_git blob,
sha256 blob,		sha256 blob,
blake2s256 blob,		blake2s256 blob,
length bigint,		length bigint,
▲ Show 20 Lines • Show All 252 Lines • Show Last 20 Lines