From fe6c70997442979fe03cd417d271aa52e638c5d7 Mon Sep 17 00:00:00 2001 From: "Christopher Lott (cl778h)" Date: Thu, 25 May 2017 14:00:16 -0400 Subject: [Portal-7] Add scripts to create db in docker Change-Id: I327048c4dc3f0faea21fbda894cd22ed102346aa Signed-off-by: Christopher Lott (cl778h) --- .../dbca-os/db-scripts/dbca-create-mysql-1707-os.sql | 9 +++++++++ .../dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql | 4 +--- 2 files changed, 10 insertions(+), 3 deletions(-) create mode 100644 dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-create-mysql-1707-os.sql (limited to 'dcae_dmaapbc_webapp/dbca-os') diff --git a/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-create-mysql-1707-os.sql b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-create-mysql-1707-os.sql new file mode 100644 index 0000000..597cd0b --- /dev/null +++ b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-create-mysql-1707-os.sql @@ -0,0 +1,9 @@ +-- --------------------------------------------------------------------------------------------------------------- +-- DMaaB Bus Control Web App database script for 1707 ONAP: +-- Creates database and sets as default ("USE"). +-- Serves as the first part of a complete database script: +-- cat dbca-create-mysql-1707-os.sql ../../dbca-common/db-scripts/dbca-ddl-mysql-1707-common.sql dbca-dml-mysql-1707-os.sql > out.sql +-- --------------------------------------------------------------------------------------------------------------- + +CREATE DATABASE IF NOT EXISTS dbca_os; +USE dbca_os; diff --git a/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql index 5dc0e98..cced85b 100644 --- a/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql +++ b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql @@ -3,9 +3,7 @@ -- in the 1707 release with data for the open-source ONAP version. -- -- This file is suitable for deployment to Application Hosting in 1704 and later: --- 1. This file does NOT name the database; i.e., no statements like this: --- "use foo;" --- 2. This file uses "--" not NOT "/* */" comment notation; i.e., no statements from mysqldump like this: +-- This file uses "--" not NOT "/* */" comment notation; i.e., no statements from mysqldump like this: -- /*!40101 SET character_set_client = utf8 */; -- -- Most of the data loaded here is default data for the EP-SDK application (but much reduced). -- cgit 1.2.3-korg