diff options
author | Manamohan <MS00534989@techmahindra.com> | 2019-12-12 15:15:46 +0530 |
---|---|---|
committer | Manamohan Satapathy <MS00534989@Techmahindra.com> | 2019-12-17 05:15:17 +0000 |
commit | b39509088a320c5c60b26f74ced3f420d217c376 (patch) | |
tree | 409a5dbf0720754910e234f00941778dcb109233 /adapters | |
parent | 02c068ce771ee4522936f2d15f41c2b631e965a8 (diff) |
Implementing scope and action values from SO-DB to SO-Backend
Issue-ID: SO-2513
Change-Id: I002a35a2a8ff4730d45c23d54f0acd4496b8b585
Signed-off-by: Manamohan <MS00534989@Techmahindra.com>
Diffstat (limited to 'adapters')
2 files changed, 7 insertions, 0 deletions
diff --git a/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.2__AddScopeAndActionColumnsInOrchestrationFlowReference.sql b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.2__AddScopeAndActionColumnsInOrchestrationFlowReference.sql new file mode 100644 index 0000000000..19bfb0f1e1 --- /dev/null +++ b/adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.2__AddScopeAndActionColumnsInOrchestrationFlowReference.sql @@ -0,0 +1,5 @@ +use catalogdb; + +ALTER TABLE orchestration_flow_reference +ADD SCOPE VARCHAR (200) DEFAULT NULL, +ADD ACTION VARCHAR (200) DEFAULT NULL;
\ No newline at end of file diff --git a/adapters/mso-openstack-adapters/src/test/resources/schema.sql b/adapters/mso-openstack-adapters/src/test/resources/schema.sql index b96d58f419..6b791e789c 100644 --- a/adapters/mso-openstack-adapters/src/test/resources/schema.sql +++ b/adapters/mso-openstack-adapters/src/test/resources/schema.sql @@ -735,6 +735,8 @@ CREATE TABLE `orchestration_flow_reference` ( `SEQ_NO` int(11) NOT NULL, `FLOW_NAME` varchar(200) NOT NULL, `FLOW_VERSION` double NOT NULL, + `SCOPE` varchar(200) DEFAULT NULL, + `ACTION` varchar(200) DEFAULT NULL, `NB_REQ_REF_LOOKUP_ID` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_orchestration_flow_reference` (`COMPOSITE_ACTION`,`FLOW_NAME`,`SEQ_NO`,`NB_REQ_REF_LOOKUP_ID`), |