aboutsummaryrefslogtreecommitdiffstats
path: root/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts
AgeCommit message (Collapse)AuthorFilesLines
2017-11-13temp fix to unblock the policy operations on VNFseshukm1-0/+11
IssueId: SO-334 Change-Id: I5fff881305a7f17f8a1088eeb2805f80b3b93d6f Signed-off-by: seshukm <seshu.kumar.m@huawei.com>
2017-10-30Generic NeutronNet name changeRob Daugherty1-1/+1
SDC named the generic neturon network object as "Generic NeutronNet". This commit changes the name of the heat template to match SDC's name. Issue: SO-284 Change-Id: I868cefe255b22df9e076946ff76fc2d83b38d3e8 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-26Add generic neutron HEAT templateRob Daugherty1-0/+3
This template was provided by Brian Freeman. Issue: SO-265 Change-Id: I095270317f9571a7cd497ac5ef49fb84840a9803 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-24NetworkResource modelInvariantUUID is too shortRob Daugherty1-1/+1
It is currently 20. It should be 200. Issue: SO-264 Change-Id: Id216d58a049c00c76a87e14fd62754d4ce15b9c0 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-23fix for the inappropriate DB type in heat templateSeshu-Kumar-M1-1/+1
Change-Id: Ia3ef236265356186b2ef78a6015e6220826cc736 IssueId: SO-247 Signed-off-by: Seshu-Kumar-M <seshu.kumar.m@huawei.com>
2017-10-23Add Service Name Column for Operation Statusc001491071-0/+1
Add Service Name Columnfor Operation Status Change-Id: I135ca46cad4830e89f5475cbcc3a0a53778ec9b6 Issue-ID:SO-257 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
2017-10-23Add Tables neededc001491071-1/+26
Add Operation_status and resource_operation_status table Change-Id: Ieb20d76fa94a8f44adcf0b11c44f11ac0a666b07 Issue-ID:SO-255 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
2017-10-23Recipe added for VoLTE serviceseshukm1-0/+9
IssueId: SO-251 Change-Id: I9a230c62ed59d5f143e7414053e45fc01cbaebce Signed-off-by: seshukm <seshu.kumar.m@huawei.com>
2017-10-19Fix the DB loading scriptRob Daugherty1-14/+14
These are updates from Byung-Woo Jun and Andrew Fenner. Issue: SO-229 Change-Id: Ibcde5fd565a68977da4f94ac7623f35e3fd63b0e Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-13Timestamps now in hibernate definitionsRob Daugherty5-56/+25
We don't need the scripts that add the timestamp columns. Issue: SO-215 Change-Id: I1635874df4f0a34fede96cacdaa4134c89f23e7b Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-05Restructure catalog data for new schemaRob Daugherty3-197/+192
Updated pre-configured catalog data to fit the new schema. This includes the vFW and DNS demo data. Issue: SO-192 Change-Id: Ibf3177849010d90d405419f4ca5ad724245052a5 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-05Remove foreign key which is not supported by codeRob Daugherty1-9/+0
The foreign key we fixed in the VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM table is blocking distribution of the model. The insert that's failing is: insert into VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM ( VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID) values (?, ?); The error is: "foreign key constraint fails" Issue: SO-180 Change-Id: I19cda2d4dae86e3257723f0fea6921049e391aca Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-10-04Fix schema mismatchRob Daugherty4-4/+34
Updated MySQL-Catalog-schema.sql to match the Hibernate class definitions. Restored the scripts that add default values for CREATION_TIMESTAMP columns. Issue: SO-180 Change-Id: Ie76059f4c2497060a4fba8744e974b29d33b16f1 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-09-28Set camunda cockpit passwordRob Daugherty1-19/+18
The camunda cockpit admin login should be the same as the jboss admin user login. Change-Id: I6bea8049e0f34a9c4e638a34b85574fccd21e444 Issue-id: SO-167 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-09-21Update catalog schema in docker environmentRob Daugherty13-2971/+290
Updated the the SQL scripts that create the DB schema in the docker environment. Removed old unused versions of camunda DB setup scripts. Commented out the vFW catalog data which is incompatible with the new schema. Change-Id: I6a430248881300ebd9a45ebdb99045ed696fe4ab Issue-id: SO-147 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-09-19Update the admin user creation scriptRob Daugherty1-9/+26
The admin user is not set up correctly in the database because the schema has changed. Change-Id: I6f39e12f7e1739d3c2152e0173da51aad1d2ad1c Issue-id: SO-148 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-09-08Merge "1710 Rebase - docker config"Rob Daugherty2-2/+1196
2017-09-071710 Rebase - docker configRob Daugherty2-2/+1196
1710 includes a new version of Camunda (7.7.3). These are updates to the camundabpmn DB installation scripts. Change-Id: I7a324683e70690bfa1995f7c2f7bb322475ff51f Issue-id: SO-107 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-08-31Add Operation Status Tablec001491071-0/+26
Add Operation Status Table for save the request progress Change-Id: I92fd713bbcc0b3045b698a9e6e3f6c0a1383e0c8 Issue-ID:SO-41 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
2017-07-27fixed for defect SO-70 - recipe lookup mechanism doesn't allow to define ↵eyalholz1-0/+3
default recipe mapping for any 'source' at level of 'service' and 'network' resources. Change-Id: I184dacec5d1f8ec72d2972f00620daff0e82cd03 Signed-off-by: eyalholz <eyalh@amdocs.com>
2017-07-06[SO-21] MSO returning error to VID...Rob Daugherty1-2/+2
...during create service instance 1) Change CreateServiceInstance to CreateGenericALaCarteServiceInstance in the mso_catalog database 2) Add a URN property: mso.workflow.global.default.aai.namespace=http://org.openecomp.aai.inventory/ 3) Add a URN property: aai.auth=2630606608347B7124C244AB0FE34F6F Change-Id: Ic20e008a39122a6f2e3176efbff28bec799e4413 Signed-off-by: Rob Daugherty <rd472p@att.com>
2017-05-03Update sql commandxg353y1-1/+1
Update the network_recipe db table, change the bpmn script to use. Change-Id: I054e06136b30d18558c90eada4bdc9618241acd5 Signed-off-by: xg353y <xg353y@intl.att.com>
2017-04-11[MSO-8] Bring up 1702 changesxg353y9-44/+2092
Rework the env files values for BPMN URN. Add SNIOR related configuration parameters. Change-Id: Ica3e643e3938d68d09d6c2d18cd16178fb03751f Signed-off-by: xg353y <xg353y@intl.att.com>
2017-02-21Initial OpenECOMP MSO Docker Configuration commitpiclose12-0/+1450
Change-Id: Iaabe6803a6087f59726e290cb75aef2f755097d9 Signed-off-by: piclose <pc457b@intl.att.com>