From 9abb61ca2cea1907cab2cec312d6dca6e53a93cd Mon Sep 17 00:00:00 2001
From: Gary Wu <gary.i.wu@huawei.com>
Date: Thu, 27 Sep 2018 10:38:50 -0700
Subject: Move CSIT to integration/csit repo

To facilite branching of CSIT tests, all CSIT test
code and scripts are relocated to the integration/csit
repo.

Change-Id: I1e4c0eff44691f73f8098b3c52764107f6b8b8df
Issue-ID: INT-671
Signed-off-by: Gary Wu <gary.i.wu@huawei.com>
---
 scripts/music/cql/admin.cql      | 34 ++++++++++++++++++++++++++++++++++
 scripts/music/cql/admin_pw.cql   |  2 ++
 scripts/music/cql/extra/test.cql |  1 +
 3 files changed, 37 insertions(+)
 create mode 100644 scripts/music/cql/admin.cql
 create mode 100644 scripts/music/cql/admin_pw.cql
 create mode 100644 scripts/music/cql/extra/test.cql

(limited to 'scripts/music/cql')

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
-- 
cgit 1.2.3-korg