From: Smokowski, Kevin (ks6305) <kevin.smokowski@att.com>
Date: Thu, 13 Dec 2018 14:45:12 +0000 (+0000)
Subject: update SVC_LOGIC table
X-Git-Tag: 0.4.0~2^2
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=ccsdk%2Fdistribution.git;a=commitdiff_plain;h=49775f10d5cf547cfbb65b8b02c23acaa1b4d169

update SVC_LOGIC table

Add missing columns modified_timestamp and md5sum

Change-Id: I1719323459eacd895a8ae4ddd75c3df2a5df5953
Issue-ID: CCSDK-828
Signed-off-by: Smokowski, Kevin (ks6305) <kevin.smokowski@att.com>
---

diff --git a/odlsli/src/main/resources/odlsli.dump b/odlsli/src/main/resources/odlsli.dump
index 6f8217c4..e6b6222a 100644
--- a/odlsli/src/main/resources/odlsli.dump
+++ b/odlsli/src/main/resources/odlsli.dump
@@ -865,6 +865,8 @@ CREATE TABLE `SVC_LOGIC` (
   `mode` varchar(5) NOT NULL,
   `active` varchar(1) NOT NULL,
   `graph` longblob,
+  `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `md5sum` varchar(128) DEFAULT NULL,
   PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;