diff options
Diffstat (limited to 'scripts/music/cql/admin.cql')
-rw-r--r-- | scripts/music/cql/admin.cql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/scripts/music/cql/admin.cql b/scripts/music/cql/admin.cql new file mode 100644 index 00000000..df13f32a --- /dev/null +++ b/scripts/music/cql/admin.cql @@ -0,0 +1,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; |