From 44128c3e4e95d3815ea13ab3b12479fe50e50e37 Mon Sep 17 00:00:00 2001 From: waynedunican Date: Wed, 23 Mar 2022 08:28:21 +0000 Subject: Fix postgres scripts Fix for syntax errors in postgres scripts Issue-ID: POLICY-2715 Change-Id: I109056f7ee37b439f914fbd5d1d0ca87df550e4e Signed-off-by: Wayne Dunican --- .../config/policyadmin/postgres/0900/upgrade/0150-pdpstatistics.sql | 2 +- .../config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql | 2 +- .../config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'policy-db-migrator/src') 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); -- cgit 1.2.3-korg