X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=test%2Fusecases%2Foruclosedlooprecovery%2Fscriptversion%2Fdocker-compose-controlloop%2Fconfig%2Fdb%2Fcreate-db.sql;fp=test%2Fusecases%2Foruclosedlooprecovery%2Fscriptversion%2Fdocker-compose-controlloop%2Fconfig%2Fdb%2Fcreate-db.sql;h=bc6443122966f9449ef343a13f8e35dae576769e;hb=1365d5faf34f84a2f427bada95f4bc67a15c5bec;hp=0000000000000000000000000000000000000000;hpb=1bcbc465addd5953b59dd953acb8e2aa586b3be6;p=nonrtric.git

diff --git a/test/usecases/oruclosedlooprecovery/scriptversion/docker-compose-controlloop/config/db/create-db.sql b/test/usecases/oruclosedlooprecovery/scriptversion/docker-compose-controlloop/config/db/create-db.sql
new file mode 100644
index 00000000..bc644312
--- /dev/null
+++ b/test/usecases/oruclosedlooprecovery/scriptversion/docker-compose-controlloop/config/db/create-db.sql
@@ -0,0 +1,13 @@
+#
+# Create CLDS database objects (tables, etc.)
+#
+#
+CREATE DATABASE IF NOT EXISTS `cldsdb4`;
+CREATE DATABASE IF NOT EXISTS `policyadmin`;
+CREATE DATABASE IF NOT EXISTS `controlloop`;
+USE `cldsdb4`;
+DROP USER 'clds';
+CREATE USER 'clds';
+GRANT ALL on cldsdb4.* to 'clds' identified by 'sidnnd83K' with GRANT OPTION;
+FLUSH PRIVILEGES;
+