diff options
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/application.properties | 9 | ||||
| -rw-r--r-- | src/main/resources/logback.xml | 2 | ||||
| -rw-r--r-- | src/main/resources/schema.sql | 27 |
3 files changed, 34 insertions, 4 deletions
diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties index 5905adf..c8bf90c 100644 --- a/src/main/resources/application.properties +++ b/src/main/resources/application.properties @@ -19,11 +19,14 @@ # ############################################################################### -spring.datasource.url= jdbc:postgresql://pcims-db:5432/sonh_ms -spring.datasource.username=postgres +spring.datasource.initialization-mode=always -spring.datasource.password=password +spring.datasource.initialize=true + +spring.datasource.schema=classpath:/schema.sql + +spring.datasource.continue-on-error=true spring.jpa.hibernate.ddl-auto=validate diff --git a/src/main/resources/logback.xml b/src/main/resources/logback.xml index 160ff9c..b7baa6f 100644 --- a/src/main/resources/logback.xml +++ b/src/main/resources/logback.xml @@ -28,7 +28,7 @@ <sift> <appender name="file-${logFileName}" class="ch.qos.logback.core.rolling.RollingFileAppender"> - <file>/var/log/onap/pci-handler/${logFileName}.log</file> + <file>/var/log/onap/son-handler/${logFileName}.log</file> <rollingPolicy class="ch.qos.logback.core.rolling.FixedWindowRollingPolicy"> <fileNamePattern>${logFileName}.%i.log.zip</fileNamePattern> <minIndex>1</minIndex> diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql new file mode 100644 index 0000000..88b64d5 --- /dev/null +++ b/src/main/resources/schema.sql @@ -0,0 +1,27 @@ +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 +); +CREATE TABLE FAULT_NOTIFICATIONS( + notification TEXT PRIMARY KEY NOT NULL, + created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP +); + |