Context Navigation

Changes between Version 4 and Version 5 of ConfigDB

Timestamp:: Mar 12, 2015 3:51:25 PM (9 years ago)
Author:: Geoff Lawler
Comment:: --

Legend:

: Unmodified
: Added
: Removed
: Modified

ConfigDB

-                      v4
+                      v5
 == Config DB Tables (Schema) ==
+*to be pasted*
+Current schema:
+{{{
+CREATE TABLE container_conf (
+        id INTEGER NOT NULL,
+        switch_shaping BOOLEAN,
+        qemu_host_hw VARCHAR(32),
+        openvz_guest_url VARCHAR(64),
+        exec_root VARCHAR(64),
+        qemu_host_os VARCHAR(32),
+        openvz_host_os VARCHAR(32),
+        qemu_url VARCHAR(64),
+        xmlrpc_server_host VARCHAR(32),
+        xmlrpc_server_port INTEGER,
+        url_base VARCHAR(64),
+        grandstand_port INTEGER,
+        backend_server_host VARCHAR(64),
+        backend_server_port INTEGER,
+        openvz_template_dir VARCHAR(64),
+        attribute_prefix VARCHAR(32),
+        switched_containers VARCHAR(32),
+        topdl_converter VARCHAR(128),
+        default_dest VARCHAR(32),
+        default_router VARCHAR(32),
+        node_log VARCHAR(128),
+        PRIMARY KEY (id),
+        CHECK (switch_shaping IN (0, 1))
+);
+CREATE TABLE computer (
+        id INTEGER NOT NULL,
+        name VARCHAR(64),
+        PRIMARY KEY (id)
+);
+CREATE TABLE hosts (
+        id INTEGER NOT NULL,
+        address VARCHAR(50),
+        name VARCHAR(32),
+        PRIMARY KEY (id)
+);
+CREATE TABLE groups (
+        id INTEGER NOT NULL,
+        name VARCHAR(32),
+        gid INTEGER,
+        PRIMARY KEY (id)
+);
+CREATE TABLE mounts (
+        id INTEGER NOT NULL,
+        remote VARCHAR(128),
+        local VARCHAR(128),
+        type VARCHAR(32),
+        options VARCHAR(64),
+        PRIMARY KEY (id)
+);
+CREATE TABLE capacity (
+        id INTEGER NOT NULL,
+        rate FLOAT,
+        units VARCHAR(8),
+        kind VARCHAR(8),
+        PRIMARY KEY (id)
+);
+CREATE TABLE users (
+        id INTEGER NOT NULL,
+        login VARCHAR(64),
+        password VARCHAR(64),
+        uid INTEGER,
+        gid INTEGER,
+        root INTEGER,
+        name VARCHAR(64),
+        home VARCHAR(64),
+        email VARCHAR(64),
+        shell VARCHAR(64),
+        PRIMARY KEY (id),
+        FOREIGN KEY(gid) REFERENCES groups (id)
+);
+CREATE TABLE switch_vde (
+        id INTEGER NOT NULL,
+        computer_id INTEGER,
+        socket VARCHAR(64),
+        management VARCHAR(64),
+        tag VARCHAR(16),
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE computer_embedded_pnode (
+        id INTEGER NOT NULL,
+        computer_id INTEGER,
+        realname VARCHAR(64),
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE computer_openvz (
+        id INTEGER NOT NULL,
+        template VARCHAR(128),
+        computer_id INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE guest_host_embed (
+        id INTEGER NOT NULL,
+        guest INTEGER,
+        host INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(guest) REFERENCES computer (id),
+        FOREIGN KEY(host) REFERENCES computer (id)
+);
+CREATE TABLE computer_linux_container (
+        id INTEGER NOT NULL,
+        computer_id INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE computer_qemu (
+        id INTEGER NOT NULL,
+        arch VARCHAR(12),
+        image_url VARCHAR(128),
+        os VARCHAR(64),
+        computer_id INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE computer_pnode (
+        id INTEGER NOT NULL,
+        computer_id INTEGER,
+        realname VARCHAR(64),
+        PRIMARY KEY (id),
+        FOREIGN KEY(computer_id) REFERENCES computer (id)
+);
+CREATE TABLE substrate (
+        id INTEGER NOT NULL,
+        name VARCHAR(32),
+        capacity_id INTEGER,
+        vlan INTEGER,
+        multicast VARCHAR(15),
+        control BOOLEAN,
+        PRIMARY KEY (id),
+        UNIQUE (name),
+        FOREIGN KEY(capacity_id) REFERENCES capacity (id),
+        CHECK (control IN (0, 1))
+);
+CREATE TABLE switch_port (
+        id INTEGER NOT NULL,
+        port INTEGER,
+        vlan INTEGER,
+        switch_id INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(switch_id) REFERENCES switch_vde (id)
+);
+CREATE TABLE interface (
+        id INTEGER NOT NULL,
+        address VARCHAR(50),
+        mask VARCHAR(15),
+        bcast VARCHAR(15),
+        name VARCHAR(16),
+        mac VARCHAR(17),
+        capacity_id INTEGER,
+        tap BOOLEAN,
+        tun BOOLEAN,
+        computer_id INTEGER,
+        switch_port_id INTEGER,
+        substrate_id INTEGER,
+        PRIMARY KEY (id),
+        UNIQUE (address),
+        UNIQUE (mac),
+        FOREIGN KEY(capacity_id) REFERENCES capacity (id),
+        CHECK (tap IN (0, 1)),
+        CHECK (tun IN (0, 1)),
+        FOREIGN KEY(computer_id) REFERENCES computer (id),
+        FOREIGN KEY(switch_port_id) REFERENCES switch_port (id),
+        FOREIGN KEY(substrate_id) REFERENCES substrate (id)
+);
+CREATE TABLE route (
+        id INTEGER NOT NULL,
+        default_route VARCHAR(18),
+        default_dest VARCHAR(18),
+        extra_route VARCHAR(18),
+        interface_id INTEGER,
+        PRIMARY KEY (id),
+        FOREIGN KEY(interface_id) REFERENCES interface (id)
+);
+}}}
 == Config request path ==