diff options
| author |   waynedunican <wayne.dunican@est.tech> | 2022-03-23 08:28:21 +0000 |
|---|---|---|
| committer | Wayne Dunican <wayne.dunican@est.tech> | 2022-03-23 08:29:38 +0000 |
| commit | 44128c3e4e95d3815ea13ab3b12479fe50e50e37 (patch) | |
| tree | a2680decab0795748897f1f82fd248ceee0711cb | |
| parent | 93d4ee603e563d292845e12b85811bd9e8c42d44 (diff) | |
Fix postgres scripts
Fix for syntax errors in postgres scripts
Issue-ID: POLICY-2715
Change-Id: I109056f7ee37b439f914fbd5d1d0ca87df550e4e
Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
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); |