From b1dfdd16ef3a5ab83f0e6f10bae818b90793878b Mon Sep 17 00:00:00 2001 From: ktimoney Date: Fri, 24 Sep 2021 08:07:55 +0100 Subject: Modify pdpstatistics to prevent duplicate keys Update timeStamp column in pdpstatistics to include microseconds. Issue-ID: POLICY-3679 Change-Id: Ibf622b090b1cd914413f79c663db8128263c4ac2 Signed-off-by: ktimoney --- .../docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'policy-db-migrator/src/main') diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql index 98e26993..256c31a7 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL; +ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL; -- cgit 1.2.3-korg