From 2d12b6a937a9e53bace4486b202d1977c8ad24f2 Mon Sep 17 00:00:00 2001 From: jhh Date: Mon, 26 Sep 2022 11:21:11 -0500 Subject: db-migrator SQL compatibility mysql/mariadb Issue-ID: POLICY-3464 Signed-off-by: jhh Change-Id: I6b1fd22062ca4f55c036bc2632307454a1f00840 --- .../config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql | 2 +- .../config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql | 2 +- .../config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql | 2 +- .../config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql | 2 +- .../config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-) (limited to 'policy-db-migrator') diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql index 012344b9..548b26de 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql @@ -17,6 +17,6 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY; +ALTER TABLE pdpstatistics DROP PRIMARY KEY; UPDATE pdpstatistics set ID = 0; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql index 3a3d3ea9..328a40e7 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql @@ -17,5 +17,5 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE jpapolicyaudit DROP CONSTRAINT PRIMARY KEY; +ALTER TABLE jpapolicyaudit DROP PRIMARY KEY; ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql index 08065e42..d086a520 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql @@ -17,5 +17,5 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY; +ALTER TABLE pdpstatistics DROP PRIMARY KEY; ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql index 5dc6a940..03addfa2 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql @@ -17,5 +17,5 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE jpapolicyaudit DROP CONSTRAINT PRIMARY KEY; +ALTER TABLE jpapolicyaudit DROP PRIMARY KEY; ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql index 5616b946..0ec69d84 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql @@ -17,5 +17,5 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY; +ALTER TABLE pdpstatistics DROP PRIMARY KEY; ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID); -- cgit 1.2.3-korg