summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql
diff options
context:
space:
mode:
authorrb7147 <rb7147@att.com>2017-09-27 16:33:51 -0400
committerrb7147 <rb7147@att.com>2017-09-27 16:34:08 -0400
commitb5caf28492a151d811dd3ce7e6ade26e56deade9 (patch)
treef593c839b989fbc4c510193638e174307e4256d2 /packages/base/src/files/install/mysql/data/171001_upgrade_script.sql
parent78c21e39873301cd41c72fe6f271454fd0c7f0a6 (diff)
Added R1 MS Tosca template
Added the MS Tosca template to db scripts and cleaned up old policies. Issue-Id: POLICY-264 Change-Id: I0ee5cffbb78d1f7df0379b71fe0f3368587aa9a6 Signed-off-by: rb7147 <rb7147@att.com>
Diffstat (limited to 'packages/base/src/files/install/mysql/data/171001_upgrade_script.sql')
-rw-r--r--packages/base/src/files/install/mysql/data/171001_upgrade_script.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql b/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql
index c6f6303bd..f1a3e9096 100644
--- a/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/171001_upgrade_script.sql
@@ -26,4 +26,6 @@ CREATE TABLE `onap_sdk`.`rainydaytreatments` (
`workstep` varchar(250) DEFAULT NULL,
`treatments` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`)
-); \ No newline at end of file
+);
+
+INSERT INTO `onap_sdk`.`microservicemodels` (`id`, `modelName`, `DESCRIPTION`, `Dependency`, `imported_by`, `attributes`, `ref_attributes`, `sub_attributes`, `version`) VALUES ('3', 'policy_tosca_tca', 'Micro Service Policy Tosca model', '[]', 'API', 'policyVersion=string:defaultValue-:required-true:MANY-false,policyName=string:defaultValue-:required-true:MANY-false,controlLoopSchemaType=string:defaultValue-:required-true:MANY-false,policyScope=string:defaultValue-:required-true:MANY-false,eventName=string:defaultValue-:required-true:MANY-false,', 'threshholds=Threshold:MANY-true,', '{\"Threshold\":{\"severity\":\"string:defaultValue-null:required-true:MANY-false\",\"fieldPath\":\"string:defaultValue-null:required-true:MANY-false\",\"thresholdValue\":\"integer:defaultValue-null:required-true:MANY-false\",\"closedLoopEventStatus\":\"string:defaultValue-null:required-true:MANY-false\",\"version\":\"string:defaultValue-1.0.2:required-true:MANY-false\",\"closedLoopControlName\":\"string:defaultValue-null:required-true:MANY-false\",\"direction\":\"string:defaultValue-null:required-true:MANY-false\"}}', '1.0.0');