From: Michael Dürre Date: Tue, 1 Sep 2020 11:04:25 +0000 (+0200) Subject: fix odlsli image for new base image X-Git-Tag: 1.0.1~9^2 X-Git-Url: https://gerrit.onap.org/r/gitweb?p=ccsdk%2Fdistribution.git;a=commitdiff_plain;h=1a75e4824ab39c493f405d8791dc62999b273f94 fix odlsli image for new base image fix odlsli image and remove unused files Issue-ID: CCSDK-2717 Signed-off-by: Michael Dürre Change-Id: I7dac1412426d19663bd91ba5cf7f23d24da69b3f Signed-off-by: Michael Dürre --- diff --git a/odlsli/odlsli-alpine/src/main/docker/Dockerfile b/odlsli/odlsli-alpine/src/main/docker/Dockerfile index 892260d1..ea6f41f7 100644 --- a/odlsli/odlsli-alpine/src/main/docker/Dockerfile +++ b/odlsli/odlsli-alpine/src/main/docker/Dockerfile @@ -2,9 +2,6 @@ ## START OF STAGE0 ## FROM ${base.image.name}:${project.docker.latestfulltag.version} AS stage0 -ENV JAVA_HOME /usr/lib/jvm/java-1.8-openjdk -ENV ODL_HOME /opt/opendaylight - # copy the opendaylight credentials COPY idmlight.db.mv.db $ODL_HOME/data @@ -17,13 +14,10 @@ COPY opt /opt COPY org.ops4j.pax.logging.cfg $ODL_HOME/etc/org.ops4j.pax.logging.cfg ## END OF STAGE0 ## - FROM ${base.image.name}:${project.docker.latestfulltag.version} -MAINTAINER CCSDK Team (onap-ccsdk@lists.onap.org) +LABEL maintainer="CCSDK Team (onap-ccsdk@lists.onap.org)" -ENV JAVA_HOME /usr/lib/jvm/java-1.8-openjdk -ENV ODL_HOME /opt/opendaylight ENV SDNC_CONFIG_DIR /opt/onap/ccsdk/data/properties ENV CCSDKFEATUREVERSION ${ccsdk.features.version} ENV CCSDK_SLI_CORE_REPO mvn:org.onap.ccsdk.sli.core/ccsdk-sli-core-all/${ccsdk.sli.core.version}/xml/features @@ -56,4 +50,3 @@ RUN sed -i -e "\|featuresBoot[^a-zA-Z]|s|$|,${ODL_BOOT_FEATURES_EXTRA}|" $ODL_H USER odl ENTRYPOINT /opt/onap/ccsdk/bin/startODL.sh -EXPOSE 8181 diff --git a/odlsli/odlsli-alpine/src/main/properties/aaiclient.properties b/odlsli/odlsli-alpine/src/main/properties/aaiclient.properties deleted file mode 100755 index 4f27206f..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/aaiclient.properties +++ /dev/null @@ -1,82 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -# -# Configuration file for A&AI Client -# - -# -# Certificate keystore and truststore -# -org.onap.ccsdk.sli.adaptors.aai.ssl.trust=/opt/onap/ccsdk/data/stores/truststore.onap.client.jks -org.onap.ccsdk.sli.adaptors.aai.ssl.trust.psswd=adminadmin -org.onap.ccsdk.sli.adaptors.aai.host.certificate.ignore=true - -org.onap.ccsdk.sli.adaptors.aai.client.name=SDNC -org.onap.ccsdk.sli.adaptors.aai.client.psswd=SDNC - -org.onap.ccsdk.sli.adaptors.aai.application=openECOMP -# -# Configuration file for A&AI Client -# -org.onap.ccsdk.sli.adaptors.aai.uri=https://aai.api.simpledemo.onap.org:8443 -connection.timeout=60000 -read.timeout=60000 - -# query -org.onap.ccsdk.sli.adaptors.aai.path.query=/aai/v14/search/sdn-zone-query -org.onap.ccsdk.sli.adaptors.aai.query.nodes=/aai/v14/search/nodes-query?search-node-type={node-type}&filter={entity-identifier}:EQUALS:{entity-name} -org.onap.ccsdk.sli.adaptors.aai.query.generic=/aai/v14/search/generic-query?key={identifier}:{value}&start-node-type={start-node-type}&include=complex&depth=3 - -# named query -org.onap.ccsdk.sli.adaptors.aai.query.named=/aai/search/named-query - -#update -org.onap.ccsdk.sli.adaptors.aai.update=/aai/v14/actions/update - -# UBB Notify -org.onap.ccsdk.sli.adaptors.aai.path.notify=/aai/v14/actions/notify -org.onap.ccsdk.sli.adaptors.aai.notify.selflink.fqdn=<%= @ubbUri %>/restconf/config/L3SDN-API:services/layer3-service-list/{service-instance-id} -org.onap.ccsdk.sli.adaptors.aai.notify.selflink.avpn=<%= @ubbUri %>/restconf/config/L3AVPN-EVC-API:services/service-list/{service-instance-id}/service-data/avpn-logicalchannel-information - -# P-Interfaces -org.onap.ccsdk.sli.adaptors.aai.path.pserver.pinterfaces=/aai/v14/cloud-infrastructure/pservers/pserver/{hostname}/p-interfaces -org.onap.ccsdk.sli.adaptors.aai.path.pserver.pinterface=/aai/v14/cloud-infrastructure/pservers/pserver/{hostname}/p-interfaces/p-interface/{interface-name} - -# VNF IMAGES -org.onap.ccsdk.sli.adaptors.aai.path.vnf.images=/aai/v14/service-design-and-creation/vnf-images -org.onap.ccsdk.sli.adaptors.aai.path.vnf.image=/aai/v14/service-design-and-creation/vnf-images/vnf-image/{att-uuid} -org.onap.ccsdk.sli.adaptors.aai.path.vnf.image.query=/aai/v14/service-design-and-creation/vnf-images/vnf-image?application={application_model}&application-vendor={application_vendor} - -# service instance -org.onap.ccsdk.sli.adaptors.aai.path.svcinst.query=/aai/v14/search/generic-query?key=service-instance.service-instance-id:{svc-instance-id}&start-node-type=service-instance&include=service-instance -org.onap.ccsdk.sli.adaptors.aai.path.service.instance=/aai/v14/business/customers/customer/{global-customer-id}/service-subscriptions/service-subscription/{service-type}/service-instances/service-instance/{service-instance-id} - -# VNF IMAGES QUERY -org.onap.ccsdk.sli.adaptors.aai.path.vnf.image.query=/aai/v14/service-design-and-creation/vnf-images/vnf-image?application={application_model}&application-vendor={application_vendor} - -# -# Formatting -# -org.onap.ccsdk.sli.adaptors.aai.param.format=filter=%s:%s -org.onap.ccsdk.sli.adaptors.aai.param.vnf_type=vnf-type -org.onap.ccsdk.sli.adaptors.aai.param.physical.location.id=physical-location-id -org.onap.ccsdk.sli.adaptors.aai.param.service.type=service-type diff --git a/odlsli/odlsli-alpine/src/main/properties/admportal.json b/odlsli/odlsli-alpine/src/main/properties/admportal.json deleted file mode 100755 index 8d567d0c..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/admportal.json +++ /dev/null @@ -1,68 +0,0 @@ -{ - "MainMenu": "gamma", - "dbConnLimit": "100", - "home": "/opt/admportal", - "sslEnabled": "false", - "nonSslPort": "8843", - "ConexusNetworkPort": "8443", - "AppNetworkPort": "8543", - "clusterPort": "8443", - "serviceHomingServiceType": "SDN-ETHERNET-INTERNET", - "passwordKey": "QtfJMKggVk", - "preloadImportDirectory": "C:/data/csv", - "clusterPrefixURL": "/jolokia/read/org.opendaylight.controller:Category=Shards,name=member-", - "clusterMidURL": "-shard-", - "clusterSuffixURL": "-config,type=DistributedConfigDatastore", - "shards": [ - "default", - "inventory", - "topology" - ], - "dbFabric": "false", - "ip-addresses": { - "lo": "127.0.0.1", - "eth0": "127.0.0.1", - "docker0": "172.17.0.1", - "virbr0": "192.168.122.1" - }, - "svclogicPropertiesDb01": "/opt/onap/sdnc/data/properties/svclogic.properties.sdnctldb01", - "databases": [ - "dbhost|sdnctldb01" - ], - "dbFabricServer": "localhost", - "dbFabricPort": "32275", - "dbFabricGroupId": "hagroup1", - "dbFabricUser": "admin", - "dbFabricPassword": "admin", - "dbFabricDB": "mysql", - "dbUser": "sdnctl", - "dbPassword": "gamma", - "dbName": "sdnctl", - "odlProtocol": "http", - "odlHost": "sdnhost", - "odlConexusHost": "sdnhost", - "odlPort": "8181", - "odlConexusPort": "8181", - "odlUser": "admin", - "odlPasswd": "admin", - "ConexusNetwork_sslCert": "", - "ConexusNetwork_sslKey": "", - "AppNetwork_sslCert": "", - "AppNetwork_sslKey": "", - "hostnameList": [ - { - "hname": "localhost" - } - ], - "shard_list": [ - { - "shard_name": "default" - }, - { - "shard_name": "inventory" - }, - { - "shard_name": "topology" - } - ] -} diff --git a/odlsli/odlsli-alpine/src/main/properties/admportal.log4js.json b/odlsli/odlsli-alpine/src/main/properties/admportal.log4js.json deleted file mode 100755 index 0f41e564..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/admportal.log4js.json +++ /dev/null @@ -1,169 +0,0 @@ -{ - "appenders": [ - { - "category": "accesslog", - "type" : "file", - "absolute": true, - "filename": "/opt/admportal/logs/accesslog.log" - }, - { - "category" : "usertrace", - "type" : "file", - "absolute" : true, - "filename" : "/opt/admportal/logs/usertrace.log" - }, - { - "category": "tracelog", - "type" : "dateFile", - "absolute": true, - "filename": "/opt/admportal/logs/tracelog.log", - "pattern": "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "tunnel", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/tunnel.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "preload", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/preload.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "eipam", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/eipam.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "instar", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/instar.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "app", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/app.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "csp", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/csp.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "db", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/db.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "admin", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/admin.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "resalloc", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/resalloc.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "logs", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/applogs.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "sla", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/sla.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "gamma", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/gamma.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "odl", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/odl.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "mobility", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/mobility.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "ucpe", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/ucpe.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - }, - { - "category" : "user", - "type" : "dateFile", - "absolute" : true, - "filename" : "/opt/admportal/logs/user.log", - "pattern" : "-yyyy-MM-dd", - "alwaysIncludePattern": true, - "backups" : 14 - } - ] -} diff --git a/odlsli/odlsli-alpine/src/main/properties/dblib.properties b/odlsli/odlsli-alpine/src/main/properties/dblib.properties deleted file mode 100644 index 9506ac8d..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/dblib.properties +++ /dev/null @@ -1,38 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -# dblib.properrties -org.onap.ccsdk.sli.dbtype=jdbc - -org.onap.ccsdk.sli.jdbc.hosts=sdnctldb01 -org.onap.ccsdk.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl -org.onap.ccsdk.sli.jdbc.driver=org.mariadb.jdbc.Driver -org.onap.ccsdk.sli.jdbc.database=sdnctl -org.onap.ccsdk.sli.jdbc.user=sdnctl -org.onap.ccsdk.sli.jdbc.password=gamma -org.onap.ccsdk.sli.jdbc.connection.name=sdnctldb01 -org.onap.ccsdk.sli.jdbc.connection.timeout=50 -org.onap.ccsdk.sli.jdbc.request.timeout=100 -org.onap.ccsdk.sli.jdbc.limit.init=10 -org.onap.ccsdk.sli.jdbc.limit.min=10 -org.onap.ccsdk.sli.jdbc.limit.max=20 -org.onap.dblib.connection.recovery=false - diff --git a/odlsli/odlsli-alpine/src/main/properties/mdsal-resource.properties b/odlsli/odlsli-alpine/src/main/properties/mdsal-resource.properties deleted file mode 100644 index d8537471..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/mdsal-resource.properties +++ /dev/null @@ -1,27 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -org.onap.ccsdk.sli.adaptors.resource.mdsal.sdnc-user=admin -org.onap.ccsdk.sli.adaptors.resource.mdsal.sdnc-passwd=admin -org.onap.ccsdk.sli.adaptors.resource.mdsal.sdnc-host=localhost -org.onap.ccsdk.sli.adaptors.resource.mdsal.sdnc-protocol=http -org.onap.ccsdk.sli.adaptors.resource.mdsal.sdnc-port=8181 - diff --git a/odlsli/odlsli-alpine/src/main/properties/rpc-message-sliapi-execute.vt b/odlsli/odlsli-alpine/src/main/properties/rpc-message-sliapi-execute.vt deleted file mode 100644 index 1cdd65e9..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/rpc-message-sliapi-execute.vt +++ /dev/null @@ -1,8 +0,0 @@ -{ - "input": { - "module-name": "oofpcipoc-api", - "rpc-name": $rpc_name, - "mode": "sync", - "sli-parameter": $sli_parameters - } -} \ No newline at end of file diff --git a/odlsli/odlsli-alpine/src/main/properties/sdnr-CMNotify-api-dg.properties.properties b/odlsli/odlsli-alpine/src/main/properties/sdnr-CMNotify-api-dg.properties.properties deleted file mode 100644 index 8fa3735c..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/sdnr-CMNotify-api-dg.properties.properties +++ /dev/null @@ -1,36 +0,0 @@ -restapi.templateDir=/opt/onap/ccsdk/restapi/templates -controller.url=http://sdnc.onap:8282 -controller.user=admin -controller.pwd=Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U -ransim-mounted=false - -restapi.trustStoreFileName=/opt/onap/sdnc/data/stores/truststore.openecomp.client.jks -restapi.trustStorePassword=adminadmin -restapi.keyStoreFileName=/opt/onap/sdnc/data/stores/sdnc.p12 -restapi.keyStorePassword=adminadmin -restapi.connection-oof-url=http://oof.api.simpledemo.onap.org:8698/api/oof/v1/route -naming.gen-name.url=http://neng-serv:8080 -naming.gen-name.user=ccsdkapps -naming.gen-name.pwd=ccsdkapps - - -# Templates -restapi.pci-patch.templatefile=CMNotify-pci-patch.json -restapi.neighbor-add.templatefile=CMNotify-addNeighbor.json -restapi.neighbor-delete.templatefile=CMNotify-deleteNeighbor.json -restapi.generic-neighbor-patch.template=CMNotify-generic-neighbor-patch.json -restapi.add-nbr-to-configdb-per-notif.template=CMNotify-add-nbr-to-configdb-per-nbrlist-change-notif.json -restapi.dmaap-publish.template=CMNotify-dmaap-publish-template.json - -#URLs for ConfigDB -restapi.configdb.add-nbrlist-change-per-notif=/createNbr/{cellId} -configdb.url=http://10.12.6.45:8080/api/sdnc-config-db/v3 - -#DMAAP Publish -dmaap-message-router.url=message-router.onap:3904/events -CMNotify-dmaap.nbrlist-change.topic=/CM-NOTIFICATION-RSP - -CMNotify-dmaap.requestID=9d2d790e-a5f0-11e8-98d0-529269fb1459 -CMNotify-dmaap.aai= -CMNotify-dmaap.version=1.0.2 -CMNotify-dmaap.nbrlistchange.action=NeighborListModified diff --git a/odlsli/odlsli-alpine/src/main/properties/sdnr-oofpcipoc-api-dg.properties b/odlsli/odlsli-alpine/src/main/properties/sdnr-oofpcipoc-api-dg.properties deleted file mode 100644 index d80bb5ce..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/sdnr-oofpcipoc-api-dg.properties +++ /dev/null @@ -1,57 +0,0 @@ -restapi.templateDir=/opt/onap/ccsdk/restapi/templates -controller.url=http://sdnc.onap:8282 -controller.user=admin -controller.pwd=Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U -ransim-mounted=false - -restapi.trustStoreFileName=/opt/onap/sdnc/data/stores/truststore.openecomp.client.jks -restapi.trustStorePassword=adminadmin -restapi.keyStoreFileName=/opt/onap/sdnc/data/stores/sdnc.p12 -restapi.keyStorePassword=adminadmin -restapi.connection-oof-url=http://oof.api.simpledemo.onap.org:8698/api/oof/v1/route -naming.gen-name.url=http://neng-serv:8080 -naming.gen-name.user=ccsdkapps -naming.gen-name.pwd=ccsdkapps - - -#Patch Targets -oofpcipoc.patch.pci.target=/oofpcipoc:phy-cell-id-in-use -oofpcipoc.patch.pci.target2=/oofpcipoc:fap-service[oofpcipoc:alias='{alias}']/oofpcipoc:x-0005b9-lte - - -# Templates -restapi.pci-patch.templatefile=oofpcipoc-pci-patch.json -restapi.neighbor-add.templatefile=oofpcipoc-addNeighbor.json -restapi.neighbor-delete.templatefile=oofpcipoc-deleteNeighbor.json -restapi.generic-neighbor-patch.template=oofpcipoc-generic-neighbor-patch.json -restapi.add-nbr-to-configdb-per-notif.template=oofpcipoc-add-nbr-to-configdb-per-nbrlist-change-notif.json -restapi.dmaap-publish.template=oofpcipoc-dmaap-publish-template.json - -# URLs without Netconf Mount of Ran Simulator -restapi.config=/restconf/config -restapi.radio-access=/restconf/config/oofpcipoc:radio-access -restapi.fap-service=/restconf/config/oofpcipoc:radio-access/fap-service/{alias} -restapi.x-005b9-lte=/restconf/config/oofpcipoc:radio-access/fap-service/{alias}/x-0005b9-lte -restapi.lte-ran-neighbor-list-in-use=/restconf/config/oofpcipoc:radio-access/fap-service/{alias}/cell-config/lte/lte-ran/lte-ran-neighbor-list-in-use -restapi.lte-ran-neighbor-in-use=/restconf/config/oofpcipoc:radio-access/fap-service/{alias}/cell-config/lte/lte-ran/lte-ran-neighbor-list-in-use/lte-ran-neighbor-list-in-use-lte-cell/{plmnid}/{cid} - -# URLs with Netconf Mount of Ran Simulator -restapi.config.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/ -restapi.radio-access.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/oofpcipoc:radio-access -restapi.fap-service.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/oofpcipoc:radio-access/fap-service/{alias} -restapi.x-005b9-lte.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/oofpcipoc:radio-access/fap-service/{alias}/x-0005b9-lte -restapi.lte-ran-neighbor-list-in-use.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/oofpcipoc:radio-access/fap-service/{alias}/cell-config/lte/lte-ran/lte-ran-neighbor-list-in-use -restapi.lte-ran-neighbor-in-use.ransim-mounted=/restconf/config/network-topology:network-topology/topology/topology-netconf/node/{pnf-name}/yang-ext:mount/oofpcipoc:radio-access/fap-service/{alias}/cell-config/lte/lte-ran/lte-ran-neighbor-list-in-use/lte-ran-neighbor-list-in-use-lte-cell/{plmnid}/{cid} - -#URLs for ConfigDB -restapi.configdb.add-nbrlist-change-per-notif=/createNbr/{cellId} -configdb.url=http://10.12.6.45:8080/api/sdnc-config-db/v3 - -#DMAAP Publish -dmaap-message-router.url=message-router.onap:3904/events -oofpcipoc-dmaap.nbrlist-change.topic=/PCI-NOTIF-TOPIC-NGHBR-LIST-CHANGE-INFO - -oofpcipoc-dmaap.requestID=9d2d790e-a5f0-11e8-98d0-529269fb1459 -oofpcipoc-dmaap.aai= -oofpcipoc-dmaap.version=1.0.2 -oofpcipoc-dmaap.nbrlistchange.action=NeighborListModified diff --git a/odlsli/odlsli-alpine/src/main/properties/sql-resource.properties b/odlsli/odlsli-alpine/src/main/properties/sql-resource.properties deleted file mode 100644 index ac32f773..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/sql-resource.properties +++ /dev/null @@ -1,23 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -org.openecomp.sdnc.resource.sql.cryptkey=QtfJMKggVk - diff --git a/odlsli/odlsli-alpine/src/main/properties/svclogic.properties b/odlsli/odlsli-alpine/src/main/properties/svclogic.properties deleted file mode 100644 index 54d667cf..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/svclogic.properties +++ /dev/null @@ -1,29 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -org.onap.ccsdk.sli.dbtype = dblib -#Note : the next 4 fields are only used if org.onap.ccsdk.sli.dbtype = jdbc -org.onap.ccsdk.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl -org.onap.ccsdk.sli.jdbc.database=sdnctl -org.onap.ccsdk.sli.jdbc.user=sdnctl -org.onap.ccsdk.sli.jdbc.password=gamma - -org.xml.sax.driver=org.apache.xerces.parsers.SAXParser diff --git a/odlsli/odlsli-alpine/src/main/properties/svclogic.properties.sdnctldb01 b/odlsli/odlsli-alpine/src/main/properties/svclogic.properties.sdnctldb01 deleted file mode 100755 index 54d667cf..00000000 --- a/odlsli/odlsli-alpine/src/main/properties/svclogic.properties.sdnctldb01 +++ /dev/null @@ -1,29 +0,0 @@ -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -org.onap.ccsdk.sli.dbtype = dblib -#Note : the next 4 fields are only used if org.onap.ccsdk.sli.dbtype = jdbc -org.onap.ccsdk.sli.jdbc.url=jdbc:mysql://dbhost:3306/sdnctl -org.onap.ccsdk.sli.jdbc.database=sdnctl -org.onap.ccsdk.sli.jdbc.user=sdnctl -org.onap.ccsdk.sli.jdbc.password=gamma - -org.xml.sax.driver=org.apache.xerces.parsers.SAXParser diff --git a/odlsli/odlsli-alpine/src/main/resources/ansible-sources.list b/odlsli/odlsli-alpine/src/main/resources/ansible-sources.list deleted file mode 100644 index 7e166f23..00000000 --- a/odlsli/odlsli-alpine/src/main/resources/ansible-sources.list +++ /dev/null @@ -1,2 +0,0 @@ -deb http://ppa.launchpad.net/ansible/ansible/ubuntu xenial main -deb-src http://ppa.launchpad.net/ansible/ansible/ubuntu xenial main \ No newline at end of file diff --git a/odlsli/odlsli-alpine/src/main/resources/idmlight.db.mv.db b/odlsli/odlsli-alpine/src/main/resources/idmlight.db.mv.db deleted file mode 100644 index c6b359d8..00000000 Binary files a/odlsli/odlsli-alpine/src/main/resources/idmlight.db.mv.db and /dev/null differ diff --git a/odlsli/odlsli-alpine/src/main/resources/install_ccsdk.yml b/odlsli/odlsli-alpine/src/main/resources/install_ccsdk.yml deleted file mode 100644 index e09eceba..00000000 --- a/odlsli/odlsli-alpine/src/main/resources/install_ccsdk.yml +++ /dev/null @@ -1,16 +0,0 @@ ---- -- hosts: all - become: yes - roles: - - role: ansible-opendaylight - # ODL is already installed, so no need to specify installation method. Specify extra features to install - extra_features: - - odl-restconf-all - - odl-mdsal-all - - odl-mdsal-apidocs - - odl-daexim-all - - odl-restconf-nb-rfc8040 - - ccsdk-sli-core-all - - ccsdk-sli-adaptors-all - - ccsdk-sli-northbound-all - - ccsdk-sli-plugins-all \ No newline at end of file diff --git a/odlsli/odlsli-alpine/src/main/resources/odlsli.dump b/odlsli/odlsli-alpine/src/main/resources/odlsli.dump deleted file mode 100644 index 6f8217c4..00000000 --- a/odlsli/odlsli-alpine/src/main/resources/odlsli.dump +++ /dev/null @@ -1,1416 +0,0 @@ --- MySQL dump 10.13 Distrib 5.6.22, for Linux (x86_64) --- --- Host: sdnctldb01 Database: sdnctl --- ------------------------------------------------------ --- Server version 5.6.27-enterprise-commercial-advanced-log - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN; -SET @@SESSION.SQL_LOG_BIN= 0; - --- --- Table structure for table `ALLOCATION_ITEM` --- - -DROP TABLE IF EXISTS `ALLOCATION_ITEM`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `ALLOCATION_ITEM` ( - `allocation_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `resource_id` bigint(20) NOT NULL, - `application_id` varchar(50) NOT NULL, - `resource_set_id` varchar(200) NOT NULL, - `resource_union_id` varchar(200) NOT NULL, - `resource_share_group_list` varchar(200) DEFAULT NULL, - `lt_used` bigint(20) DEFAULT NULL, - `ll_label` varchar(50) DEFAULT NULL, - `rr_used` varchar(200) DEFAULT NULL, - `allocation_time` datetime NOT NULL, - PRIMARY KEY (`allocation_item_id`), - UNIQUE KEY `allocation_item_id` (`allocation_item_id`), - UNIQUE KEY `IX2_ALLOCATION_ITEM` (`resource_id`,`resource_set_id`), - KEY `IX1_ALLOCATION_ITEM` (`resource_id`) -) ENGINE=InnoDB AUTO_INCREMENT=10104 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - - --- --- Table structure for table `DATA_OBJECT_MAPPING` --- - -DROP TABLE IF EXISTS `DATA_OBJECT_MAPPING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `DATA_OBJECT_MAPPING` ( - `serial_key` int(11) NOT NULL AUTO_INCREMENT, - `data_object_key` varchar(100) NOT NULL, - `data_object_type` varchar(50) NOT NULL, - `service_type` varchar(50) NOT NULL, - `data_object_key2` varchar(100) NOT NULL, - `data_object_key2_type` varchar(50) NOT NULL, - PRIMARY KEY (`serial_key`), - KEY `IX1_DATA_OBJECT_MAPPING` (`data_object_key`,`data_object_type`,`service_type`), - KEY `IX2_DATA_OBJECT_MAPPING` (`service_type`,`data_object_key2`,`data_object_key2_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `DEVICE2CONNECTION_MAPPING` --- - -DROP TABLE IF EXISTS `DEVICE2CONNECTION_MAPPING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `DEVICE2CONNECTION_MAPPING` ( - `vnf_host_name` varchar(100) NOT NULL, - `e2e_vpn_key` varchar(30) NOT NULL, - `service_type` varchar(30) NOT NULL, - `connection_id` bigint(20) NOT NULL, - PRIMARY KEY (`vnf_host_name`,`e2e_vpn_key`,`service_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `DEVICE2IPADDRESS_CONSUMPTION` --- - -DROP TABLE IF EXISTS `DEVICE2IPADDRESS_CONSUMPTION`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `DEVICE2IPADDRESS_CONSUMPTION` ( - `serial_key` int(11) NOT NULL AUTO_INCREMENT, - `device_id` varchar(100) NOT NULL, - `device_type` varchar(30) NOT NULL, - `ip_version` varchar(10) NOT NULL, - `consumption_key` varchar(100) NOT NULL, - `logical_interface_service_id` varchar(100) NOT NULL, - `address_type` varchar(30) NOT NULL, - `ip_consumed` varchar(50) NOT NULL, - `vnf_type` varchar(30) NOT NULL, - PRIMARY KEY (`serial_key`), - KEY `IX1_DEVICEIPADDRESS_CONSUMPTION` (`device_id`,`device_type`,`ip_version`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `DEVICE2IPADDRESS_MAPPING` --- - -DROP TABLE IF EXISTS `DEVICE2IPADDRESS_MAPPING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `DEVICE2IPADDRESS_MAPPING` ( - `serial_key` int(11) NOT NULL AUTO_INCREMENT, - `device_id` varchar(100) NOT NULL, - `device_type` varchar(30) NOT NULL, - `secondary_key` varchar(100) NOT NULL, - `secondary_key_type` varchar(30) NOT NULL, - `address` varchar(50) NOT NULL, - `address_type` varchar(30) NOT NULL, - `ip_version` varchar(10) NOT NULL, - `length` int(11) NOT NULL, - `status` varchar(30) NOT NULL, - PRIMARY KEY (`serial_key`), - KEY `IX1_DEVICE2IPADDRESS_MAPPING` (`device_id`,`device_type`,`secondary_key`,`secondary_key_type`,`address`,`address_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `EIPAM_IP_ASSIGNMENTS` --- - -DROP TABLE IF EXISTS `EIPAM_IP_ASSIGNMENTS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `EIPAM_IP_ASSIGNMENTS` ( - `plan_name` varchar(40) NOT NULL, - `client_key` varchar(100) NOT NULL, - `service_type` varchar(40) NOT NULL, - `ip_address` varchar(40) DEFAULT NULL, - `prefix_length` int(2) DEFAULT NULL, - `status` varchar(20) DEFAULT NULL, - `service_instance_id` varchar(80) DEFAULT NULL, - `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `prev_status` varchar(20) DEFAULT NULL, - PRIMARY KEY (`plan_name`,`client_key`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `EIPAM_IP_SUBNETS` --- - -DROP TABLE IF EXISTS `EIPAM_IP_SUBNETS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `EIPAM_IP_SUBNETS` ( - `entity_id` int(6) NOT NULL, - `service_type` varchar(40) NOT NULL, - `plan_name` varchar(40) NOT NULL, - `address_family` varchar(10) NOT NULL, - `ip_address` varchar(40) NOT NULL, - `prefix_length` int(3) NOT NULL, - `status` varchar(20) NOT NULL, - `last_modified_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`entity_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `EIPAM_IP_SUBNET_KEYS` --- - -DROP TABLE IF EXISTS `EIPAM_IP_SUBNET_KEYS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `EIPAM_IP_SUBNET_KEYS` ( - `entity_id` int(6) NOT NULL, - `key_name` varchar(255) NOT NULL, - `key_value` varchar(50) NOT NULL, - `level` int(2) NOT NULL, - PRIMARY KEY (`entity_id`,`key_name`,`key_value`,`level`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `EIPAM_REQUEST_KEY` --- - -DROP TABLE IF EXISTS `EIPAM_REQUEST_KEY`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `EIPAM_REQUEST_KEY` ( - `key_name_1` varchar(50) NOT NULL, - `address_family` varchar(4) NOT NULL, - `serial_key` int(2) NOT NULL AUTO_INCREMENT, - `plan_name` varchar(50) NOT NULL, - `request_length` int(2) NOT NULL, - `pools_length` int(2) NOT NULL, - `plan_length` int(2) NOT NULL, - `key_name_0` varchar(50) NOT NULL, - `key_name_type_0` varchar(255) NOT NULL, - `key_name_type_1` varchar(255) NOT NULL, - `prefix_length` int(2) NOT NULL, - `group_flag` char(1) NOT NULL, - `address_type` varchar(20) DEFAULT NULL, - PRIMARY KEY (`key_name_1`,`address_family`), - UNIQUE KEY `IX1_EIPAM_REQUEST_KEY` (`serial_key`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_L3_NETWORK` --- - -DROP TABLE IF EXISTS `GENERIC_L3_NETWORK`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_L3_NETWORK` ( - `network_id` varchar(80) NOT NULL, - `network_name` varchar(80) DEFAULT NULL, - `network_type` varchar(80) DEFAULT NULL, - `network_role` varchar(80) DEFAULT NULL, - `network_technology` varchar(80) DEFAULT NULL, - `neutron_network_id` varchar(80) DEFAULT NULL, - `is_bound_to_vpn` tinyint(1) DEFAULT NULL, - `orchestration_status` varchar(20) DEFAULT NULL, - `heat_stack_id` varchar(80) DEFAULT NULL, - `mso_catalog_key` varchar(80) DEFAULT NULL, - `service_id` varchar(80) NOT NULL, - `tenant_id` varchar(80) NOT NULL, - `physical_location_id` varchar(20) DEFAULT NULL, - `network_role_instance` varchar(80) NOT NULL, - PRIMARY KEY (`network_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_L3_NETWORK_SUBNET` --- - -DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_SUBNET`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_L3_NETWORK_SUBNET` ( - `network_id` varchar(80) NOT NULL, - `subnet_id` varchar(80) NOT NULL, - `neutron_subnet_id` varchar(80) DEFAULT NULL, - `gateway_address` varchar(45) NOT NULL, - `network_start_address` varchar(45) NOT NULL, - `cidr_mask` varchar(20) NOT NULL, - `ip_version` char(1) NOT NULL, - `orchestration_status` varchar(64) NOT NULL, - `dhcp_enabled` tinyint(1) NOT NULL, - `dhcp_start` varchar(45) DEFAULT NULL, - `dhcp_end` varchar(45) DEFAULT NULL, - PRIMARY KEY (`network_id`,`subnet_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_L3_NETWORK_VPN_BINDING` --- - -DROP TABLE IF EXISTS `GENERIC_L3_NETWORK_VPN_BINDING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_L3_NETWORK_VPN_BINDING` ( - `network_id` varchar(80) NOT NULL, - `vpn_id` varchar(80) NOT NULL, - PRIMARY KEY (`network_id`,`vpn_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF` --- - -DROP TABLE IF EXISTS `GENERIC_VNF`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF` ( - `vnf_id` varchar(80) NOT NULL, - `vnf_name` varchar(80) NOT NULL, - `vnf_type` varchar(200) NOT NULL, - `vnf_name2` varchar(80) DEFAULT NULL, - `service_id` varchar(80) NOT NULL, - `equipment_role` varchar(80) NOT NULL, - `orchestration_status` varchar(20) DEFAULT NULL, - `prov_status` varchar(20) DEFAULT NULL, - `heat_stack_id` varchar(80) DEFAULT NULL, - `mso_catalog_key` varchar(80) DEFAULT NULL, - `regional_resource_zone` varchar(80) DEFAULT NULL, - `operational_state` varchar(80) DEFAULT NULL, - `license_key` varchar(80) DEFAULT NULL, - `ipv4_oam_address` varchar(20) DEFAULT NULL, - `ipv4_loopback0_address` varchar(20) DEFAULT NULL, - `nm_lan_v6_address` varchar(40) DEFAULT NULL, - `management_v6_address` varchar(40) DEFAULT NULL, - `management_option` varchar(45) DEFAULT NULL, - `vcpu` varchar(45) DEFAULT NULL, - `vmemory` varchar(45) DEFAULT NULL, - `vdisk` varchar(45) DEFAULT NULL, - `vcpu_units` varchar(45) DEFAULT NULL, - `vmemory_units` varchar(45) DEFAULT NULL, - `vdisk_units` varchar(45) DEFAULT NULL, - PRIMARY KEY (`vnf_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_L3_NETWORK` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_L3_NETWORK`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_L3_NETWORK` ( - `vnf_id` varchar(80) NOT NULL, - `network_id` varchar(80) NOT NULL, - PRIMARY KEY (`vnf_id`,`network_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_LICENSE_MANAGEMENT` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_LICENSE_MANAGEMENT`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_LICENSE_MANAGEMENT` ( - `vnf_id` varchar(80) NOT NULL, - `att_uuid` varchar(80) NOT NULL, - PRIMARY KEY (`vnf_id`,`att_uuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_LINTERFACE` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_LINTERFACE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_LINTERFACE` ( - `vnf_id` varchar(80) NOT NULL, - `interface_name` varchar(255) NOT NULL, - `interface_role` varchar(45) DEFAULT NULL, - `v6_wan_link_ip` varchar(45) DEFAULT NULL, - `selflink` varchar(128) DEFAULT NULL, - `interface_id` varchar(45) DEFAULT NULL, - `macaddr` varchar(64) DEFAULT NULL, - `network_name` varchar(255) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`interface_name`), - KEY `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF_IDX` (`vnf_id`), - CONSTRAINT `FK_GENERIC_VNF_LINTERFACE_GENERIC_VNF` FOREIGN KEY (`vnf_id`) REFERENCES `GENERIC_VNF` (`vnf_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_PSERVER` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_PSERVER`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_PSERVER` ( - `vnf_id` varchar(64) NOT NULL, - `hostname` varchar(255) NOT NULL, - PRIMARY KEY (`vnf_id`,`hostname`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_SERVICE_INSTANCE` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_SERVICE_INSTANCE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_SERVICE_INSTANCE` ( - `vnf_id` varchar(64) NOT NULL, - `service_instance_id` varchar(255) NOT NULL, - `relationship_key` varchar(64) NOT NULL, - `relationship_value` varchar(64) DEFAULT NULL, - `global_customer_id` varchar(255) DEFAULT NULL, - `service_type` varchar(255) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`service_instance_id`,`relationship_key`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_VNF_IMAGE` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_VNF_IMAGE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_VNF_IMAGE` ( - `vnf_id` varchar(64) NOT NULL, - `att_uuid` varchar(255) NOT NULL, - PRIMARY KEY (`vnf_id`,`att_uuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VNF_VSERVER` --- - -DROP TABLE IF EXISTS `GENERIC_VNF_VSERVER`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VNF_VSERVER` ( - `vnf_id` varchar(80) NOT NULL, - `vserver_id` varchar(128) NOT NULL, - `tenant_id` varchar(128) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`vserver_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `GENERIC_VPN_BINDING` --- - -DROP TABLE IF EXISTS `GENERIC_VPN_BINDING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `GENERIC_VPN_BINDING` ( - `vpn_id` varchar(80) NOT NULL, - `vpn_name` varchar(80) NOT NULL, - `global_route_target` varchar(80) NOT NULL, - PRIMARY KEY (`vpn_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `HOSTNAME` --- - -DROP TABLE IF EXISTS `HOSTNAME`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `HOSTNAME` ( - `hostname` varchar(21) NOT NULL, - `parent_hostname` varchar(21) DEFAULT NULL, - `cust_id` int(11) NOT NULL, - `loc_id` int(11) NOT NULL, - `site_sequence` varchar(2) NOT NULL, - `server_sequence` varchar(2) NOT NULL, - `activation_code` varchar(11) DEFAULT NULL, - `vnf_sequence` varchar(2) DEFAULT NULL, - `vendor_code` varchar(1) NOT NULL, - `virtual_device_type` varchar(2) DEFAULT NULL, - `device_sequence` varchar(3) DEFAULT NULL, - `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (`hostname`), - KEY `IN1_HOSTNAME` (`cust_id`), - KEY `IN2_HOSTNAME` (`loc_id`), - KEY `IN3_HOSTNAME` (`vendor_code`), - KEY `IN4_HOSTNAME` (`parent_hostname`), - CONSTRAINT `FK1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT `FK2_HOSTNAME` FOREIGN KEY (`loc_id`) REFERENCES `LOCATION` (`loc_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT `FK3_HOSTNAME` FOREIGN KEY (`vendor_code`) REFERENCES `VENDOR_CODE` (`vendor_code`) ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT `FK4_HOSTNAME` FOREIGN KEY (`parent_hostname`) REFERENCES `HOSTNAME` (`hostname`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `IPV4_ADDRESS_POOL` --- - -DROP TABLE IF EXISTS `IPV4_ADDRESS_POOL`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `IPV4_ADDRESS_POOL` ( - `aic_site_id` varchar(100) NOT NULL, - `universe` varchar(40) NOT NULL, - `status` varchar(40) NOT NULL, - `ipv4_addr` varchar(20) NOT NULL, - PRIMARY KEY (`ipv4_addr`,`universe`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `LINTERFACE_VLAN` --- - -DROP TABLE IF EXISTS `LINTERFACE_VLAN`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `LINTERFACE_VLAN` ( - `vnf_id` varchar(80) NOT NULL, - `interface_name` varchar(255) NOT NULL, - `vlan_interface` varchar(255) NOT NULL, - `vlan_id_inner` varchar(64) DEFAULT NULL, - `vlan_id_outer` varchar(64) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`), - KEY `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE_IDX` (`vnf_id`,`interface_name`), - CONSTRAINT `FK_LINTERFACE_VLAN_GENERIC_VNF_LINTERFACE` FOREIGN KEY (`vnf_id`, `interface_name`) REFERENCES `GENERIC_VNF_LINTERFACE` (`vnf_id`, `interface_name`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `LOCATION` --- - -DROP TABLE IF EXISTS `LOCATION`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `LOCATION` ( - `loc_id` int(11) NOT NULL AUTO_INCREMENT, - `address` varchar(150) NOT NULL, - `city_code_id` int(11) NOT NULL, - `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, - PRIMARY KEY (`loc_id`), - KEY `IN1_LOCATION_IDX` (`city_code_id`), - CONSTRAINT `FK1_LOCATION` FOREIGN KEY (`city_code_id`) REFERENCES `CITY_CODE` (`city_code_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `MAX_PORT_SPEED` --- - -DROP TABLE IF EXISTS `MAX_PORT_SPEED`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `MAX_PORT_SPEED` ( - `max_port_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `image_file_name` varchar(50) NOT NULL, - `end_point_position` varchar(50) NOT NULL, - `interface_name` varchar(100) NOT NULL, - `max_speed` bigint(20) NOT NULL, - `unit` varchar(10) NOT NULL, - PRIMARY KEY (`max_port_speed_id`), - UNIQUE KEY `max_port_speed_id` (`max_port_speed_id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `MAX_SERVER_SPEED` --- - -DROP TABLE IF EXISTS `MAX_SERVER_SPEED`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `MAX_SERVER_SPEED` ( - `max_server_speed_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `server_model` varchar(50) NOT NULL, - `evc_count` smallint(6) NOT NULL, - `max_speed` bigint(20) NOT NULL, - `unit` varchar(10) NOT NULL, - `description` varchar(500) DEFAULT NULL, - PRIMARY KEY (`max_server_speed_id`), - UNIQUE KEY `max_server_speed_id` (`max_server_speed_id`) -) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - - - --- --- Table structure for table `NETWORK_PROFILE` --- - -DROP TABLE IF EXISTS `NETWORK_PROFILE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `NETWORK_PROFILE` ( - `network_type` varchar(100) NOT NULL, - `technology` varchar(100) NOT NULL, - PRIMARY KEY (`network_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `NETWORK_ROLE_VPN_BINDING` --- - -DROP TABLE IF EXISTS `NETWORK_ROLE_VPN_BINDING`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `NETWORK_ROLE_VPN_BINDING` ( - `network_role` varchar(80) NOT NULL, - `vpn_id` varchar(80) NOT NULL, - PRIMARY KEY (`network_role`,`vpn_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `NODE_TYPES` --- - -DROP TABLE IF EXISTS `NODE_TYPES`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `NODE_TYPES` ( - `nodetype` varchar(80) NOT NULL, - PRIMARY KEY (`nodetype`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `PARAMETERS` --- - -DROP TABLE IF EXISTS `PARAMETERS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PARAMETERS` ( - `name` varchar(100) NOT NULL, - `value` varchar(24) NOT NULL, - `category` varchar(24) DEFAULT NULL, - `memo` varchar(128) DEFAULT NULL, - PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `PHYSICAL_LINK` --- - -DROP TABLE IF EXISTS `PHYSICAL_LINK`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PHYSICAL_LINK` ( - `link_name` varchar(255) NOT NULL, - `speed_value` varchar(64) DEFAULT NULL, - `speed_units` varchar(64) DEFAULT NULL, - `circuit_id` varchar(255) NOT NULL, - `dual_mode` varchar(64) NOT NULL, - PRIMARY KEY (`link_name`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `PHYSICAL_LINK_PINTERFACE` --- - -DROP TABLE IF EXISTS `PHYSICAL_LINK_PINTERFACE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PHYSICAL_LINK_PINTERFACE` ( - `link_name` varchar(255) NOT NULL, - `hostname` varchar(255) NOT NULL, - `port_name_ft` varchar(255) NOT NULL, - PRIMARY KEY (`link_name`,`hostname`,`port_name_ft`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `PINTERFACE` --- - -DROP TABLE IF EXISTS `PINTERFACE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PINTERFACE` ( - `hostname` varchar(255) NOT NULL, - `port_name_ft` varchar(255) NOT NULL, - `interface_name` varchar(255) DEFAULT '', - `physical_speed` varchar(255) DEFAULT '', - `physical_units` varchar(255) DEFAULT '', - `port_description` varchar(255) DEFAULT '', - PRIMARY KEY (`hostname`,`port_name_ft`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `PORTAL_USERS` --- - -DROP TABLE IF EXISTS `PORTAL_USERS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PORTAL_USERS` ( - `email` varchar(64) NOT NULL, - `password` varbinary(255) NOT NULL, - `privilege` char(1) NOT NULL, - PRIMARY KEY (`email`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - - --- --- Table structure for table `PSERVER` --- - -DROP TABLE IF EXISTS `PSERVER`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `PSERVER` ( - `hostname` varchar(255) NOT NULL, - `ptnii_equip_name` varchar(255) DEFAULT '', - `number_of_cpus` varchar(255) DEFAULT '', - `disk_in_gigabytes` varchar(255) DEFAULT '', - `ram_in_megabytes` varchar(255) DEFAULT '', - `equip_type` varchar(255) DEFAULT '', - `equip_vendor` varchar(255) DEFAULT '', - `equip_model` varchar(255) DEFAULT '', - `fqdn` varchar(255) DEFAULT '', - `pserver_selflink` varchar(255) DEFAULT '', - `ipv4_oam_address` varchar(40) DEFAULT NULL, - `serial_number` varchar(255) DEFAULT '', - `pserver_id` varchar(255) DEFAULT '', - `internet_topology` varchar(40) DEFAULT '', - `aic_site_id` varchar(100) DEFAULT '', - `in_maint` varchar(5) DEFAULT '', - `pserver_name2` varchar(255) DEFAULT '', - `purpose` varchar(255) DEFAULT '', - PRIMARY KEY (`hostname`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RANGE_RULE` --- - -DROP TABLE IF EXISTS `RANGE_RULE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RANGE_RULE` ( - `range_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `range_name` varchar(50) NOT NULL, - `service_model` varchar(50) NOT NULL, - `end_point_position` varchar(50) NOT NULL, - `equipment_level` varchar(50) NOT NULL, - `equipment_expression` varchar(2000) NOT NULL, - `ranges` varchar(100) NOT NULL, - PRIMARY KEY (`range_rule_id`) -) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RESOURCE` --- - -DROP TABLE IF EXISTS `RESOURCE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RESOURCE` ( - `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `asset_id` varchar(100) NOT NULL, - `resource_name` varchar(50) NOT NULL, - `resource_type` enum('Limit','Label','Range') NOT NULL, - `lt_used` bigint(20) DEFAULT NULL, - `ll_label` varchar(50) DEFAULT NULL, - `ll_reference_count` smallint(6) DEFAULT NULL, - `rr_used` varchar(4000) DEFAULT NULL, - PRIMARY KEY (`resource_id`), - UNIQUE KEY `resource_id` (`resource_id`), - UNIQUE KEY `IX1_RESOURCE` (`asset_id`,`resource_name`) -) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RESOURCE_LOAD` --- - -DROP TABLE IF EXISTS `RESOURCE_LOAD`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RESOURCE_LOAD` ( - `resource_load_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `resource_id` bigint(20) NOT NULL, - `application_id` varchar(20) NOT NULL, - `resource_load_time` datetime NOT NULL, - `resource_expiration_time` datetime DEFAULT NULL, - PRIMARY KEY (`resource_load_id`), - UNIQUE KEY `resource_load_id` (`resource_load_id`), - UNIQUE KEY `IX2_RESOURCE_LOAD` (`resource_id`,`application_id`), - KEY `IX1_RESOURCE_LOAD` (`resource_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RESOURCE_LOCK` --- - -DROP TABLE IF EXISTS `RESOURCE_LOCK`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RESOURCE_LOCK` ( - `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `resource_name` varchar(50) NOT NULL, - `lock_holder` varchar(100) NOT NULL, - `lock_count` smallint(6) NOT NULL, - `lock_time` datetime NOT NULL, - `expiration_time` datetime NOT NULL, - PRIMARY KEY (`resource_lock_id`), - UNIQUE KEY `resource_lock_id` (`resource_lock_id`), - UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`) -) ENGINE=InnoDB AUTO_INCREMENT=2951 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RESOURCE_RULE` --- - -DROP TABLE IF EXISTS `RESOURCE_RULE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RESOURCE_RULE` ( - `resource_rule_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `resource_name` varchar(50) NOT NULL, - `service_model` varchar(50) NOT NULL, - `end_point_position` varchar(50) NOT NULL, - `service_expression` varchar(2000) NOT NULL, - `equipment_level` varchar(50) NOT NULL, - `equipment_expression` varchar(2000) NOT NULL, - `allocation_expression` varchar(2000) NOT NULL, - `soft_limit_expression` varchar(2000) NOT NULL, - `hard_limit_expression` varchar(2000) NOT NULL, - PRIMARY KEY (`resource_rule_id`), - UNIQUE KEY `resource_rule_id` (`resource_rule_id`) -) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `RESOURCE_THRESHOLD` --- - -DROP TABLE IF EXISTS `RESOURCE_THRESHOLD`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `RESOURCE_THRESHOLD` ( - `resource_threshold_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `resource_rule_id` bigint(20) NOT NULL, - `threshold_expression` varchar(2000) NOT NULL, - `threshold_message` varchar(2000) NOT NULL, - PRIMARY KEY (`resource_threshold_id`) -) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - - --- --- Table structure for table `SERVICE_RESOURCE` --- - -DROP TABLE IF EXISTS `SERVICE_RESOURCE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `SERVICE_RESOURCE` ( - `service_resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `service_instance_id` varchar(80) NOT NULL, - `service_status` enum('Active','Pending') NOT NULL, - `service_change_number` smallint(6) NOT NULL, - `resource_set_id` varchar(100) NOT NULL, - `resource_union_id` varchar(100) NOT NULL, - PRIMARY KEY (`service_instance_id`,`service_change_number`), - UNIQUE KEY `service_resource_id` (`service_resource_id`), - KEY `IX1_SERVICE_RESOURCE` (`service_instance_id`) -) ENGINE=InnoDB AUTO_INCREMENT=2203 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `SVC_LOGIC` --- - -DROP TABLE IF EXISTS `SVC_LOGIC`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `SVC_LOGIC` ( - `module` varchar(80) NOT NULL, - `rpc` varchar(80) NOT NULL, - `version` varchar(40) NOT NULL, - `mode` varchar(5) NOT NULL, - `active` varchar(1) NOT NULL, - `graph` longblob, - PRIMARY KEY (`module`,`rpc`,`version`,`mode`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `TENANT` --- - -DROP TABLE IF EXISTS `TENANT`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `TENANT` ( - `tenant_id` varchar(255) NOT NULL, - `tenant_name` varchar(255) NOT NULL, - `service_instance_id` varchar(255) NOT NULL, - PRIMARY KEY (`tenant_id`,`tenant_name`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `THRESHOLD_NOTIFICATION` --- - -DROP TABLE IF EXISTS `THRESHOLD_NOTIFICATION`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `THRESHOLD_NOTIFICATION` ( - `resource_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `threshold_expression` varchar(2000) DEFAULT NULL, - `threshold_message` varchar(500) DEFAULT NULL, - PRIMARY KEY (`resource_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - - --- --- Table structure for table `VENDOR_CODE` --- - -DROP TABLE IF EXISTS `VENDOR_CODE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VENDOR_CODE` ( - `vendor_code` varchar(1) NOT NULL, - `vendor` varchar(45) DEFAULT NULL, - PRIMARY KEY (`vendor_code`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_ID_POOL` --- - -DROP TABLE IF EXISTS `VLAN_ID_POOL`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_ID_POOL` ( - `aic_site_id` varchar(100) NOT NULL, - `purpose` varchar(40) NOT NULL, - `status` varchar(40) NOT NULL, - `vlan_id` int(4) NOT NULL, - `svc_instance_id` varchar(80) DEFAULT NULL, - `availability_zone` varchar(100) DEFAULT NULL, - `vplspe_name` varchar(80) DEFAULT NULL, - PRIMARY KEY (`vlan_id`,`aic_site_id`,`purpose`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_L3INTERFACE_IPV4_ADDRESS` --- - -DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV4_ADDRESS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_L3INTERFACE_IPV4_ADDRESS` ( - `vnf_id` varchar(80) NOT NULL, - `interface_name` varchar(255) NOT NULL, - `vlan_interface` varchar(255) NOT NULL, - `l3_interface_ipv4_address` varchar(64) NOT NULL, - `l3_interface_ipv4_prefix_length` varchar(45) DEFAULT NULL, - `vlan_id_inner` varchar(45) DEFAULT NULL, - `vlan_id_outer` varchar(45) DEFAULT NULL, - `is_floating` varchar(1) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv4_address`), - KEY `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`), - CONSTRAINT `FK_VLAN_L3INTERFACE_IPV4_ADDRESS_LINTERFACE_VLAN` FOREIGN KEY (`vnf_id`, `interface_name`, `vlan_interface`) REFERENCES `LINTERFACE_VLAN` (`vnf_id`, `interface_name`, `vlan_interface`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_L3INTERFACE_IPV6_ADDRESS` --- - -DROP TABLE IF EXISTS `VLAN_L3INTERFACE_IPV6_ADDRESS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_L3INTERFACE_IPV6_ADDRESS` ( - `vnf_id` varchar(80) NOT NULL, - `interface_name` varchar(255) NOT NULL, - `vlan_interface` varchar(255) NOT NULL, - `l3_interface_ipv6_address` varchar(64) NOT NULL, - `l3_interface_ipv6_prefix_length` varchar(45) DEFAULT NULL, - `vlan_id_inner` varchar(45) DEFAULT NULL, - `vlan_id_outer` varchar(45) DEFAULT NULL, - `is_floating` varchar(1) DEFAULT NULL, - PRIMARY KEY (`vnf_id`,`interface_name`,`vlan_interface`,`l3_interface_ipv6_address`), - KEY `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN_IDX` (`vnf_id`,`interface_name`,`vlan_interface`), - CONSTRAINT `FK_VLAN_L3INTERFACE_IPV6_ADDRESS_LINTERFACE_VLAN` FOREIGN KEY (`vnf_id`, `interface_name`, `vlan_interface`) REFERENCES `LINTERFACE_VLAN` (`vnf_id`, `interface_name`, `vlan_interface`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_PLAN_ID` --- - -DROP TABLE IF EXISTS `VLAN_PLAN_ID`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_PLAN_ID` ( - `plan_type` varchar(40) NOT NULL, - `purpose` varchar(40) NOT NULL, - `vlan_plan_id_count` int(4) NOT NULL, - PRIMARY KEY (`vlan_plan_id_count`,`plan_type`,`purpose`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_POOL` --- - -DROP TABLE IF EXISTS `VLAN_POOL`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_POOL` ( - `aic_site_id` varchar(100) NOT NULL, - `availability_zone` varchar(100) NOT NULL, - `vlan_plan_id` varchar(100) NOT NULL, - `plan_type` varchar(40) NOT NULL, - `purpose` varchar(40) NOT NULL, - `vlan_id` int(4) NOT NULL, - `status` varchar(40) NOT NULL, - `reserved_id` varchar(80) DEFAULT NULL, - PRIMARY KEY (`aic_site_id`,`availability_zone`,`vlan_plan_id`,`plan_type`,`purpose`,`vlan_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VLAN_RANGES` --- - -DROP TABLE IF EXISTS `VLAN_RANGES`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VLAN_RANGES` ( - `vlan_plan_id` varchar(100) NOT NULL, - `plan_type` varchar(40) NOT NULL, - `purpose` varchar(40) NOT NULL, - `range_start` int(4) NOT NULL, - `range_end` int(4) NOT NULL, - `generated` char(1) DEFAULT NULL, - PRIMARY KEY (`vlan_plan_id`,`plan_type`,`purpose`,`range_start`,`range_end`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VM_NETWORKS` --- - -DROP TABLE IF EXISTS `VM_NETWORKS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VM_NETWORKS` ( - `vnf_type` varchar(200) NOT NULL, - `vm_type` varchar(45) NOT NULL, - `network_role` varchar(45) NOT NULL, - `assign_ips` tinyint(1) NOT NULL, - `assign_macs` tinyint(1) NOT NULL, - `assign_floating_ip` tinyint(1) NOT NULL, - `ip_count` int(11) DEFAULT NULL, - PRIMARY KEY (`vnf_type`,`vm_type`,`network_role`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VM_PROFILE` --- - -DROP TABLE IF EXISTS `VM_PROFILE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VM_PROFILE` ( - `vnf_type` varchar(200) NOT NULL, - `vm_type` varchar(45) NOT NULL, - `vm_count` int(11) NOT NULL, - PRIMARY KEY (`vnf_type`,`vm_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF` --- - -DROP TABLE IF EXISTS `VNF`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF` ( - `vnf_id` varchar(80) NOT NULL, - `vnf_name` varchar(80) NOT NULL, - `vnf_type` varchar(10) NOT NULL, - `orchestration_status` varchar(20) DEFAULT NULL, - `heat_stack_id` varchar(80) DEFAULT NULL, - `mso_catalog_key` varchar(80) DEFAULT NULL, - `availability_zone` varchar(80) DEFAULT NULL, - `aic_site_id` varchar(80) DEFAULT NULL, - `oam_ipv4_address` varchar(20) DEFAULT NULL, - `vnf_name2` varchar(80) DEFAULT NULL, - `vpe_id` varchar(80) NOT NULL, - `ipv4_loopback0_address` varchar(80) DEFAULT NULL, - `license_key` varchar(256) DEFAULT NULL, - `entitlement_resource_uuid` varchar(256) DEFAULT NULL, - PRIMARY KEY (`vnf_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_IMAGE` --- - -DROP TABLE IF EXISTS `VNF_IMAGE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_IMAGE` ( - `application_vendor` varchar(255) NOT NULL, - `application_version` varchar(255) NOT NULL, - `att_uuid` varchar(255) NOT NULL, - `application` varchar(255) DEFAULT NULL, - `selflink` varchar(255) DEFAULT NULL, - PRIMARY KEY (`application_vendor`,`application_version`,`att_uuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_MODEL_LICENSES` --- - -DROP TABLE IF EXISTS `VNF_MODEL_LICENSES`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_MODEL_LICENSES` ( - `att_part_number` varchar(255) NOT NULL, - `license_assignment_group` varchar(255) NOT NULL, - `license_required` tinyint(1) DEFAULT NULL, - `entitlement_assignment_group` varchar(255) DEFAULT NULL, - `entitlement_required` tinyint(1) DEFAULT NULL, - `feature_group_uuid` varchar(255) DEFAULT NULL, - PRIMARY KEY (`att_part_number`,`license_assignment_group`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_MODEL_LICENSE_FEATURES` --- - -DROP TABLE IF EXISTS `VNF_MODEL_LICENSE_FEATURES`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_MODEL_LICENSE_FEATURES` ( - `att_part_number` varchar(255) NOT NULL, - `license_assignment_group` varchar(255) NOT NULL, - `feature` varchar(255) NOT NULL, - PRIMARY KEY (`att_part_number`,`license_assignment_group`,`feature`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_NETWORKS` --- - -DROP TABLE IF EXISTS `VNF_NETWORKS`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_NETWORKS` ( - `vnf_type` varchar(200) NOT NULL, - `network_role` varchar(45) NOT NULL, - PRIMARY KEY (`vnf_type`,`network_role`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_NETWORK_CONNECTION` --- - -DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_NETWORK_CONNECTION` ( - `connection_uuid` varchar(80) NOT NULL, - `vnf_id` varchar(80) NOT NULL, - `connection_id` varchar(80) DEFAULT NULL, - `connection_type` varchar(20) DEFAULT NULL, - `neutron_network_id` varchar(80) DEFAULT NULL, - `neutron_network_name` varchar(80) DEFAULT NULL, - `orchestration_status` varchar(20) DEFAULT NULL, - `switch_id` varchar(40) DEFAULT NULL, - `heat_stack_id` varchar(80) DEFAULT NULL, - `mso_catalog_key` varchar(80) DEFAULT NULL, - `provider_network` varchar(80) DEFAULT NULL, - `port_group_id` varchar(80) DEFAULT NULL, - `port_group_name` varchar(80) DEFAULT NULL, - PRIMARY KEY (`connection_uuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_NETWORK_CONNECTION_VLAN` --- - -DROP TABLE IF EXISTS `VNF_NETWORK_CONNECTION_VLAN`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_NETWORK_CONNECTION_VLAN` ( - `vlan_uuid` varchar(80) NOT NULL, - `vlan_id` int(4) NOT NULL, - `vlan_type` varchar(5) NOT NULL, - `connection_uuid` varchar(80) DEFAULT NULL, - PRIMARY KEY (`vlan_uuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VNF_PROFILE` --- - -DROP TABLE IF EXISTS `VNF_PROFILE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VNF_PROFILE` ( - `vnf_type` varchar(200) NOT NULL, - `availability_zone_count` int(11) NOT NULL, - `equipment_role` varchar(80) NOT NULL, - PRIMARY KEY (`vnf_type`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VPE_LOCK` --- - -DROP TABLE IF EXISTS `VPE_LOCK`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VPE_LOCK` ( - `vpe_name` varchar(20) NOT NULL, - `vpn_lock` varchar(20) NOT NULL, - PRIMARY KEY (`vpe_name`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VPE_POOL` --- - -DROP TABLE IF EXISTS `VPE_POOL`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VPE_POOL` ( - `vpe_name` varchar(20) NOT NULL, - `ipv4_oam_address` varchar(20) NOT NULL, - `loopback0_ipv4_address` varchar(20) NOT NULL, - `provisioning_status` varchar(10) NOT NULL, - `aic_site_id` varchar(100) NOT NULL, - `availability_zone` varchar(100) NOT NULL, - `vlan_id_outer` varchar(20) NOT NULL, - `vendor` varchar(20) NOT NULL, - `physical_intf_name` varchar(40) NOT NULL, - `physical_intf_speed` varchar(20) NOT NULL, - `physical_intf_units` varchar(20) NOT NULL, - `vpe_uuid` varchar(80) DEFAULT NULL, - `vpe_id` varchar(80) NOT NULL, - `image_filename` varchar(100) DEFAULT NULL, - `as_number` varchar(20) NOT NULL, - `loopback5000` varchar(16) DEFAULT NULL, - `loopback10` varchar(16) DEFAULT NULL, - PRIMARY KEY (`aic_site_id`,`vpe_name`,`availability_zone`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VPLSPE_POOL` --- - -DROP TABLE IF EXISTS `VPLSPE_POOL`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VPLSPE_POOL` ( - `vplspe_name` varchar(20) NOT NULL, - `aic_site_id` varchar(100) NOT NULL, - `availability_zone` varchar(100) NOT NULL, - `physical_intf_name` varchar(40) NOT NULL, - `physical_intf_speed` varchar(20) NOT NULL, - `physical_intf_units` varchar(20) NOT NULL, - `loopback0_ipv4_address` varchar(20) NOT NULL, - `vlan_id_outer` varchar(20) NOT NULL, - `vplspe_uuid` varchar(80) DEFAULT NULL, - `image_filename` varchar(100) DEFAULT NULL, - `provisioning_status` varchar(10) DEFAULT NULL, - `vendor` varchar(20) DEFAULT NULL, - PRIMARY KEY (`vplspe_name`,`aic_site_id`,`availability_zone`,`physical_intf_name`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VSERVER` --- - -DROP TABLE IF EXISTS `VSERVER`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VSERVER` ( - `tenant_id` varchar(40) NOT NULL, - `vserver_id` varchar(40) NOT NULL, - `aic_site_id` varchar(100) NOT NULL, - `vendor` varchar(20) NOT NULL, - `image_name` varchar(100) NOT NULL, - `vnf_type` varchar(10) NOT NULL, - `vnf_id` varchar(80) NOT NULL, - PRIMARY KEY (`tenant_id`,`vserver_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VSERVER2` --- - -DROP TABLE IF EXISTS `VSERVER2`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VSERVER2` ( - `tenant_id` varchar(255) NOT NULL, - `vserver_id` varchar(128) NOT NULL, - `vserver_name` varchar(255) NOT NULL, - `vserver_name2` varchar(255) DEFAULT NULL, - `prov_status` varchar(20) DEFAULT NULL, - `selflink` varchar(255) DEFAULT NULL, - PRIMARY KEY (`tenant_id`,`vserver_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `VSERVER_PSERVER` --- - -DROP TABLE IF EXISTS `VSERVER_PSERVER`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `VSERVER_PSERVER` ( - `vserver_id` varchar(128) NOT NULL, - `pserver_hostname` varchar(255) DEFAULT NULL, - PRIMARY KEY (`vserver_id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `WAN_COMBO_ALLOWABLE` --- - -DROP TABLE IF EXISTS `WAN_COMBO_ALLOWABLE`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `WAN_COMBO_ALLOWABLE` ( - `combo_sequence` int(11) NOT NULL AUTO_INCREMENT, - `internet_topology` varchar(20) DEFAULT NULL, - `wan1` varchar(40) DEFAULT NULL, - `wan2` varchar(40) DEFAULT NULL, - `new_start_release` char(5) DEFAULT NULL, - `description` varchar(128) NOT NULL, - PRIMARY KEY (`combo_sequence`), - UNIQUE KEY `IX1_WAN_COMBO_ALLOWABLE` (`internet_topology`,`wan1`,`wan2`) -) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `emp1000` --- - -DROP TABLE IF EXISTS `emp1000`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `emp1000` ( - `firstName` varchar(20) DEFAULT NULL, - `lastName` varchar(20) DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `linda` --- - -DROP TABLE IF EXISTS `linda`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `linda` ( - `c1` int(11) DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `testit` --- - -DROP TABLE IF EXISTS `testit`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `testit` ( - `c1` varchar(12) DEFAULT NULL, - `c2` int(11) DEFAULT NULL -) ENGINE=InnoDB DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `testtable` --- - -DROP TABLE IF EXISTS `testtable`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `testtable` ( - `city_code_id` int(11) NOT NULL AUTO_INCREMENT, - `city_code` varchar(3) NOT NULL, - `city` varchar(150) NOT NULL, - `state` varchar(10) NOT NULL, - `country_code` varchar(10) NOT NULL, - PRIMARY KEY (`city_code_id`), - KEY `IN1_testtable` (`city`,`state`,`country_code`) -) ENGINE=InnoDB AUTO_INCREMENT=37756 DEFAULT CHARSET=latin1; -/*!40101 SET character_set_client = @saved_cs_client */; -SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; -/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; -/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - --- Dump completed on 2016-11-23 16:01:55 diff --git a/odlsli/odlsli-alpine/src/main/resources/org.ops4j.pax.logging.cfg b/odlsli/odlsli-alpine/src/main/resources/org.ops4j.pax.logging.cfg deleted file mode 100644 index ee35ef70..00000000 --- a/odlsli/odlsli-alpine/src/main/resources/org.ops4j.pax.logging.cfg +++ /dev/null @@ -1,92 +0,0 @@ -################################################################################ -# -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed with -# this work for additional information regarding copyright ownership. -# The ASF licenses this file to You under the Apache License, Version 2.0 -# (the "License"); you may not use this file except in compliance with -# the License. You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# -################################################################################ - -# Common pattern layout for appenders -log4j2.pattern = %d{ISO8601} | %-5p | %-16t | %-32c{1} | %X{bundle.id} - %X{bundle.name} - %X{bundle.version} | %X{currentGraph} - %X{nodeId} | %m%n - -# Root logger -log4j2.rootLogger.level = INFO -# uncomment to use asynchronous loggers, which require mvn:com.lmax/disruptor/3.3.2 library -#log4j2.rootLogger.type = asyncRoot -#log4j2.rootLogger.includeLocation = false -log4j2.rootLogger.appenderRef.RollingFile.ref = RollingFile -log4j2.rootLogger.appenderRef.PaxOsgi.ref = PaxOsgi -log4j2.rootLogger.appenderRef.Console.ref = Console -log4j2.rootLogger.appenderRef.Console.filter.threshold.type = ThresholdFilter -log4j2.rootLogger.appenderRef.Console.filter.threshold.level = ${karaf.log.console:-OFF} - -# Loggers configuration - -# Spifly logger -log4j2.logger.spifly.name = org.apache.aries.spifly -log4j2.logger.spifly.level = WARN - -# Security audit logger -log4j2.logger.audit.name = org.apache.karaf.jaas.modules.audit -log4j2.logger.audit.level = INFO -log4j2.logger.audit.additivity = false -log4j2.logger.audit.appenderRef.AuditRollingFile.ref = AuditRollingFile - -# Appenders configuration - -# Console appender not used by default (see log4j2.rootLogger.appenderRefs) -log4j2.appender.console.type = Console -log4j2.appender.console.name = Console -log4j2.appender.console.layout.type = PatternLayout -log4j2.appender.console.layout.pattern = ${log4j2.pattern} - -# Rolling file appender -log4j2.appender.rolling.type = RollingRandomAccessFile -log4j2.appender.rolling.name = RollingFile -log4j2.appender.rolling.fileName = ${karaf.data}/log/karaf.log -log4j2.appender.rolling.filePattern = ${karaf.data}/log/karaf.log.%i -# uncomment to not force a disk flush -#log4j2.appender.rolling.immediateFlush = false -log4j2.appender.rolling.append = true -log4j2.appender.rolling.layout.type = PatternLayout -log4j2.appender.rolling.layout.pattern = ${log4j2.pattern} -log4j2.appender.rolling.policies.type = Policies -log4j2.appender.rolling.policies.size.type = SizeBasedTriggeringPolicy -log4j2.appender.rolling.policies.size.size = 16MB - -# Audit file appender -log4j2.appender.audit.type = RollingRandomAccessFile -log4j2.appender.audit.name = AuditRollingFile -log4j2.appender.audit.fileName = ${karaf.data}/security/audit.log -log4j2.appender.audit.filePattern = ${karaf.data}/security/audit.log.%i -log4j2.appender.audit.append = true -log4j2.appender.audit.layout.type = PatternLayout -log4j2.appender.audit.layout.pattern = ${log4j2.pattern} -log4j2.appender.audit.policies.type = Policies -log4j2.appender.audit.policies.size.type = SizeBasedTriggeringPolicy -log4j2.appender.audit.policies.size.size = 8MB - -# OSGi appender -log4j2.appender.osgi.type = PaxOsgi -log4j2.appender.osgi.name = PaxOsgi -log4j2.appender.osgi.filter = * - - -# help with identification of maven-related problems with pax-url-aether -#log4j2.logger.aether.name = shaded.org.eclipse.aether -#log4j2.logger.aether.level = TRACE -#log4j2.logger.http-headers.name = shaded.org.apache.http.headers -#log4j2.logger.http-headers.level = DEBUG -#log4j2.logger.maven.name = org.ops4j.pax.url.mvn -#log4j2.logger.maven.level = TRACE diff --git a/odlsli/odlsli-alpine/src/main/scripts/installOdlHostKey.sh b/odlsli/odlsli-alpine/src/main/scripts/installOdlHostKey.sh deleted file mode 100644 index 603a3b4a..00000000 --- a/odlsli/odlsli-alpine/src/main/scripts/installOdlHostKey.sh +++ /dev/null @@ -1,29 +0,0 @@ -### -# ============LICENSE_START======================================================= -# ONAP : CCSDK -# ================================================================================ -# Copyright (C) 2018 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### -ODL_HOME=${ODL_HOME:-/opt/opendaylight/current} -if [ ! -f ${ODL_HOME}/etc/host.key ] -then - echo "Installing karaf host key" - umask 022 - mv ${ODL_HOME}/etc/org.apache.karaf.shell.cfg ${ODL_HOME}/etc/org.apache.karaf.shell.cfg.sav - cat ${ODL_HOME}/etc/org.apache.karaf.shell.cfg.sav | sed -e "s/hostKeyFormat = simple/hostKeyFormat = PEM/" > ${ODL_HOME}/etc/org.apache.karaf.shell.cfg - openssl genrsa -out /opt/opendaylight/current/etc/host.key 4096 -fi \ No newline at end of file diff --git a/odlsli/odlsli-alpine/src/main/scripts/installSdncDb.sh b/odlsli/odlsli-alpine/src/main/scripts/installSdncDb.sh deleted file mode 100644 index efd7fe02..00000000 --- a/odlsli/odlsli-alpine/src/main/scripts/installSdncDb.sh +++ /dev/null @@ -1,45 +0,0 @@ -#!/bin/bash - -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - -CCSDK_HOME=${CCSDK_HOME:-/opt/onap/ccsdk} -MYSQL_PASSWD=${MYSQL_PASSWD:-openECOMP1.0} - -SDNC_DB_USER=${SDNC_DB_USER:-sdnctl} -SDNC_DB_PASSWD=${SDNC_DB_PASSWD:-gamma} -SDNC_DB_DATABASE=${SDN_DB_DATABASE:-sdnctl} - - -# Create tablespace and user account -mysql -h dbhost -u root -p${MYSQL_PASSWD} mysql <<-END -CREATE DATABASE ${SDNC_DB_DATABASE}; -CREATE USER '${SDNC_DB_USER}'@'localhost' IDENTIFIED BY '${SDNC_DB_PASSWD}'; -CREATE USER '${SDNC_DB_USER}'@'%' IDENTIFIED BY '${SDNC_DB_PASSWD}'; -GRANT ALL PRIVILEGES ON ${SDNC_DB_DATABASE}.* TO '${SDNC_DB_USER}'@'localhost' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON ${SDNC_DB_DATABASE}.* TO '${SDNC_DB_USER}'@'%' WITH GRANT OPTION; -commit; -END - -if [ -f ${CCSDK_HOME}/data/odlsli.dump ] -then -mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < ${CCSDK_HOME}/data/odlsli.dump -fi diff --git a/odlsli/odlsli-alpine/src/main/scripts/startODL.sh b/odlsli/odlsli-alpine/src/main/scripts/startODL.sh deleted file mode 100644 index 4d608577..00000000 --- a/odlsli/odlsli-alpine/src/main/scripts/startODL.sh +++ /dev/null @@ -1,65 +0,0 @@ -#!/bin/bash - -### -# ============LICENSE_START======================================================= -# openECOMP : SDN-C -# ================================================================================ -# Copyright (C) 2017 AT&T Intellectual Property. All rights -# reserved. -# ================================================================================ -# Licensed under the Apache License, Version 2.0 (the "License"); -# you may not use this file except in compliance with the License. -# You may obtain a copy of the License at -# -# http://www.apache.org/licenses/LICENSE-2.0 -# -# Unless required by applicable law or agreed to in writing, software -# distributed under the License is distributed on an "AS IS" BASIS, -# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -# See the License for the specific language governing permissions and -# limitations under the License. -# ============LICENSE_END========================================================= -### - - -# Install SDN-C platform components if not already installed and start container - -ODL_HOME=${ODL_HOME:-/opt/opendaylight} -ODL_ADMIN_PASSWORD=${ODL_ADMIN_PASSWORD:-Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U} -CCSDK_HOME=${CCSDK_HOME:-/opt/onap/ccsdk} -SLEEP_TIME=${SLEEP_TIME:-120} -MYSQL_PASSWD=${MYSQL_PASSWD:-openECOMP1.0} -INSTALLED_DIR=${INSTALLED_FILE:-/opt/opendaylight/current/daexim} - - -# -# Wait for database -# -echo "Waiting for mysql" -until mysql -h dbhost -u root -p${MYSQL_PASSWD} mysql &> /dev/null -do - printf "." - sleep 1 -done -echo -e "\nmysql ready" - -if [ ! -d ${INSTALLED_DIR} ] -then - mkdir -p ${INSTALLED_DIR} -fi - -if [ ! -f ${INSTALLED_DIR}/.installed ] -then - echo "Installing SDN-C database" - ${CCSDK_HOME}/bin/installSdncDb.sh - # echo "Installing OpenDaylight host key" - # ${CCSDK_HOME}/bin/installOdlHostKey.sh - if [ -x ${CCSDK_HOME}/svclogic/bin/install.sh ] - then - echo "Installing directed graphs" - ${CCSDK_HOME}/svclogic/bin/install.sh - fi - echo "Installed at `date`" > ${INSTALLED_DIR}/.installed -fi - -exec ${ODL_HOME}/bin/karaf server diff --git a/odlsli/odlsli-alpine/src/main/stores/truststore.onap.client.jks b/odlsli/odlsli-alpine/src/main/stores/truststore.onap.client.jks deleted file mode 100755 index 28afd8fa..00000000 Binary files a/odlsli/odlsli-alpine/src/main/stores/truststore.onap.client.jks and /dev/null differ diff --git a/odlsli/src/main/scripts/installSdncDb.sh b/odlsli/src/main/scripts/installSdncDb.sh index efd7fe02..b8cf6938 100644 --- a/odlsli/src/main/scripts/installSdncDb.sh +++ b/odlsli/src/main/scripts/installSdncDb.sh @@ -1,4 +1,4 @@ -#!/bin/bash +#!/bin/sh ### # ============LICENSE_START======================================================= diff --git a/odlsli/src/main/scripts/startODL.sh b/odlsli/src/main/scripts/startODL.sh index 4d608577..3943115d 100644 --- a/odlsli/src/main/scripts/startODL.sh +++ b/odlsli/src/main/scripts/startODL.sh @@ -1,4 +1,4 @@ -#!/bin/bash +#!/bin/sh ### # ============LICENSE_START=======================================================