Changeset View

Standalone View

Show First 20 Lines • Show All 175 Lines • ▼ Show 20 Lines	CREATE TABLE IF NOT EXISTS origin_visit_status (
snapshot blob,		snapshot blob,
PRIMARY KEY ((origin), visit, date)		PRIMARY KEY ((origin), visit, date)
);		);


CREATE TABLE IF NOT EXISTS origin (		CREATE TABLE IF NOT EXISTS origin (
sha1 blob PRIMARY KEY,		sha1 blob PRIMARY KEY,
url text,		url text,
type text,
next_visit_id int,		next_visit_id int,
-- We need integer visit ids for compatibility with the pgsql		-- We need integer visit ids for compatibility with the pgsql
-- storage, so we're using lightweight transactions with this trick:		-- storage, so we're using lightweight transactions with this trick:
-- https://stackoverflow.com/a/29391877/539465		-- https://stackoverflow.com/a/29391877/539465
);		);


CREATE TABLE IF NOT EXISTS metadata_authority (		CREATE TABLE IF NOT EXISTS metadata_authority (
▲ Show 20 Lines • Show All 91 Lines • Show Last 20 Lines