Seed code

[nonrtric/rapp/orufhrecovery.git] / scriptversion / docker-compose-controlloop / config / db / create-db.sql

diff --git a/scriptversion/docker-compose-controlloop/config/db/create-db.sql b/scriptversion/docker-compose-controlloop/config/db/create-db.sql
new file mode 100644 (file)
index 0000000..bc64431
--- /dev/null
+++ b/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;
+