summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorktimoney <kevin.timoney@est.tech>2021-08-31 15:17:53 +0100
committerKevin Timoney <kevin.timoney@est.tech>2021-08-31 17:32:31 +0000
commit76a636370a60a519f5740a3266e627a92d040ed6 (patch)
treed23ba49d18e5244221a32006c379136be8d8c828
parentd7c35a17e190476bc05bcfd3374c2e38cecd48ed (diff)
Update default value of LASTUPDATE in pdp table
Update LASTUPDATE column in pdp table to use CURRENT_TIMESTAMP as default value Issue-ID: POLICY-3608 Change-Id: I28d267729ab3959a0d4602a4129737d6d8029f86 Signed-off-by: ktimoney <kevin.timoney@est.tech>
-rw-r--r--policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql
index 57a551da..934d89e8 100644
--- a/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql
+++ b/policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql
@@ -17,4 +17,4 @@
* ============LICENSE_END=========================================================
*/
-ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY;
+ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY;