aboutsummaryrefslogtreecommitdiffstats
path: root/volumes/mariadb/docker-entrypoint-initdb.d
AgeCommit message (Collapse)AuthorFilesLines
2018-09-25Create additional users with SO-MariaDBRamesh Parthasarathy2-0/+68
Create a regular and admin user with SO-MariaDB to be used by the containers Change-Id: I8c32496816adf6a1845eb392cbe2b06e246129ad Issue-ID: SO-1086 Signed-off-by: Ramesh Parthasarathy(rp6768)<rp6768@att.com>
2018-08-01Mariadb scripts for containerized environmentRob Daugherty10-380/+82
Note the following databases and users: requestdb: requestuser/request123 catalogdb: cataloguser/catalog123 camundabpmn: camundauser/camunda123 Removed all of the "bulkload" data for use cases from docker-config. If still required, this data is handled elsewhere now. Change-Id: Ie093ea0a335d35b9cdced394e290daae46b888b8 Issue-ID: SO-710 Signed-off-by: Rob Daugherty <rd472p@att.com>
2018-08-01Fix JDBC endpointSmokowski, Steve (ss835w)2-626/+0
Issue-ID: SO-708 Change-Id: Ie55f0ef8113677551fc591d399e5ef8863fde112 Signed-off-by: Smokowski, Steve (ss835w) <ss835w@us.att.com>
2018-05-23NETWORK_RECIPE for CM flowsRob Daugherty2-4/+6
Increased ACTION field in all recipe tables to 40 chars. Added VNF_RECIPE entries for VnfInPlaceUpdate and VnfConfigUpdate. Change-Id: Ifb1da0b31525b10c9620fd98ffe9cfd3d6a84182 Issue-ID: SO-639 Signed-off-by: Rob Daugherty <rd472p@att.com>
2018-05-18add a sql statement to create_mso_db-default.sqllvqidi1-0/+1
Issue-ID: SO-631 Change-Id: I495d79f6d9ade8d4e92d7ada47c795d04d9e3654 Signed-off-by: lqd123 <13648335186@163.com>
2018-05-04Add default entry in DB for e2e network deletesubhash kumar singh1-1/+2
Add default entry in DB for e2e network delete. Change-Id: I3e5c32b55047b295b5196c551186b52bba00b879 Issue-ID: SO-422 Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
2018-05-04Add default receipe entry for e2e deletesubhash kumar singh1-0/+1
Add default receipe entry for e2e delete. Change-Id: Ie13005f4da369e18affd0d57e77f94ea24851f57 Issue-ID: SO-422 Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
2018-04-19Add default network resouce bpmn for e2esubhash kumar singh1-0/+1
Add default work flow for network resource creation. Change-Id: I9db785704ab22d5702a8f7c9f7e4a8535295bf82 Issue-ID: SO-422 Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
2018-04-18Add default entry for VNF receipesubhash kumar singh1-0/+1
Add default entry for VNF receipe (custom E2E). Change-Id: Ic5a96c0aaeb9ebdee86ae7b0f31cf3b9dd698250 Issue-ID: SO-422 Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
2018-04-04Two database schema issuesRob Daugherty3-18/+34
1. The operation_status table is missing the service_name column, which was added in the amsterdam release 2. Table camundabpmn.ACT_HI_VARINST has no column STATE_ Change-Id: Ifadfce23a78b9404b677c1a9597003b3c8b9187d Issue-ID: SO-560 Signed-off-by: Rob Daugherty <rd472p@att.com>
2018-04-02Update MySQL schema scriptsRob Daugherty2-45/+101
Note that these should be updated whenever the hibernate (hbm.xml) definition files are modified in the "so" repo. Change-Id: Ia12164813977cdb52a13397671d8dd3be5eac407 Issue-ID: SO-557 Signed-off-by: Rob Daugherty <rd472p@att.com>
2018-03-26Merge "Modify SERVICE table schema"Chuanyu Chen1-0/+2
2018-03-25Modify SERVICE table schemasubhash kumar singh1-0/+2
Modify service table schema as per the defined model. Add two column: `ENVIRONMENT_CONTEXT` varchar(200) DEFAULT NULL, `WORKLOAD_CONTEXT` varchar(200) DEFAULT NULL, Change-Id: I64b8c790a5e8798199f3dd16ab200fa3f63cd883 Issue-ID: SO-422 Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
2018-03-12Merge "Add default vfc ns resource recipe"Chuanyu Chen1-0/+2
2018-03-12Add default vfc ns resource recipec001491071-0/+2
Add default vfc ns resource recipe Change-Id: I0d7352c3feddcb243b348a9b54c923d243cabaac Issue-ID: SO-452 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
2018-03-06Merge "Add allotted resource recipe table"Chuanyu Chen1-0/+16
2018-03-06Add allotted resource recipe tablec001491071-0/+16
Add allotted resource recipe table Change-Id: I15b81651ad2a97706ff398068ac011173a78cfe8 Issue-ID: SO-456 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
2018-03-05add default updateInstance action for e2e svcinstOpenO05/h002584291-0/+4
Change-Id: Idaa55084f5ecb0dd3636c232cebc14fa5f0641c4 Issue-ID: SO-419 Signed-off-by: Yulian Han <elaine.hanyulian@huawei.com> volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/bulkload-files/default/create_mso_db-default.sql
2018-02-08Merge "Updated Service deployment changes not reflected"Seshu Kumar M1-2/+2
2018-02-07Updated Service deployment changes not reflectedAbhishek Shekhar1-2/+2
Change-Id: I04df700ebd2a3eccf13a1d77f6d49e74cedad686 Issue-ID: SO-271 Signed-off-by: Abhishek Shekhar <abhishek.shekhar1@amdocs.com>
2018-01-30Merge "Default Recipe Mapping for Service"Seshu Kumar M1-0/+3
2018-01-23Default Recipe Mapping for ServiceAbhishek Shekhar1-0/+3
Change-Id: I96cb5c1236bbbd61f691f0b91c24ea33d465b8fa Issue-ID: SO-384 Signed-off-by: Abhishek Shekhar <abhishek.shekhar1@amdocs.com>
2018-01-19Add Category info For Service and Resourcec001491071-0/+5
Add Category info For Service and Resource,Its used for generic workflow Change-Id: I073b8ac5503b462664b3806834a0aca9892c40b9 Issue-ID: SO-379 Signed-off-by: c00149107 <chenchuanyu@huawei.com>
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 Daugherty14-2972/+294
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 commitpiclose14-0/+1499
Change-Id: Iaabe6803a6087f59726e290cb75aef2f755097d9 Signed-off-by: piclose <pc457b@intl.att.com>