2 -- ============LICENSE_START=======================================================
4 -- ================================================================================
5 -- Copyright (C) 2017 ONAP
6 -- ================================================================================
7 -- Licensed under the Apache License, Version 2.0 (the "License");
8 -- you may not use this file except in compliance with the License.
9 -- You may obtain a copy of the License at
11 -- http://www.apache.org/licenses/LICENSE-2.0
13 -- Unless required by applicable law or agreed to in writing, software
14 -- distributed under the License is distributed on an "AS IS" BASIS,
15 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 -- See the License for the specific language governing permissions and
17 -- limitations under the License.
18 -- ============LICENSE_END=========================================================
21 CREATE TABLE sdnctl.ASE (
22 ase_network_id INT NOT NULL,
24 CONSTRAINT P_ASE PRIMARY KEY(ase_network_id));
26 CREATE TABLE sdnctl.ASE_PORT (
28 resource_emt_clli VARCHAR(25) NOT NULL,
29 resource_emt_ip_addr VARCHAR(25) NOT NULL,
30 port_action VARCHAR(25),
32 port VARCHAR(15) NOT NULL,
34 resource_mode VARCHAR(25),
36 resource_lldp VARCHAR(1),
37 resource_mtu VARCHAR(5),
38 resource_autoneg VARCHAR(10),
39 resource_twamp VARCHAR(10),
40 resource_description VARCHAR(80),
41 uni_circuit_id VARCHAR(45),
42 CONSTRAINT P_ASE_PORT PRIMARY KEY(resource_emt_clli, port));
44 CREATE TABLE sdnctl.ASE_EVC (
46 emt_ip_addr VARCHAR(25) NOT NULL,
47 evc_action VARCHAR(25),
48 service_id VARCHAR(25),
49 serv_type VARCHAR(25),
50 evc_choice VARCHAR(25),
51 uni_port VARCHAR(25) NOT NULL,
53 mac_onoff VARCHAR(25),
62 interface VARCHAR(25),
63 evc_description VARCHAR(80),
64 bandwidth VARCHAR(10),
67 routing_instance VARCHAR(25),
70 evc_limit VARCHAR(25),
71 label_block_size VARCHAR(25),
73 int_mac_limit VARCHAR(5),
74 sgos_grade VARCHAR(25),
76 uni_circuit_id VARCHAR(45),
78 CONSTRAINT P_ASE_EVC PRIMARY KEY(emt_ip_addr, uni_port,leg));