diff options
Diffstat (limited to 'src/main/docker/postgres_scripts')
-rw-r--r-- | src/main/docker/postgres_scripts/Dockerfile | 7 | ||||
-rw-r--r-- | src/main/docker/postgres_scripts/createdb.sql | 25 | ||||
-rw-r--r-- | src/main/docker/postgres_scripts/init_db.sh | 23 |
3 files changed, 0 insertions, 55 deletions
diff --git a/src/main/docker/postgres_scripts/Dockerfile b/src/main/docker/postgres_scripts/Dockerfile deleted file mode 100644 index 9ccb016..0000000 --- a/src/main/docker/postgres_scripts/Dockerfile +++ /dev/null @@ -1,7 +0,0 @@ -from busybox - -RUN mkdir /docker-entrypoint-initdb.d - -ADD createdb.sql /tmp - - diff --git a/src/main/docker/postgres_scripts/createdb.sql b/src/main/docker/postgres_scripts/createdb.sql deleted file mode 100644 index dc843e7..0000000 --- a/src/main/docker/postgres_scripts/createdb.sql +++ /dev/null @@ -1,25 +0,0 @@ -CREATE DATABASE sonh_ms; -\c sonh_ms -CREATE TABLE DMAAP_NOTIFICATIONS( - notification TEXT PRIMARY KEY NOT NULL, - created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP -); -CREATE TABLE BUFFERED_NOTIFICATIONS( - notification TEXT PRIMARY KEY NOT NULL, - cluster_id TEXT NOT NULL, - created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP -); -CREATE TABLE CLUSTER_DETAILS( - cluster_id TEXT PRIMARY KEY NOT NULL, - cluster_info TEXT NOT NULL, - child_thread_id BIGINT UNIQUE NOT NULL -); -CREATE TABLE CELL_INFO( - cell_id TEXT PRIMARY KEY NOT NULL, - pnf_name TEXT NOT NULL -); -CREATE TABLE PCI_REQUESTS( - transaction_id TEXT PRIMARY KEY, - child_thread_id BIGINT UNIQUE NOT NULL -); - diff --git a/src/main/docker/postgres_scripts/init_db.sh b/src/main/docker/postgres_scripts/init_db.sh deleted file mode 100644 index f01eea6..0000000 --- a/src/main/docker/postgres_scripts/init_db.sh +++ /dev/null @@ -1,23 +0,0 @@ -#!/bin/bash -#******************************************************************************* -# ============LICENSE_START======================================================= -# son-handler -# ================================================================================ -# Copyright (C) 2019 Wipro Limited. -# ============================================================================== -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -# -#******************************************************************************* - -psql -U postgres -tc "SELECT 1 FROM pg_database WHERE datname = 'pci_ms'" | grep -q 1 || psql -U postgres -c "CREATE DATABASE pci_ms" |