diff options
| author |   ktimoney <kevin.timoney@est.tech> | 2021-09-24 08:07:55 +0100 |
|---|---|---|
| committer | ktimoney <kevin.timoney@est.tech> | 2021-09-27 08:39:12 +0100 |
| commit | b1dfdd16ef3a5ab83f0e6f10bae818b90793878b (patch) | |
| tree | c963da62cb479962381470db409393602c508a55 | |
| parent | 6d1dfc12e5648cdf361b678575b946a5ff2f8ec7 (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.sql | 2 |
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; |