yats.git

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

CREATE KEYSPACE yats WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true;
CREATE TABLE metric (
    id_client text,
    mtime timestamp,
    name text,
    value text,
    PRIMARY KEY ((id_client,name),mtime)
);
CREATE TABLE event (
    id_client text,
    etime timestamp,
    name text,
    PRIMARY KEY (id_client,etime)
);
CREATE TABLE client (
 id text,
 name text,
 created timestamp,
 PRIMARY KEY(id)
);