Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/cassandra/schema.py
Show First 20 Lines • Show All 142 Lines • ▼ Show 20 Lines | CREATE TABLE IF NOT EXISTS snapshot_branch ( | ||||
PRIMARY KEY ((snapshot_id), name) | PRIMARY KEY ((snapshot_id), name) | ||||
); | ); | ||||
CREATE TABLE IF NOT EXISTS origin_visit ( | CREATE TABLE IF NOT EXISTS origin_visit ( | ||||
origin text, | origin text, | ||||
visit bigint, | visit bigint, | ||||
date timestamp, | date timestamp, | ||||
type text, | type text, | ||||
status ascii, | |||||
metadata text, | |||||
snapshot blob, | |||||
PRIMARY KEY ((origin), visit) | PRIMARY KEY ((origin), visit) | ||||
); | ); | ||||
CREATE TABLE IF NOT EXISTS origin_visit_status ( | CREATE TABLE IF NOT EXISTS origin_visit_status ( | ||||
origin text, | origin text, | ||||
visit bigint, | visit bigint, | ||||
date timestamp, | date timestamp, | ||||
status ascii, | status ascii, | ||||
▲ Show 20 Lines • Show All 96 Lines • Show Last 20 Lines |