KK6SDdBB

1# mystiko keyspace
2CREATE KEYSPACE IF NOT EXISTS mystiko
3WITH replication = {
4  'class':'NetworkTopologyStrategy',
5  'DC1':'1'
6};
7
8# trans table
9CREATE TABLE IF NOT EXISTS mystiko.trans (
10  execer TEXT,
11  id TEXT,
12  actor TEXT,
13  message TEXT,
14  flightId TEXT,
15  flightNo TEXT,
16  flightTime TIMESTAMP,
17  flightStatus TEXT,
18  flightFrom TEXT,
19  flightTo TEXT,
20  flightEvent TEXT,
21  timestamp TIMESTAMP,
22  PRIMARY KEY(execer, id)
23);