diff options
| author |   Timoney, Dan (dt5972) <dtimoney@att.com> | 2019-08-29 11:23:04 -0400 |
|---|---|---|
| committer | Timoney, Dan (dt5972) <dtimoney@att.com> | 2019-08-29 11:23:21 -0400 |
| commit | 22bb2af4ed106150230fd55e4314697e77f51e6a (patch) | |
| tree | e6d74bea0de5b43e4eae2e77ac4ba5e4740bf739 /lighty/lighty-ubuntu-docker/src/main | |
| parent | 6e4a3b694045c930d4ce97766ed43d78e2cd3459 (diff) | |
Revert "Proposal to remove OSGi dependencies from the CCSDK project"
This reverts commit e385a7a1d1934c6a3d22df3c3244678ca415134a.
Change-Id: I4d3e0d7996fc33ba443ce91f15e9a6dd670bec93
Signed-off-by: Timoney, Dan (dt5972) <dtimoney@att.com>
Diffstat (limited to 'lighty/lighty-ubuntu-docker/src/main')
25 files changed, 0 insertions, 2340 deletions
diff --git a/lighty/lighty-ubuntu-docker/src/main/docker/Dockerfile b/lighty/lighty-ubuntu-docker/src/main/docker/Dockerfile deleted file mode 100644 index fbf9356f..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/docker/Dockerfile +++ /dev/null @@ -1,16 +0,0 @@ -# Base ubuntu with added packages needed for open ecomp -FROM onap/ccsdk-ubuntu-image:${project.docker.latestfulltag.version} -MAINTAINER CCSDK Team (onap-ccsdk@lists.onap.org) -ENV JAVA_HOME /usr/lib/jvm/java-8-openjdk-amd64 -ENV ODL_HOME /opt/opendaylight/current - -# copy the opendaylight tar and expand -COPY ${lighty.app.zip} /tmp/lighty/ -RUN mkdir -p /opt/lighty \ - && unzip /tmp/lighty/${lighty.app.zip} -d /opt/lighty \ - && rm -rf /tmp/lighty - -COPY opt /opt - -ENTRYPOINT /opt/onap/ccsdk/bin/startODL.sh -EXPOSE 8181 diff --git a/lighty/lighty-ubuntu-docker/src/main/docker/docker-compose.yml b/lighty/lighty-ubuntu-docker/src/main/docker/docker-compose.yml deleted file mode 100644 index 14c3dc32..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/docker/docker-compose.yml +++ /dev/null @@ -1,64 +0,0 @@ -version: '2' - -services: - db: - image: mysql/mysql-server:5.6 - container_name: ccsdk_db_container - ports: - - "3306" - environment: - - MYSQL_ROOT_PASSWORD=openECOMP1.0 - - MYSQL_ROOT_HOST=% - logging: - driver: "json-file" - options: - max-size: "30m" - max-file: "5" - - - odlsli: - image: onap/ccsdk-lighty-ubuntu-image - depends_on : - - db - container_name: ccsdk_lighty_container - entrypoint: ["/opt/onap/ccsdk/bin/startODL.sh"] - ports: - - "8383:8181" - links: - - db:dbhost - - db:sdnctldb01 - - db:sdnctldb02 - environment: - - MYSQL_ROOT_PASSWORD=openECOMP1.0 - - SDNC_CONFIG_DIR=/opt/onap/ccsdk/data/properties - logging: - driver: "json-file" - options: - max-size: "30m" - max-file: "5" - - dgbuilder: - image: nexus3.onap.org:10001/onap/ccsdk-dgbuilder-image - depends_on: - - db - container_name: ccsdk_dgbuilder_container - entrypoint: - - "/bin/bash" - - "-c" - - "cd /opt/onap/ccsdk/dgbuilder/ && ./start.sh sdnc1.0 && wait" - ports: - - "3000:3100" - links: - - db:dbhost - - db:sdnctldb01 - - db:sdnctldb02 - - odlsli:sdnhost - environment: - - MYSQL_ROOT_PASSWORD=openECOMP1.0 - - SDNC_CONFIG_DIR=/opt/onap/ccsdk/data/properties - logging: - driver: "json-file" - options: - max-size: "30m" - max-file: "5" - diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/aaiclient.properties b/lighty/lighty-ubuntu-docker/src/main/properties/aaiclient.properties deleted file mode 100755 index 4f27206f..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/admportal.json b/lighty/lighty-ubuntu-docker/src/main/properties/admportal.json deleted file mode 100755 index 8d567d0c..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/admportal.log4js.json b/lighty/lighty-ubuntu-docker/src/main/properties/admportal.log4js.json deleted file mode 100755 index 0f41e564..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/dblib.properties b/lighty/lighty-ubuntu-docker/src/main/properties/dblib.properties deleted file mode 100644 index 9506ac8d..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/grpc.properties b/lighty/lighty-ubuntu-docker/src/main/properties/grpc.properties deleted file mode 100644 index 797c67e2..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/grpc.properties +++ /dev/null @@ -1,18 +0,0 @@ -# -# Copyright (C) 2019 Bell Canada. -# -# 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. -# -org.onap.ccsdk.sli.adaptors.grpc.blueprint.processor.url=cds-blueprints-processor-grpc -org.onap.ccsdk.sli.adaptors.grpc.blueprint.processor.port=9111 -org.onap.ccsdk.sli.adaptors.grpc.blueprint.processor.auth=Basic Y2NzZGthcHBzOmNjc2RrYXBwcw== diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/lightyCcsdkConfig.json b/lighty/lighty-ubuntu-docker/src/main/properties/lightyCcsdkConfig.json deleted file mode 100644 index 1abed344..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/lightyCcsdkConfig.json +++ /dev/null @@ -1,74 +0,0 @@ -{ - "controller":{ - "restoreDirectoryPath":"./clustered-datastore-restore", - "maxDataBrokerFutureCallbackQueueSize":1000, - "maxDataBrokerFutureCallbackPoolSize":10, - "metricCaptureEnabled":false, - "mailboxCapacity":1000, - "moduleShardsConfig": "configuration/initial/module-shards.conf", - "modulesConfig": "configuration/initial/modules.conf", - "domNotificationRouterConfig":{ - "queueDepth":65536, - "spinTime":0, - "parkTime":0, - "unit":"MILLISECONDS" - }, - "actorSystemConfig":{ - "akkaConfigPath":"singlenode/akka-default.conf", - "factoryAkkaConfigPath":"singlenode/factory-akka-default.conf" - }, - "schemaServiceConfig":{ - "topLevelModels":[ - { "nameSpace": "urn:TBD:params:xml:ns:yang:network:isis-topology", "name": "isis-topology", "revision": "2013-07-12" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:core:general-entity", "name": "general-entity", "revision": "2015-08-20" }, - { "nameSpace": "subscribe:to:notification", "name": "subscribe-to-notification", "revision": "2016-10-28" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:cluster:admin", "name": "cluster-admin", "revision": "2015-10-13" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-lisp-address-types", "name": "ietf-lisp-address-types", "revision": "2015-11-05" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:aaa", "name": "aaa", "revision": "2016-12-14" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:config:actor-system-provider:impl", "name": "actor-system-provider-impl", "revision": "2015-10-05" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ospf-topology", "name": "ospf-topology", "revision": "2013-07-12" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:config:distributed-datastore-provider", "name": "distributed-datastore-provider", "revision": "2014-06-12" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-yang-library", "name": "ietf-yang-library", "revision": "2016-06-21" }, - { "nameSpace": "urn:TBD:params:xml:ns:yang:network:isis-topology", "name": "isis-topology", "revision": "2013-10-21" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:inmemory-datastore-provider", "name": "opendaylight-inmemory-datastore-provider", "revision": "2014-06-17" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-restconf", "name": "ietf-restconf", "revision": "2013-10-19" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:iana-afn-safi", "name": "iana-afn-safi", "revision": "2013-07-04" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:config:concurrent-data-broker", "name": "odl-concurrent-data-broker-cfg", "revision": "2014-11-24" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:clustering:entity-owners", "name": "entity-owners", "revision": "2015-08-04" }, - { "nameSpace": "urn:sal:restconf:event:subscription", "name": "sal-remote-augment", "revision": "2014-07-08" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-access-control-list", "name": "ietf-access-control-list", "revision": "2016-02-18" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:dom:pingpong", "name": "opendaylight-pingpong-broker", "revision": "2014-11-07" }, - { "nameSpace": "instance:identifier:patch:module", "name": "instance-identifier-patch-module", "revision": "2015-11-21" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-network-topology", "name": "ietf-network-topology", "revision": "2015-06-08" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-yang-types", "name": "ietf-yang-types", "revision": "2010-09-24" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:mdsal:core:general-entity", "name": "odl-general-entity", "revision": "2015-09-30" }, - { "nameSpace": "urn:opendaylight:yang:extension:yang-ext", "name": "yang-ext", "revision": "2013-07-09" }, - { "nameSpace": "urn:opendaylight:l2:types", "name": "opendaylight-l2-types", "revision": "2013-08-27" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:md:sal:config:impl:cluster-singleton-service", "name": "cluster-singleton-service-impl", "revision": "2016-07-18" }, - { "nameSpace": "urn:TBD:params:xml:ns:yang:ospf-topology", "name": "ospf-topology", "revision": "2013-10-21" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-restconf-monitoring", "name": "ietf-restconf-monitoring", "revision": "2017-01-26" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:clustering:prefix-shard-configuration", "name": "prefix-shard-configuration", "revision": "2017-01-10" }, - { "nameSpace": "urn:opendaylight:aaa:app:config", "name": "aaa-app-config", "revision": "2017-06-19" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:ietf-restconf", "name": "ietf-restconf", "revision": "2017-01-26" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:config:legacy-entity-ownership-service-provider", "name": "opendaylight-legacy-entity-ownership-service-provider", "revision": "2016-02-26" }, - { "nameSpace": "urn:ietf:params:xml:ns:yang:iana-if-type", "name": "iana-if-type", "revision": "2014-05-08" }, - { "nameSpace": "urn:opendaylight:params:xml:ns:yang:controller:md:sal:binding:impl", "name": "opendaylight-sal-binding-broker-impl", "revision": "2013-10-28" }, - - { "nameSpace": "org:onap:ccsdk:sli:core:sliapi", "name": "SLI-API", "revision": "2016-11-10" }, - { "nameSpace": "org:onap:ccsdk:sli:northbound:lcm", "name": "LCM", "revision": "2018-03-29" }, - { "nameSpace": "org:onap:ccsdk:sli:northbound:datachange", "name": "DataChange", "revision": "2015-05-19" }, - { "nameSpace": "org:onap:ccsdk:sli:northbound:asdcapi:common", "name": "asdc-api-common", "revision": "2017-02-01" }, - { "nameSpace": "http://xmlns.onap.org/asdc/license-model/1.0", "name": "asdc-license-model", "revision": "2016-04-27" }, - { "nameSpace": "org:onap:ccsdk", "name": "ASDC-API", "revision": "2017-02-01" } - - ] - } - }, - "restconf":{ - "httpPort":8181, - "webSocketPort": 8185, - "restconfServletContextPath":"/restconf", - "jsonRestconfServiceType": "DRAFT_18", - "inetAddress": "0.0.0.0" - } -} diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/mdsal-resource.properties b/lighty/lighty-ubuntu-docker/src/main/properties/mdsal-resource.properties deleted file mode 100644 index d8537471..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/netbox.properties b/lighty/lighty-ubuntu-docker/src/main/properties/netbox.properties deleted file mode 100644 index 4346d177..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/netbox.properties +++ /dev/null @@ -1,19 +0,0 @@ -# -# Copyright (C) 2019 Bell Canada. -# -# 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. -# - -# Configuration file for Netbox client -org.onap.ccsdk.sli.adaptors.netbox.url=http://netbox-nginx:8080 -org.onap.ccsdk.sli.adaptors.netbox.apikey=onceuponatimeiplayedwithnetbox20180814
\ No newline at end of file diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/partners.json b/lighty/lighty-ubuntu-docker/src/main/properties/partners.json deleted file mode 100755 index 9a17a1ac..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/partners.json +++ /dev/null @@ -1,16 +0,0 @@ -{
- "partnerOne": {
- "url": "http://localhost:7001",
- "test": "/metrics"
- },
- "partnerTwo": {
- "url": "http://localhost:7002",
- "user": "controller_user",
- "password": "P@ssword",
- "test": "/metrics"
- },
- "partnerThree": {
- "url": "http://localhost:7003",
- "user": "controller_admin"
- }
-}
diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/sdnr-oofpcipoc-api-dg.properties b/lighty/lighty-ubuntu-docker/src/main/properties/sdnr-oofpcipoc-api-dg.properties deleted file mode 100644 index d4f7e3cb..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/sdnr-oofpcipoc-api-dg.properties +++ /dev/null @@ -1,35 +0,0 @@ -restapi.templateDir=/opt/onap/ccsdk/restapi/templates -controller.url=http://localhost:8181 -controller.user=admin -controller.pwd=Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U -honeycomb.url=http://{honeycomb-instance-ip}:8183 -honeycomb.user=admin -honeycomb.pwd=admin -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 - -# URLs -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} diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/sql-resource.properties b/lighty/lighty-ubuntu-docker/src/main/properties/sql-resource.properties deleted file mode 100644 index ac32f773..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/svclogic.properties b/lighty/lighty-ubuntu-docker/src/main/properties/svclogic.properties deleted file mode 100644 index 54d667cf..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/svclogic.properties.sdnctldb01 b/lighty/lighty-ubuntu-docker/src/main/properties/svclogic.properties.sdnctldb01 deleted file mode 100755 index 54d667cf..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/properties/template-node.properties b/lighty/lighty-ubuntu-docker/src/main/properties/template-node.properties deleted file mode 100644 index 1199a0cd..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/template-node.properties +++ /dev/null @@ -1,4 +0,0 @@ -velocity.resource.loader=class -velocity.file.resource.loader.path=/home/my/example -velocity.file.resource.loader.cache=true -velocity.custom.property=customValue
\ No newline at end of file diff --git a/lighty/lighty-ubuntu-docker/src/main/properties/ueb.properties b/lighty/lighty-ubuntu-docker/src/main/properties/ueb.properties deleted file mode 100644 index 88711306..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/properties/ueb.properties +++ /dev/null @@ -1,4 +0,0 @@ -poolMembers=10.147.29.67:3904 -topic.read=APPC-TEST1 -topic.read.timeout=2500 -topic.write=APPC-TEST1 diff --git a/lighty/lighty-ubuntu-docker/src/main/resources/ansible-sources.list b/lighty/lighty-ubuntu-docker/src/main/resources/ansible-sources.list deleted file mode 100644 index 7e166f23..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/resources/idmlight.db.mv.db b/lighty/lighty-ubuntu-docker/src/main/resources/idmlight.db.mv.db Binary files differdeleted file mode 100644 index c0b7b499..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/resources/idmlight.db.mv.db +++ /dev/null diff --git a/lighty/lighty-ubuntu-docker/src/main/resources/install_ccsdk.yml b/lighty/lighty-ubuntu-docker/src/main/resources/install_ccsdk.yml deleted file mode 100644 index e09eceba..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/resources/odlsli.dump b/lighty/lighty-ubuntu-docker/src/main/resources/odlsli.dump deleted file mode 100644 index e6b6222a..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/resources/odlsli.dump +++ /dev/null @@ -1,1418 +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, - `modified_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `md5sum` varchar(128) DEFAULT NULL, - 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/lighty/lighty-ubuntu-docker/src/main/resources/org.ops4j.pax.logging.cfg b/lighty/lighty-ubuntu-docker/src/main/resources/org.ops4j.pax.logging.cfg deleted file mode 100644 index ee35ef70..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/scripts/installSdncDb.sh b/lighty/lighty-ubuntu-docker/src/main/scripts/installSdncDb.sh deleted file mode 100644 index efd7fe02..00000000 --- a/lighty/lighty-ubuntu-docker/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/lighty/lighty-ubuntu-docker/src/main/scripts/startODL.sh b/lighty/lighty-ubuntu-docker/src/main/scripts/startODL.sh deleted file mode 100644 index d3e8b7c6..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/scripts/startODL.sh +++ /dev/null @@ -1,52 +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_ADMIN_PASSWORD=${ODL_ADMIN_PASSWORD:-Kp8bJ4SXszM0WXlhak3eHlcse2gAw84vaoGGmJvUy2U} -CCSDK_HOME=${CCSDK_HOME:-/opt/onap/ccsdk} -SLEEP_TIME=${SLEEP_TIME:-120} -MYSQL_PASSWD=${MYSQL_PASSWD:-openECOMP1.0} - - -# -# 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" - -echo "Installing SDN-C database" -${CCSDK_HOME}/bin/installSdncDb.sh -if [ -x ${CCSDK_HOME}/svclogic/bin/install.sh ] -then - echo "Installing directed graphs" - ${CCSDK_HOME}/svclogic/bin/install.sh -fi - -exec java -jar opt/lighty/ccsdk-lighty-distribution-0.5.0-SNAPSHOT/ccsdk-lighty-distribution-0.5.0-SNAPSHOT.jar /opt/onap/ccsdk/data/properties/lightyCcsdkConfig.json diff --git a/lighty/lighty-ubuntu-docker/src/main/stores/truststore.onap.client.jks b/lighty/lighty-ubuntu-docker/src/main/stores/truststore.onap.client.jks Binary files differdeleted file mode 100755 index 28afd8fa..00000000 --- a/lighty/lighty-ubuntu-docker/src/main/stores/truststore.onap.client.jks +++ /dev/null |