| commit | 76a636370a60a519f5740a3266e627a92d040ed6 | [log] [tgz] |
|---|---|---|
| author | ktimoney <kevin.timoney@est.tech> | Tue Aug 31 15:17:53 2021 +0100 |
| committer | Kevin Timoney <kevin.timoney@est.tech> | Tue Aug 31 17:32:31 2021 +0000 |
| tree | d23ba49d18e5244221a32006c379136be8d8c828 | |
| parent | d7c35a17e190476bc05bcfd3374c2e38cecd48ed [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>
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 57a551d..934d89e 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;