From 76a636370a60a519f5740a3266e627a92d040ed6 Mon Sep 17 00:00:00 2001 From: ktimoney Date: Tue, 31 Aug 2021 15:17:53 +0100 Subject: 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 --- .../src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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; -- cgit 1.2.3-korg