summaryrefslogtreecommitdiffstats
path: root/src/main/docker/postgres_scripts
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/docker/postgres_scripts')
-rw-r--r--src/main/docker/postgres_scripts/Dockerfile7
-rw-r--r--src/main/docker/postgres_scripts/createdb.sql25
-rw-r--r--src/main/docker/postgres_scripts/init_db.sh23
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"