diff options
author | Dan Timoney <dtimoney@att.com> | 2017-02-15 14:30:39 -0500 |
---|---|---|
committer | Dan Timoney <dtimoney@att.com> | 2017-02-15 14:37:01 -0500 |
commit | d8861011dc81160df81979d2bed9721447517f45 (patch) | |
tree | 6aaf805a83ad8be93bd9772a2b2e517770c67b72 /sli/common/src/main/resources/crAseNetwork.sql | |
parent | 57b0ded28b8c6477ca0df13a05eafb392f6fa82e (diff) |
Initial commit for OpenECOMP SDN-C N-C core
Change-Id: I30c52795ab821c4fdd18b55d202f10a76a01acfa
Signed-off-by: Dan Timoney <dtimoney@att.com>
Diffstat (limited to 'sli/common/src/main/resources/crAseNetwork.sql')
-rw-r--r-- | sli/common/src/main/resources/crAseNetwork.sql | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/sli/common/src/main/resources/crAseNetwork.sql b/sli/common/src/main/resources/crAseNetwork.sql new file mode 100644 index 0000000..b6a5a1f --- /dev/null +++ b/sli/common/src/main/resources/crAseNetwork.sql @@ -0,0 +1,82 @@ +--- +-- ============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========================================================= +--- + +CREATE TABLE sdnctl.ASE ( + ase_network_id INT NOT NULL, + topology VARCHAR(25), + CONSTRAINT P_ASE PRIMARY KEY(ase_network_id)); + +CREATE TABLE sdnctl.ASE_PORT ( + esm_name VARCHAR(25), + resource_emt_clli VARCHAR(25) NOT NULL, + resource_emt_ip_addr VARCHAR(25) NOT NULL, + port_action VARCHAR(25), + profile VARCHAR(25) , + port VARCHAR(15) NOT NULL, + state VARCHAR(25), + resource_mode VARCHAR(25), + speed INT, + resource_lldp VARCHAR(1), + resource_mtu VARCHAR(5), + resource_autoneg VARCHAR(10), + resource_twamp VARCHAR(10), + resource_description VARCHAR(80), + uni_circuit_id VARCHAR(45), + CONSTRAINT P_ASE_PORT PRIMARY KEY(resource_emt_clli, port)); + +CREATE TABLE sdnctl.ASE_EVC ( + esm_name VARCHAR(25), + emt_ip_addr VARCHAR(25) NOT NULL, + evc_action VARCHAR(25), + service_id VARCHAR(25), + serv_type VARCHAR(25), + evc_choice VARCHAR(25), + uni_port VARCHAR(25) NOT NULL, + lag_port VARCHAR(25), + mac_onoff VARCHAR(25), + ppcos VARCHAR(25), + cir VARCHAR(25), + cbs VARCHAR(25), + ebs VARCHAR(25), + sgos VARCHAR(25), + pe VARCHAR(25), + unit VARCHAR(25), + qinq VARCHAR(25), + interface VARCHAR(25), + evc_description VARCHAR(80), + bandwidth VARCHAR(10), + svlan VARCHAR(5), + cvlan VARCHAR(5), + routing_instance VARCHAR(25), + rd VARCHAR(25), + rt VARCHAR(25), + evc_limit VARCHAR(25), + label_block_size VARCHAR(25), + site VARCHAR(25), + int_mac_limit VARCHAR(5), + sgos_grade VARCHAR(25), + bum_rate VARCHAR(25), + uni_circuit_id VARCHAR(45), + leg INT, + CONSTRAINT P_ASE_EVC PRIMARY KEY(emt_ip_addr, uni_port,leg)); + + + |