Changeset View

Standalone View

Show First 20 Lines • Show All 213 Lines • ▼ Show 20 Lines	CREATE TABLE IF NOT EXISTS object_metadata (
discovery_date timestamp,		discovery_date timestamp,
fetcher_name ascii,		fetcher_name ascii,
fetcher_version ascii,		fetcher_version ascii,

-- metadata itself		-- metadata itself
format ascii,		format ascii,
metadata blob,		metadata blob,

		-- context
		origin text,
		visit bigint,
		snapshot text,
		release text,
		revision text,
		path blob,
		directory text,

PRIMARY KEY ((id), authority_type, authority_url, discovery_date,		PRIMARY KEY ((id), authority_type, authority_url, discovery_date,
fetcher_name, fetcher_version)		fetcher_name, fetcher_version)
);		);


CREATE TABLE IF NOT EXISTS object_count (		CREATE TABLE IF NOT EXISTS object_count (
partition_key smallint, -- Constant, must always be 0		partition_key smallint, -- Constant, must always be 0
object_type ascii,		object_type ascii,
▲ Show 20 Lines • Show All 44 Lines • Show Last 20 Lines