Alexis, You’ll want to add that to the SDNC database, not CCSDK. That CCSDK database isn’t really used in the SDNC or APPC container – it’s only there really for testing of CCSDK in isolation (for example, for CSIT).
The database is installed in sdnc/oam/installation/src/main/scripts/installSdncDb.sh. That script installs sdnc/oam/installation/src/main/resources/sdnctl.dump first, then loops through sdnc/oam/installation/src/main/resources/*.data.dump and installs all of those. Those files are all assumed to have been created by mysqldump, but really at the end of the day those files are just SQL scripts. So, probably the easiest way to create those 2 new tables would be to add a new .data.dump file containing either a dump of those new tables (I generally just add them to a local db in my dev env and do a mysqldump to dump them) or you could just write a SQL script to add them and call it something that ends in .data.dump and they’ll get added by the existing installSdncDb.sh script. Dan -- Dan Timoney SDN-CP Development ONAP Project Technical Lead : CCSDK and SDNC Please go to D2 ECOMP Release Planning Wiki<https://wiki.web.att.com/display/DERP/D2+ECOMP+Release+Planning+Home> for D2 ECOMP Project In-take, 2016 Release Planning, Change Management, and find key Release Planning Contact Information. From: Alexis de Talhouët <[email protected]> Date: Tuesday, August 14, 2018 at 11:21 AM To: onap-discuss <[email protected]>, "TIMONEY, DAN" <[email protected]> Subject: [SDNC][CDS] - Where to create Netbox SQL tables? Hello Dan, team, For the self serve implementation for vFW use case for Casablanca, we need to create two tables to store information related to the IPAM (prefixes and ips). See related information here: https://wiki.onap.org/pages/viewpage.action?pageId=36966186<https://urldefense.proofpoint.com/v2/url?u=https-3A__wiki.onap.org_pages_viewpage.action-3FpageId-3D36966186&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=Ms-DNhR23dO4sQFfYRm4ow&m=3UcTnA13D56pD8Rfx02GrTej30LB-67ETiMkSnxJElk&s=wRF2j48WHLCwvNdkNhkvQvs4iZo-c5XJRe3Nq8JTBxg&e=> under netbox mS Capability [ccsdk] -> netbox mS Capability [IPAM DB Creation SDN-C] With the aggregation to common controller going on we were wondering whether we should put this table in CCDSK or SDNC DB; can you advise us? Thanks, Alexis -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#11880): https://lists.onap.org/g/onap-discuss/message/11880 Mute This Topic: https://lists.onap.org/mt/24526012/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
