summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJim Hahn <jrh3@att.com>2021-09-01 16:59:49 +0000
committerGerrit Code Review <gerrit@onap.org>2021-09-01 16:59:49 +0000
commit2726735ee61ab5191adf23f8e33baf53fcb2667c (patch)
tree23d649e1dad4075256a7e5a4fe2ae11cf0638ccb
parentdc2d473581b2837aec02d017f1a8dcc5d4d06ecd (diff)
parent76a636370a60a519f5740a3266e627a92d040ed6 (diff)
Merge "Update default value of LASTUPDATE in pdp table"
-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;