aboutsummaryrefslogtreecommitdiffstats
path: root/scripts/music/cql/admin.cql
blob: df13f32aeb82f4daabac8c51d96c72529677a791 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
CREATE KEYSPACE IF NOT EXISTS admin
    WITH REPLICATION = {
        'class' : 'SimpleStrategy',
        'replication_factor': 1
    }
    AND DURABLE_WRITES = true;
 
CREATE TABLE IF NOT EXISTS admin.keyspace_master (
    uuid uuid,
    keyspace_name text,
    application_name text,
    is_api boolean,
    password text,
    username text,
    is_aaf boolean,
    PRIMARY KEY (uuid)
);

CREATE TABLE IF NOT EXISTS admin.notification_master (
    id uuid,
    current_notifier text,
    endpoint_password blob,
    endpoint_userid text,
    notify_delete_on text,
    notify_insert_on text,
    notify_to_endpoint text,
    notify_update_on text,
    notifyon text PRIMARY KEY,
    request text
);



describe keyspace admin;