summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLiam Fallon <liam.fallon@est.tech>2022-03-24 09:17:46 +0000
committerGerrit Code Review <gerrit@onap.org>2022-03-24 09:17:46 +0000
commit400bdca9ea3a694e390cf3914bc5012e62a6072f (patch)
treefe819542f1cc1cfb8ced22cf4e421220f90297cd
parent209e2e6843ef0057f5ba2b371bcd0cf2769456d9 (diff)
parent44128c3e4e95d3815ea13ab3b12479fe50e50e37 (diff)
Merge "Fix postgres scripts"
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql2
3 files changed, 3 insertions, 3 deletions
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql
index 5cf66cf2..17c4e6a8 100644
--- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql
+++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql
@@ -17,4 +17,4 @@
* ============LICENSE_END=========================================================
*/
-ALTER TABLE pdpstatistics ALTER COLUMN timeStamp TIMESTAMP(6);
+ALTER TABLE pdpstatistics ALTER COLUMN timeStamp TYPE TIMESTAMP(6);
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql
index 5dc6a940..7cb176e5 100644
--- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql
+++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql
@@ -17,5 +17,5 @@
* ============LICENSE_END=========================================================
*/
-ALTER TABLE jpapolicyaudit DROP CONSTRAINT PRIMARY KEY;
+ALTER TABLE jpapolicyaudit DROP CONSTRAINT pk_jpapolicyaudit;
ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID);
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql
index 5616b946..951e3410 100644
--- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql
+++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql
@@ -17,5 +17,5 @@
* ============LICENSE_END=========================================================
*/
-ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY;
+ALTER TABLE pdpstatistics DROP CONSTRAINT pk_pdpstatistics;
ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID);