aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorktimoney <kevin.timoney@est.tech>2021-09-24 08:07:55 +0100
committerktimoney <kevin.timoney@est.tech>2021-09-27 08:39:12 +0100
commitb1dfdd16ef3a5ab83f0e6f10bae818b90793878b (patch)
treec963da62cb479962381470db409393602c508a55
parent6d1dfc12e5648cdf361b678575b946a5ff2f8ec7 (diff)
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 <kevin.timoney@est.tech>
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0150-pdpstatistics.sql2
1 files changed, 1 insertions, 1 deletions
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;