Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/cassandra/schema.py
Show First 20 Lines • Show All 151 Lines • ▼ Show 20 Lines | CREATE TABLE IF NOT EXISTS origin_visit ( | ||||
type text, | type text, | ||||
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, | ||||
type text, | |||||
status ascii, | status ascii, | ||||
metadata text, | metadata text, | ||||
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, | ||||
▲ Show 20 Lines • Show All 105 Lines • Show Last 20 Lines |