diff options
| author |   Jim Hahn <jrh3@att.com> | 2021-09-01 16:59:49 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2021-09-01 16:59:49 +0000 |
| commit | 2726735ee61ab5191adf23f8e33baf53fcb2667c (patch) | |
| tree | 23d649e1dad4075256a7e5a4fe2ae11cf0638ccb | |
| parent | dc2d473581b2837aec02d017f1a8dcc5d4d06ecd (diff) | |
| parent | 76a636370a60a519f5740a3266e627a92d040ed6 (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.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; |