summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorjhh <jorge.hernandez-herrero@att.com>2022-09-26 11:21:11 -0500
committerjhh <jorge.hernandez-herrero@att.com>2022-09-26 11:22:57 -0500
commit2d12b6a937a9e53bace4486b202d1977c8ad24f2 (patch)
tree8e5717ac1f7627683e3be34878959f857783e87c
parentb42e596ac2c2102ab94b0df73a04c406e8da2b26 (diff)
db-migrator SQL compatibility mysql/mariadb
Issue-ID: POLICY-3464 Signed-off-by: jhh <jorge.hernandez-herrero@att.com> Change-Id: I6b1fd22062ca4f55c036bc2632307454a1f00840
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0140-pk_pdpstatistics.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql2
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql2
5 files changed, 5 insertions, 5 deletions
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);