summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install
diff options
context:
space:
mode:
authoruj426b <30905205+uj426b@users.noreply.github.com>2019-03-28 18:40:54 -0400
committeruj426b <uj426b@att.com>2019-04-08 17:37:49 -0400
commit06e02108525c3e5e8c85de233aef3bb332173c00 (patch)
tree87554edd057f73a0fd7674d9a4a3c5f27f02b276 /packages/base/src/files/install
parent6da5838f43a4bf0dc8786c539f9a9aa521139e55 (diff)
CLAMP Model policy creation support
Change-Id: Ia69f061c078e4f6ed4b4d2cd12f03f58514f2123 Issue-ID: POLICY-1416 Signed-off-by: uj426b <uj426b@att.com>
Diffstat (limited to 'packages/base/src/files/install')
-rw-r--r--packages/base/src/files/install/mysql/data/190202_downgrade_script.sql4
-rw-r--r--packages/base/src/files/install/mysql/data/190202_upgrade_script.sql19
2 files changed, 21 insertions, 2 deletions
diff --git a/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql b/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql
index 2c0917428..d1ecebf04 100644
--- a/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/190202_downgrade_script.sql
@@ -17,4 +17,6 @@
-- ============LICENSE_END=========================================================
use onap_sdk;
-drop table if exists policyAuditlog; \ No newline at end of file
+drop table if exists policyAuditlog;
+drop table if exists dictionaryData;
+
diff --git a/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql b/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql
index 2b44c331f..f92da8d81 100644
--- a/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/190202_upgrade_script.sql
@@ -24,4 +24,21 @@ CREATE TABLE policyAuditlog (
actions varchar(50) NOT NULL,
dateAndTime datetime NOT NULL,
PRIMARY KEY (id)
-); \ No newline at end of file
+);
+
+ALTER TABLE microservicemodels
+ADD ruleFormation VARCHAR(45) DEFAULT NULL;
+
+CREATE TABLE `onap_sdk`.`dictionaryData` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `dictionaryName` varchar(64) NOT NULL,
+ `dictionaryUrl` varchar(64) NOT NULL,
+ `dictionaryDataByName` varchar(64) NOT NULL,
+ PRIMARY KEY (`id`)
+ );
+
+INSERT INTO dictionaryData (dictionaryName, dictionaryUrl, dictionaryDataByName)
+VALUES ('GocVNFType', 'getDictionary/get_GocVnfTypeDataByName', 'gocVnfTypeDictionaryDatas'),
+('ServerScope','getDictionary/get_ServerScopeDataByName','gocServerScopeDictionaryDatas'),
+('TraversalData', 'getDictionary/get_TraversalDataByName', 'gocTraversalDictionaryDatas');
+