diff options
| author |   ktimoney <kevin.timoney@est.tech> | 2021-08-31 15:17:53 +0100 |
|---|---|---|
| committer | Kevin Timoney <kevin.timoney@est.tech> | 2021-08-31 17:32:31 +0000 |
| commit | 76a636370a60a519f5740a3266e627a92d040ed6 (patch) | |
| 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>
| -rw-r--r-- | policy-db-migrator/src/main/docker/config/policyadmin/sql/0900/upgrade/0100-pdp.sql | 2 |
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; |