aboutsummaryrefslogtreecommitdiffstats
path: root/test/csit/scripts/music
diff options
context:
space:
mode:
Diffstat (limited to 'test/csit/scripts/music')
-rw-r--r--test/csit/scripts/music/cql/admin.cql34
-rw-r--r--test/csit/scripts/music/cql/admin_pw.cql2
-rw-r--r--test/csit/scripts/music/cql/extra/test.cql1
3 files changed, 37 insertions, 0 deletions
diff --git a/test/csit/scripts/music/cql/admin.cql b/test/csit/scripts/music/cql/admin.cql
new file mode 100644
index 000000000..df13f32ae
--- /dev/null
+++ b/test/csit/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/test/csit/scripts/music/cql/admin_pw.cql b/test/csit/scripts/music/cql/admin_pw.cql
new file mode 100644
index 000000000..02de61e2e
--- /dev/null
+++ b/test/csit/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/test/csit/scripts/music/cql/extra/test.cql b/test/csit/scripts/music/cql/extra/test.cql
new file mode 100644
index 000000000..6a5872011
--- /dev/null
+++ b/test/csit/scripts/music/cql/extra/test.cql
@@ -0,0 +1 @@
+DESCRIBE keyspace admin; \ No newline at end of file