summaryrefslogtreecommitdiffstats
path: root/src/main/docker/postgres_scripts/createdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/docker/postgres_scripts/createdb.sql')
-rw-r--r--src/main/docker/postgres_scripts/createdb.sql25
1 files changed, 0 insertions, 25 deletions
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
-);
-