Skip to content

Instantly share code, notes, and snippets.

@AlexeyKhristov
Last active August 29, 2015 14:01
Show Gist options
  • Save AlexeyKhristov/5bad70b7fa045f634e4b to your computer and use it in GitHub Desktop.
Save AlexeyKhristov/5bad70b7fa045f634e4b to your computer and use it in GitHub Desktop.
cassandra
CREATE TABLE domains (
domain text PRIMARY KEY,
created_at timestamp,
tags set<text>,
seo_counters map<text, float>,
techs map<text, text>
) WITH comment='domains';
CREATE TABLE pages (
url text PRIMARY KEY,
domain text,
tags set<text>,
status_code int,
response_time int,
depth int,
last_visit timestamp,
page_rank float,
links_in int,
links_out int,
body text,
headers map<text, text>,
content_readability text,
content_boilerpipe text
) WITH comment='pages';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment