2 -- ============LICENSE_START=======================================================
4 -- ================================================================================
5 -- Copyright (C) 2017 AT&T Intellectual Property. All rights
7 -- ================================================================================
8 -- Licensed under the Apache License, Version 2.0 (the "License");
9 -- you may not use this file except in compliance with the License.
10 -- You may obtain a copy of the License at
12 -- http://www.apache.org/licenses/LICENSE-2.0
14 -- Unless required by applicable law or agreed to in writing, software
15 -- distributed under the License is distributed on an "AS IS" BASIS,
16 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17 -- See the License for the specific language governing permissions and
18 -- limitations under the License.
19 -- ============LICENSE_END=========================================================
22 CREATE TABLE sdnctl.ASE (
23 ase_network_id INT NOT NULL,
25 CONSTRAINT P_ASE PRIMARY KEY(ase_network_id));
27 CREATE TABLE sdnctl.ASE_PORT (
29 resource_emt_clli VARCHAR(25) NOT NULL,
30 resource_emt_ip_addr VARCHAR(25) NOT NULL,
31 port_action VARCHAR(25),
33 port VARCHAR(15) NOT NULL,
35 resource_mode VARCHAR(25),
37 resource_lldp VARCHAR(1),
38 resource_mtu VARCHAR(5),
39 resource_autoneg VARCHAR(10),
40 resource_twamp VARCHAR(10),
41 resource_description VARCHAR(80),
42 uni_circuit_id VARCHAR(45),
43 CONSTRAINT P_ASE_PORT PRIMARY KEY(resource_emt_clli, port));
45 CREATE TABLE sdnctl.ASE_EVC (
47 emt_ip_addr VARCHAR(25) NOT NULL,
48 evc_action VARCHAR(25),
49 service_id VARCHAR(25),
50 serv_type VARCHAR(25),
51 evc_choice VARCHAR(25),
52 uni_port VARCHAR(25) NOT NULL,
54 mac_onoff VARCHAR(25),
63 interface VARCHAR(25),
64 evc_description VARCHAR(80),
65 bandwidth VARCHAR(10),
68 routing_instance VARCHAR(25),
71 evc_limit VARCHAR(25),
72 label_block_size VARCHAR(25),
74 int_mac_limit VARCHAR(5),
75 sgos_grade VARCHAR(25),
77 uni_circuit_id VARCHAR(45),
79 CONSTRAINT P_ASE_EVC PRIMARY KEY(emt_ip_addr, uni_port,leg));