diff options
Diffstat (limited to 'src/main/docker/postgres_scripts/createdb.sql')
-rw-r--r-- | src/main/docker/postgres_scripts/createdb.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/src/main/docker/postgres_scripts/createdb.sql b/src/main/docker/postgres_scripts/createdb.sql new file mode 100644 index 0000000..dc843e7 --- /dev/null +++ b/src/main/docker/postgres_scripts/createdb.sql @@ -0,0 +1,25 @@ +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 +); + |