CREATE KEYSPACE ccfp WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };

use ccfp;

CREATE TABLE abstracts (
    id           uuid,
	title        text,
    body         text,
    created      timestamp,
    authors      map<text,text>,
    tags         set<text>,
	attributes   map<text,text>,
	comments     map<timeuuid,text>,
	scores_a     map<text,float>,
	scores_b     map<text,float>,
	scores_c     map<text,float>,
	scores_d     map<text,float>,
	scores_e     map<text,float>,
	scores_f     map<text,float>,
	scores_g     map<text,float>,
	scores_names map<text,text>,
    PRIMARY KEY(id)
);

CREATE TABLE abstract_email_index (
    email text,
	abstracts set<uuid>,
	comments set<uuid>,
	PRIMARY KEY(email)
);

CREATE TABLE abstract_tag_index (
    tag text,
	abstracts set<uuid>,
	comments set<uuid>,
	PRIMARY KEY(tag)
);

CREATE TABLE sessions (
	id       uuid,
	data     blob,
	created  timestamp,
	modified timestamp,
	PRIMARY KEY(id)
);

CREATE KEYSPACE ccfp WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };

use ccfp;

CREATE TABLE abstracts (
    id           uuid,
	title        text,
    body         text,
    created      timestamp,
    authors      map<text,text>,
    tags         set<text>,
	attributes   map<text,text>,
	comments     map<timeuuid,text>,
	scores_a     map<text,float>,
	scores_b     map<text,float>,
	scores_c     map<text,float>,
	scores_d     map<text,float>,
	scores_e     map<text,float>,
	scores_f     map<text,float>,
	scores_g     map<text,float>,
	scores_names map<text,text>,
    PRIMARY KEY(id)
);

CREATE TABLE abstract_email_index (
    email text,
	abstracts set<uuid>,
	comments set<uuid>,
	PRIMARY KEY(email)
);

CREATE TABLE abstract_tag_index (
    tag text,
	abstracts set<uuid>,
	comments set<uuid>,
	PRIMARY KEY(tag)
);

CREATE TABLE sessions (
	id       uuid,
	email    text,
	created  timestamp,
	modified timestamp,
	PRIMARY KEY(id)
);

Change data blob to email text.
Change data blob to email text.

Didn't need anythign else that might have been in the blob. This
is simpler and now emails are visible in cqlsh, which helps.
