From ba599113b6381d63011e4015cec648f33466d233 Mon Sep 17 00:00:00 2001 From: ktimoney Date: Tue, 28 Sep 2021 10:37:39 +0100 Subject: Retain datetime precision on downgrade Retain datetime precision during downgrade operation to prevent duplicate keys in pdpstatistics Issue-ID: POLICY-3679 Change-Id: Ic93519b9420f0f77c3af7b63d3963f1971d77c37 Signed-off-by: ktimoney --- .../docker/config/policyadmin/sql/0900/downgrade/0150-pdpstatistics.sql | 2 +- .../sql/0900/downgrade/0180-jpapdpstatistics_enginestats.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0150-pdpstatistics.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0150-pdpstatistics.sql index 4bf55e84..1174fce7 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0150-pdpstatistics.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0150-pdpstatistics.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL; +ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0180-jpapdpstatistics_enginestats.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0180-jpapdpstatistics_enginestats.sql index 64b1ad54..eb8f6a0f 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0180-jpapdpstatistics_enginestats.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/downgrade/0180-jpapdpstatistics_enginestats.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME; +ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME; -- cgit 1.2.3-korg