Prune code migrated from sdnc/core to ccsdk

[sdnc/core.git] / sli / common / src / main / resources / crAseNetwork.sql

diff --git a/sli/common/src/main/resources/crAseNetwork.sql b/sli/common/src/main/resources/crAseNetwork.sql
deleted file mode 100644 (file)
index 4123117..0000000
--- a/sli/common/src/main/resources/crAseNetwork.sql
+++ /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=========================================================
----
-
-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));
-       
-       
-