Initial openvim v0.4.6 upload

[osm/openvim.git] / database_utils / nets.sql

diff --git a/database_utils/nets.sql b/database_utils/nets.sql
new file mode 100644 (file)
index 0000000..654d0d1
--- /dev/null
+++ b/database_utils/nets.sql
@@ -0,0 +1,74 @@
+##
+# Copyright 2015 Telefónica Investigación y Desarrollo, S.A.U.
+# This file is part of openmano
+# 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.
+#
+# For those usages not covered by the Apache License, Version 2.0 please
+# contact with: nfvlabs@tid.es
+##
+
+/*
+    This table contains a list of networks created from the begining
+    The following fields are needed
+        uuid: provide a valid uuid format
+        type: ptp, data (point to point, or point to multipoint) are openflow dadaplane nets
+              bridge_man, bridge_data are virtio/bridge controlplane nets
+        name: useful human readable name
+        shared: by default true
+        vlan:  default vlan of the dataplane net
+        bind: for control plane:
+                  default: default network
+                  macvtap:host_iface. Connect to a direct macvtap host interface
+                  bridge:bridge_name. Connect to this host bridge_name interface
+              for dataplane: NULL, because the binding is done with a external port
+*/
+
+
+LOCK TABLES `nets` WRITE;
+/*
+INSERT INTO `nets`
+  (uuid,                                  `type`,       name,        shared, vlan, bind)
+VALUES
+  ('00000000-0000-0000-0000-000000000000','bridge_man', 'default',   'true', NULL, 'default'),
+  ('11111111-1111-1111-1111-111111111111','bridge_man', 'direct:em1','true', NULL, 'macvtap:em1'),
+  ('aaaaaaaa-1111-aaaa-aaaa-aaaaaaaaaaaa','data',       'coreIPv4',  'true', 702,  NULL),
+  ('aaaaaaaa-aaaa-0000-1111-aaaaaaaaaaaa','bridge_data','virbrMan2', 'true', 2002, 'bridge:virbrMan2')  # last row without ','
+;
+*/
+
+UNLOCK TABLES;
+
+/*  External PORTS are necessary to connect a dataplane network to an external switch port
+    The following fields are needed
+        uuid: provide a valid uuid format
+        name: useful human readable name
+        net_id: uuid of the net where this port must be connected
+        Mbps: only informative, indicates the expected bandwidth in megabits/s
+        type: only external has meaning here
+        vlan: if the traffic at that port must be vlan tagged
+        switch_port: port name at switch:
+*/
+
+LOCK TABLES `ports` WRITE;
+/*
+INSERT INTO `ports` 
+  (uuid,                                  name,        net_id,                                Mbps, type,      vlan, switch_port)
+VALUES
+  ('6d536a80-52e9-11e4-9e31-5254006d6777','CoreIPv4',  'aaaaaaaa-1111-aaaa-aaaa-aaaaaaaaaaaa',10000,'external',702,  'Te0/47') # last row without ','
+;
+*/
+
+UNLOCK TABLES;
+