· 10 years ago · Sep 21, 2016, 07:58 AM
1CREATE TABLE IF NOT EXISTS events.events_by_user(
2 user text,
3 added_week int,
4 added_timestamp timestamp,
5 event text,
6 uuid uuid,
7 PRIMARY KEY((user, added_week), added_timestamp, event, uuid))
8WITH CLUSTERING ORDER BY(added_timestamp DESC)
9
10CREATE TABLE IF NOT EXISTS events.events_by_user(
11 user text,
12 added_week int,
13 added_timestamp timestamp,
14 event text,
15 frequency counter,
16 PRIMARY KEY((user, added_week), added_timestamp, event))
17WITH CLUSTERING ORDER BY(added_timestamp DESC)