diff options
| author |   Jorge Hernandez <jorge.hernandez-herrero@att.com> | 2019-04-09 14:34:04 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2019-04-09 14:34:04 +0000 |
| commit | 279bf7ca260e3541ec3c54dcfc269a925f676c43 (patch) | |
| tree | 4bf04e4b53c7b59efa91c7852374089c61f779d7 /packages/base/src/files/install/mysql | |
| parent | 1b1640ae538cfdb3667fd3222dc4dec469b0e3f7 (diff) | |
| parent | 06e02108525c3e5e8c85de233aef3bb332173c00 (diff) | |
Merge "CLAMP Model policy creation support"
Diffstat (limited to 'packages/base/src/files/install/mysql')
| -rw-r--r-- | packages/base/src/files/install/mysql/data/190202_downgrade_script.sql | 4 | ||||
| -rw-r--r-- | packages/base/src/files/install/mysql/data/190202_upgrade_script.sql | 19 |
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'); + |