· 6 years ago · Sep 30, 2019, 11:04 PM
1// create keyspace
2CREATE KEYSPACE IF NOT EXISTS mystiko
3WITH replication = {
4 'class':'NetworkTopologyStrategy',
5 'DC1':'1'
6};
7
8// create udt
9CREATE TYPE IF NOT EXISTS mystiko.signature (
10 signer TEXT,
11 comment TEXT,
12 timestamp BIGINT,
13);
14
15// create table
16CREATE TABLE IF NOT EXISTS mystiko.documents (
17 id TIMEUUID,
18 company TEXT,
19 name TEXT,
20 tags SET<TEXT>,
21 signatures SET<frozen <signature>>,
22 status TEXT,
23 timestamp TIMESTAMP,
24 PRIMARY KEY(company, id)
25);