3 files changed, 37 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;
diff --git a/scripts/music/cql/admin_pw.cql b/scripts/music/cql/admin_pw.cql
new file mode 100644
index 00000000..02de61e2
--- /dev/null
+++ b/scripts/music/cql/admin_pw.cql
@@ -0,0 +1,2 @@
+CREATE ROLE IF NOT EXISTS nelson24 WITH PASSWORD = 'winman123' AND SUPERUSER = True AND LOGIN = True;
+ALTER ROLE cassandra WITH PASSWORD = 'SomeLongRandomStringNoonewillthinkof';
diff --git a/scripts/music/cql/extra/test.cql b/scripts/music/cql/extra/test.cql
new file mode 100644
index 00000000..6a587201
--- /dev/null
+++ b/scripts/music/cql/extra/test.cql
@@ -0,0 +1 @@
+DESCRIBE keyspace admin;
+\ No newline at end of file