13 Oct 16:26
SF.net SVN: opennac: [272] website/pages
From: <grundsch@...>
Subject: SF.net SVN: opennac: [272] website/pages
Newsgroups: gmane.network.freenac.devel
Date: 2006-10-13 14:29:27 GMT
Subject: SF.net SVN: opennac: [272] website/pages
Newsgroups: gmane.network.freenac.devel
Date: 2006-10-13 14:29:27 GMT
Revision: 272
http://svn.sourceforge.net/opennac/?rev=272&view=rev
Author: grundsch
Date: 2006-10-13 07:28:57 -0700 (Fri, 13 Oct 2006)
Log Message:
-----------
added r2.1 schema documentation, and added information and links in the documentation.php page.
Modified Paths:
--------------
website/pages/documentation.php
Added Paths:
-----------
website/pages/schemadb_2.1/
website/pages/schemadb_2.1/Default.html
website/pages/schemadb_2.1/Img/
website/pages/schemadb_2.1/Img/ERD.png
website/pages/schemadb_2.1/Img/add.gif
website/pages/schemadb_2.1/Img/arrow_greenstyle.gif
website/pages/schemadb_2.1/Img/change.gif
website/pages/schemadb_2.1/Img/fBg.png
website/pages/schemadb_2.1/Img/green.jpg
website/pages/schemadb_2.1/Img/leftFrame.swf
website/pages/schemadb_2.1/Img/logo.gif
website/pages/schemadb_2.1/Img/remove.gif
website/pages/schemadb_2.1/Img/topFrame.swf
website/pages/schemadb_2.1/MImageB.html
website/pages/schemadb_2.1/Tables.html
website/pages/schemadb_2.1/TablesB.html
website/pages/schemadb_2.1/TablesR.html
website/pages/schemadb_2.1/TopFrame.html
website/pages/schemadb_2.1/classic_green.css
website/pages/schemadb_2.1/freenac.dm2
website/pages/schemadb_2.1/loadToFlash.xml
website/pages/schemadb_2.1/menuItems.xml
Modified: website/pages/documentation.php
===================================================================
--- website/pages/documentation.php 2006-10-13 13:39:43 UTC (rev 271)
+++ website/pages/documentation.php 2006-10-13 14:28:57 UTC (rev 272)
<at> <at> -1,100 +1,207 <at> <at>
-<?php
- include_once("../include/menu.php");
- $menu=new Menu("../texts/menu.txt");
-?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html>
-<head>
- <title>FreeNAC</title>
- <link rel="shortcut icon" href="/images/favicon.ico" type="image/x-icon" />
- <link href="../styles/styles.css" rel="stylesheet" type="text/css" /></head>
-<body leftmargin="0" topmargin="0" marginheight="0" marginwidth="0">
- <table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="80%">
- <tbody><tr>
- <td colspan="2" id="title" align="center"><div id="text"><img src="../images/logo_small.png"></div></td>
- </tr>
- <tr>
- <td colspan="2" id="line" height="2"></td>
- </tr>
- <tr>
- <td colspan="2" id="bar" height="6"></td>
- </tr>
- <tr>
- <td colspan="2" id="line" height="1"></td>
- </tr>
- <tr height="200">
- <td id="rightborder" bgcolor="#d0d0d0" height="200" valign="top" width="15%">
- <!-- MENU HERE -->
- <?php $menu->Show(); ?>
- </td>
- <td rowspan="2" valign="top"><div id="text">
-
- <h2>Documentation</h2>
- <p>Please start with the <a href="overview.php">Overview</a> page, the appropriate section below and consult the forum.<br>
- <div align="justify">
-
- <h3>for Users</h3>
- <div align="justify">
- <ul><a href="https://lists.sourceforge.net/lists/listinfo/opennac-announce">Subscribe to our announcements list</a><br>
- <h4>Screenshots (Windows GUI):</h4>
- <div align="justify">
- <ul>
- <a href="../images/overview.gif">Overview</a>, <a href="../images/edit.gif">Edit</a>,
- <a href="../images/switches.gif">Switches</a>, <a href="../images/ports.gif">Ports</a>,
- <a href="../images/patchcables.gif">Patch Cables</a>,<br>
- <a href="../images/users.gif">Users</a>,
- <a href="../images/vlans.gif">VLANs</a>, <a href="../images/lookups.gif">Lookups</a>,
- <a href="../images/ChangeHistory.gif">Change History Log</a><br>
- </ul>
- </div>
- <p>Video: <a href="../videos/index.html">Windows GUI (swf format 8 Mb)</a></ul>
-
- </ul>
- </div>
- <h3>System Administrators</h3>
- <div align="justify">
- <ul>
- <a href="../pdfs/architect.view.pdf">Architecture</a><br>
- <a href="../images/db_schema_v2.png">Database schema: version 2.1</a><br>
- <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/nac_components.txt?view=markup">NAC Server components</a>
-
- <p>Installation documentation:<br>
- - If you wish to try the Virtual machine, visit the <a href="download.php">download page</a><br>
- - FreeNAC: <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/unix_install.txt?view=markup">unix_install.txt</a> and <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/master_server_install.txt?view=markup">master_server_install.txt</a><br>
- - Configuring network
- <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/cisco_switch.txt?view=markup">Switches</a>,
- <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/sw_config_catos.txt?view=markup">CATOS</a>
- or <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/sw_config_ios.txt?view=markup">IOS</a><br>
- - Install the <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/WindowsGUI/README.WinGUI.txt?view=markup">Windows GUI</a><br>
- <p>Problems? See <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/troubleshooting.txt?view=markup">troubleshooting.txt</a> and visit the forum.
- </ul>
- </div>
-
- <h3>Developers</h3>
- <div align="justify">
- <ul><a href="../pdfs/algorithms.pdf">Algorithms</a><br>
- <a href="../pdfs/TNC_Summary.pdf">Future architecture discussion: TNC Summary</a><br>
- <a href="http://svn.sourceforge.net/viewvc/opennac/">Browse the subversion repository</a>
- <pre>To get the sources: "svn co https://svn.sourceforge.net/svnroot/opennac/trunk"</pre>
- <a href="https://lists.sourceforge.net/lists/listinfo/opennac-devel">Join our developers mailing list</a>
- <p>Browse the <a href="http://dir.gmane.org/gmane.network.freenac.devel">developers mailing list archive on gmane</a>
- </ul>
- </div>
-
-
- </div></td>
- </tr>
- <tr>
- <td id="rightborder" bgcolor="#d0d0d0" valign="top"> </td>
- </tr>
- <tr>
- <td colspan="2" id="line" height="1"></td>
- </tr>
- <tr>
- <td colspan="2" id="bar" align="center" height="8"><div id="tiny">\xA9 FreeNAC 2006</div></td>
- </tr>
- <tr>
- <td colspan="2" id="line" height="1"></td>
- </tr>
- </tbody></table>
-</body></html>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html>
+<head>
+
+<?php include_once("../include/menu.php");
+$menu=new Menu("../texts/menu.txt");
+?>
+ <title>FreeNAC</title>
+
+
+ <link rel="shortcut icon" href="/images/favicon.ico" type="image/x-icon" />
+
+ <link href="../styles/styles.css" rel="stylesheet" type="text/css" />
+
+</head>
+
+
+
+<body leftmargin="0" topmargin="0" marginheight="0" marginwidth="0">
+
+<table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="80%">
+
+ <tbody>
+
+ <tr>
+
+ <td colspan="2" id="title" align="center">
+ <div id="text"><img src="../images/logo_small.png" /></div>
+
+ </td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="line" height="2"></td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="bar" height="6"></td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="line" height="1"></td>
+
+ </tr>
+
+ <tr height="200">
+
+ <td id="rightborder" bgcolor="#d0d0d0" height="200" valign="top" width="15%"><!-- MENU HERE --><?php $menu->Show(); ?>
+ </td>
+
+ <td rowspan="2" valign="top">
+ <div id="text">
+ <h2>Documentation</h2>
+
+ <p>Please start with the <a href="overview.php">Overview</a>
+page, the appropriate section below and consult the forum.<br />
+
+ </p>
+
+ <div align="justify">
+ <h3>for Users</h3>
+
+ <div align="justify">
+ <ul>
+
+ <a href="https://lists.sourceforge.net/lists/listinfo/opennac-announce">Subscribe
+to our announcements list</a><br />
+
+ <h4>Screenshots (Windows GUI):</h4>
+
+ <div align="justify">
+ <ul>
+
+ <a href="../images/overview.gif">Overview</a>,
+ <a href="../images/edit.gif">Edit</a>, <a href="../images/switches.gif">Switches</a>, <a href="../images/ports.gif">Ports</a>, <a href="../images/patchcables.gif">Patch Cables</a>,<br />
+
+ <a href="../images/users.gif">Users</a>, <a href="../images/vlans.gif">VLANs</a>, <a href="../images/lookups.gif">Lookups</a>, <a href="../images/ChangeHistory.gif">Change History Log</a><br />
+
+ </ul>
+
+ </div>
+
+ <p>Video: <a href="../videos/index.html">Windows
+GUI (swf format 8 Mb)</a></p>
+
+ </ul>
+
+ </div>
+
+ <h3>System Administrators</h3>
+
+ <div align="justify">
+ <ul>
+
+ <a href="../pdfs/architect.view.pdf">Architecture</a><br />
+
+ <br />
+
+ <a target="_blank" href="schemadb_2.1/Default.html">Database
+schema: version 2.1</a><span style="font-style: italic;">
+(new diagram) </span>All attributes are documented, including
+references (note: the schema is not normalised, and there's lot of
+improvement possibilities. See the <a href="/phpBB2/viewtopic.php?t=14">thread</a>
+in the dev forum.)<br />
+
+For those who are interested, we have made these diagrams with a nice
+tool, Case Studio, now named Toad Data Modeler. They have a <a target="_blank" href="http://www.casestudio.com/enu/database_design_freeware.aspx">free
+version</a>
+too. Here's the link to the <a href="schemadb_2.1/freenac.dm2">Case
+Studio file</a>.<br />
+
+ <br />
+
+ <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/nac_components.txt?view=markup">NAC
+Server components</a>
+ <p>Installation documentation:<br />
+
+- If you wish to try the Virtual machine, visit the <a href="download.php">download page</a><br />
+
+- FreeNAC: <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/unix_install.txt?view=markup">unix_install.txt</a>
+and <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/master_server_install.txt?view=markup">master_server_install.txt</a><br />
+
+- Configuring network <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/cisco_switch.txt?view=markup">Switches</a>,
+ <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/sw_config_catos.txt?view=markup">CATOS</a>
+or <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/sw_config_ios.txt?view=markup">IOS</a><br />
+
+- Install the <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/WindowsGUI/README.WinGUI.txt?view=markup">Windows
+GUI</a><br />
+
+ </p>
+
+ <p>Problems? See <a href="http://svn.sourceforge.net/viewvc/opennac/trunk/doc/troubleshooting.txt?view=markup">troubleshooting.txt</a>
+and visit the forum. </p>
+
+ </ul>
+
+ </div>
+
+ <h3>Developers</h3>
+
+ <div align="justify">
+ <ul>
+
+ <a href="../pdfs/algorithms.pdf">Algorithms</a><br />
+
+ <a href="../pdfs/TNC_Summary.pdf">Future
+architecture discussion: TNC Summary</a><br />
+
+ <a href="http://svn.sourceforge.net/viewvc/opennac/">Browse
+the subversion repository</a>
+ <pre>To get the sources: "svn co https://svn.sourceforge.net/svnroot/opennac/trunk"</pre>
+
+ <a href="https://lists.sourceforge.net/lists/listinfo/opennac-devel">Join
+our developers mailing list</a>
+ <p>Browse the <a href="http://dir.gmane.org/gmane.network.freenac.devel">developers
+mailing list archive on gmane</a> </p>
+
+ </ul>
+
+ </div>
+
+ </div>
+
+ </div>
+
+ </td>
+
+ </tr>
+
+ <tr>
+
+ <td id="rightborder" bgcolor="#d0d0d0" valign="top"> </td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="line" height="1"></td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="bar" align="center" height="8">
+ <div id="tiny">© FreeNAC 2006</div>
+
+ </td>
+
+ </tr>
+
+ <tr>
+
+ <td colspan="2" id="line" height="1"></td>
+
+ </tr>
+
+ </tbody>
+</table>
+
+</body>
+</html>
Added: website/pages/schemadb_2.1/Default.html
===================================================================
--- website/pages/schemadb_2.1/Default.html (rev 0)
+++ website/pages/schemadb_2.1/Default.html 2006-10-13 14:28:57 UTC (rev 272)
<at> <at> -0,0 +1,21 <at> <at>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+
+<html>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+ <meta name="keywords" content="CS2REP">
+ <meta name="author" content="CHARONWARE - www.casestudio.com">
+
+ <title>CASE Studio 2 - HTML Report</title>
+
+ <link rel="stylesheet" type="text/css" media="screen" href="classic_green.css" title="report">
+ <link rel="stylesheet" type="text/css" media="print" href="classic_green_print.css" title="report">
+ </head>
+
+ <frameset rows="76,*" border="0">
+ <frame src = "TopFrame.html" name="menu" scrolling="no" frameborder="0" marginheight="0" marginwidth="0">
+ <frame src = "MImageB.html" name="mainBody" scrolling="auto" frameborder="0" marginheight="0" marginwidth="0">
+ </frameset>
+
+ <noframes>Frames not supported</noframes>
+</html>
Added: website/pages/schemadb_2.1/Img/ERD.png
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/ERD.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/add.gif
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/add.gif
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/arrow_greenstyle.gif
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/arrow_greenstyle.gif
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/change.gif
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/change.gif
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/fBg.png
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/fBg.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/green.jpg
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/green.jpg
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/leftFrame.swf
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/leftFrame.swf
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/logo.gif
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/logo.gif
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/remove.gif
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/remove.gif
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/Img/topFrame.swf
===================================================================
(Binary files differ)
Property changes on: website/pages/schemadb_2.1/Img/topFrame.swf
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Added: website/pages/schemadb_2.1/MImageB.html
===================================================================
--- website/pages/schemadb_2.1/MImageB.html (rev 0)
+++ website/pages/schemadb_2.1/MImageB.html 2006-10-13 14:28:57 UTC (rev 272)
<at> <at> -0,0 +1,20 <at> <at>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+
+<html>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+ <meta name="keywords" content="CS2REP">
+ <meta name="author" content="CHARONWARE - www.casestudio.com">
+
+ <title>CASE Studio 2 - HTML Report</title>
+
+ <link rel="stylesheet" type="text/css" media="screen" href="classic_green.css" title="report">
+ <link rel="stylesheet" type="text/css" media="print" href="classic_green_print.css" title="report">
+ </head>
+
+<body class="rightPage">
+ <br><br>
+<p align="center">
+<img src="Img/ERD.png" alt="FreeNAC">
+</p>
+</body></html>
Added: website/pages/schemadb_2.1/Tables.html
===================================================================
--- website/pages/schemadb_2.1/Tables.html (rev 0)
+++ website/pages/schemadb_2.1/Tables.html 2006-10-13 14:28:57 UTC (rev 272)
<at> <at> -0,0 +1,13 <at> <at>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
+<html>
+ <head>
+ <title>CASE Studio 2 HTML report</title>
+ </head>
+
+ <frameset cols="25%,*" border="0">
+ <frame src = "TablesR.html" name="references" scrolling="auto" frameborder="0" marginheight="0" marginwidth="0">
+ <frame src = "TablesB.html" name="body" scrolling="yes" frameborder="0" marginheight="0" marginwidth="0">
+ </frameset>
+ <noframes>Frames not supported</noframes>
+</html>
+
Added: website/pages/schemadb_2.1/TablesB.html
===================================================================
--- website/pages/schemadb_2.1/TablesB.html (rev 0)
+++ website/pages/schemadb_2.1/TablesB.html 2006-10-13 14:28:57 UTC (rev 272)
<at> <at> -0,0 +1,1200 <at> <at>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+
+<html>
+ <head>
+ <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+ <meta name="keywords" content="CS2REP">
+ <meta name="author" content="CHARONWARE - www.casestudio.com">
+
+ <title>CASE Studio 2 - HTML Report</title>
+
+ <link rel="stylesheet" type="text/css" media="screen" href="classic_green.css" title="report">
+ <link rel="stylesheet" type="text/css" media="print" href="classic_green_print.css" title="report">
+ </head>
+
+<body class="rightPage">
+<a name = "Table_1"></a>
+<div class="caption1">ethernet</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > vendor </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (50) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > mac </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (6) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > Mapping of vendor Ethernet prefixes </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_2"></a>
+<div class="caption1">guirights</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > code </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> "0" </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > value </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > code_vmps_rights (code_vmps_rights) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > guirights </td> <td class="tabdata" > users </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > access rights, hard coded in the Windows GUI (client side enforcement) <br> 0, 'No access'<br> 1, 'Read Only'<br> 2, 'Can Edit'<br> 99, 'Super user' </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_3"></a>
+<div class="caption1">history</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > who </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > host </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > datetime </td> <td class="tabdata" > </td> <td class="tabdata" > Timestamp </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > priority </td> <td class="tabdata" > </td> <td class="tabdata" > Enum </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> "info" </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > what </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (200) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > User history (GUI generated), showing who did what. </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_4"></a>
+<div class="caption1">nac_hostscanned</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > mac </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (15) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> "NULL" </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > ip </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (15) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > hostname </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (80) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> reverse lookup made by nmap </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > os </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (80) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> as detected by nmap os fingerprinting </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > timestamp </td> <td class="tabdata" > </td> <td class="tabdata" > Datetime </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > id_host (id_host) </td> <td class="tabdata" > Identifying </td> <td class="tabdata" > nac_hostscanned </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Alternative keys</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint name </td> <td class="tabhead" > Columns </td> </tr>
+ <tr>
+ <td class="tabdata" > id (id) </td> <td class="tabdata" > id </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_5"></a>
+<div class="caption1">nac_netsallowed</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > network </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Alternative keys</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint name </td> <td class="tabhead" > Columns </td> </tr>
+ <tr>
+ <td class="tabdata" > id (id) </td> <td class="tabdata" > id </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_6"></a>
+<div class="caption1">nac_openports</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > PFK </td> <td class="tabdata" > host </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > PFK </td> <td class="tabdata" > port </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > protocol </td> <td class="tabdata" > </td> <td class="tabdata" > Enum </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > banner </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (128) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > timestamp </td> <td class="tabdata" > </td> <td class="tabdata" > Datetime </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > id_host (id_host) </td> <td class="tabdata" > Identifying </td> <td class="tabdata" > nac_hostscanned </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > port_port (port_port) </td> <td class="tabdata" > Informative </td> <td class="tabdata" > nac_servicestcp </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > port_port (port_port) </td> <td class="tabdata" > Identifying </td> <td class="tabdata" > nac_servicesudp </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_7"></a>
+<div class="caption1">nac_servicestcp</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > port </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > service </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > description </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (128) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > port_port (port_port) </td> <td class="tabdata" > Informative </td> <td class="tabdata" > nac_servicestcp </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Alternative keys</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint name </td> <td class="tabhead" > Columns </td> </tr>
+ <tr>
+ <td class="tabdata" > port (port) </td> <td class="tabdata" > port </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_8"></a>
+<div class="caption1">nac_servicesudp</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" colspan="3"> Default </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > port </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > service </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > description </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (128) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > port_port (port_port) </td> <td class="tabdata" > Identifying </td> <td class="tabdata" > nac_servicesudp </td> <td class="tabdata" > nac_openports </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Alternative keys</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint name </td> <td class="tabhead" > Columns </td> </tr>
+ <tr>
+ <td class="tabdata" > port (port) </td> <td class="tabdata" > port </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_10"></a>
+<div class="caption1">patchcable</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > von_geb_sch </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> von_geb\xE4ude_schrank = from building wiring closet </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > von_he_dosen </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> von_HohenEinheit_dosen = from Unit socket, i.e coordinates of the socket in the rack </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > von_dose </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> von_dose = from socket: label of the office socket </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > von_office </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> von_office = from office: name of the office room </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > von_user </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> from user: name of the user this socket "belongs" to, reference to users.AssocNtAccount (not mandatory, think meeting rooms) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > nach_network </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (10) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> to_network: network type connected on this patch, i.e. dynamic (VMPS), internal phone (not ethernet), etc... </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > nach_switch </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> to switch: ip address of the switch connected to this patch (not mandatory, think of phone lines) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > nach_port </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> to port: name of the port on the switch where this patch is connected to (not mandatory, think phone lines) </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > nach_other </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> to other: if it's not connected to a switch, where then? (unstructured field) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > comment </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (255) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > lastchange </td> <td class="tabdata" > </td> <td class="tabdata" > Timestamp </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > visum </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> visum = signature: who (technician) made this patch </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > bis_wann </td> <td class="tabdata" > </td> <td class="tabdata" > Date </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> bis_wan = until when: until when is this patch needed (not mandatory, only for temporary patches) </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > Documentation of Patch cables from Office Sockets to Port Switches </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_25"></a>
+<div class="caption1">port</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PFK </td> <td class="tabdata" > switch </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, reference to switch.ip </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > name </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> port name, like 2/27 </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > location </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (15) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, currently office name where this port is patched to (no reference) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > comment </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (255) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > restart_now </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> flag used by /bin/cron_restart_port to restart a port via snmp </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > default_vlan </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> default vlan for this port for unknown mac </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > ip_switch (ip_switch) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > switch </td> <td class="tabdata" > port </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > switch/name_switch/port (switch/name_switch/port) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > port </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > switch/name_AuthSw/AuthPort (switch/name_AuthSw/AuthPort) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > port </td> <td class="tabdata" > vmpsauth </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_14"></a>
+<div class="caption1">switch</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > ip </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> management ip </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > name </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> hostname </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > location </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "Ber-Omu93" </td> <td class="tabdata" colspan="2"> free text, location (building/office, etc...) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > comment </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (50) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, but why "not null"? </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > swgroup </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> group switches together, GUI only (not used in logic) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > notify </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (200) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> list of email addresses to send notifications when a new system is detected on this switch </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > ip_switch (ip_switch) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > switch </td> <td class="tabdata" > port </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_15"></a>
+<div class="caption1">sys_class</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> Unique Number </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > value </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> Class lookup for systems </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > id_class (id_class) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_class </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > Device Types, like workstation, server, printer, etc...- </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_16"></a>
+<div class="caption1">sys_class2</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> Unique Number </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > value </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> Class lookup for systems </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > id_class2 (id_class2) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_class2 </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > a second enterprise specific classification </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_17"></a>
+<div class="caption1">sys_os</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> "0" </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > value </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> Operating System lookup for systems </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > id_os (id_os) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_os </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > Documented Operating system </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_23"></a>
+<div class="caption1">systems</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > mac </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > name </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "inoSFxx" </td> <td class="tabdata" colspan="2"> hostname </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > description </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, reference to users.AssocNtAccount </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > vlan </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> reference to the vlan.id of this system </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > status </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> vmps status: 0: inactive, 1:active, theoreticaly a reference to vstatus tables. Is a tinyint (vstatus.id is an integer) </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > switch </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, reference port.switch, updated by vmps_lastseen </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > port </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, reference to port.name, updated by vmps_lastseen </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > LastVlan </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, reference to vlan.value (updated by last_seen scripts) note: LastVlan is Varchar(15), not Varchar(30) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > LastSeen </td> <td class="tabdata" > </td> <td class="tabdata" > Datetime </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> updated by vmps_lastseen </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > class </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> reference to sys_class.id (documents workstation, server, webcam, etc...) </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > class2 </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> reference sys_class2.id, a second type of device classification (enterprise specific) </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > os </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> reference into the sys_os.id, which might index to "Windows XP" for example </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > os1 </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> additional comment, like "SP2" (not structured) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > os3 </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> text field containing a value found in microsofts SMS for this device </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > comment </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > ChangeDate </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > ChangeUser </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > building </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (15) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "Ber-Omu93" </td> <td class="tabdata" colspan="2"> free text area documenting the building (consistency issue) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > office </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (8) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text area documenting the office </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > history </td> <td class="tabdata" > </td> <td class="tabdata" > Text </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, used by admins to keep a history of changes/owners, etc... </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > os2 </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> not used currently, its a test field </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > r_ip </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> IP of system as seen by the router (from arp table on the router, populated by /bin/router_mac_ip cronjob) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > r_timestamp </td> <td class="tabdata" > </td> <td class="tabdata" > Datetime </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> timestamp when ip has been updated from cronjob </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > r_ping_timestamp </td> <td class="tabdata" > </td> <td class="tabdata" > Datetime </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> not yet used? </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > inventar </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (20) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> free text, inventory number </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > scannow </td> <td class="tabdata" > </td> <td class="tabdata" > Tinyint </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> flag requesting an nmap scan at the next occasion (used by '/bin/port_scan --scannow' cronjob) </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > switch/name_switch/port (switch/name_switch/port) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > port </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > id_class (id_class) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_class </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > id_class2 (id_class2) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_class2 </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > id_os (id_os) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > sys_os </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > AssocNtAccount_description (AssocNtAccount_description) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > users </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > id_vlan (id_vlan) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > vlan </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > value_LastVlan (value_LastVlan) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > vlan </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > id_status (id_status) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > vstatus </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > List of VMPS controlled computers </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_22"></a>
+<div class="caption1">users</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > AssocNtAccount </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > FK </td> <td class="tabdata" > vmps_rights </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> access rights, hard coded in the Windows GUI (client side enforcement) <br> 0, 'No access'<br> 1, 'Read Only'<br> 2, 'Can Edit'<br> 99, 'Super user' </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > LastSeenDirex </td> <td class="tabdata" > </td> <td class="tabdata" > Date </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> "0000-00-00" </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > Surname </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > GivenName </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > Department </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > rfc822mailbox </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > HouseIdentifier </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > PhysicalDeliveryOfficeName </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > TelephoneNumber </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > Mobile </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > manual_direx_sync </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> enterprise proprietary, synchronise user informations with external DB? </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > comment </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (200) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" colspan="3"> </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td> </tr>
+ <tr>
+ <td class="tabdata" > code_vmps_rights (code_vmps_rights) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > guirights </td> <td class="tabdata" > users </td> <td class="tabdata" > 1:N </td> </tr>
+ <tr>
+ <td class="tabdata" > AssocNtAccount_description (AssocNtAccount_description) </td> <td class="tabdata" > Non-identifying </td> <td class="tabdata" > users </td> <td class="tabdata" > systems </td> <td class="tabdata" > 1:N </td> </tr>
+</table>
+
+<div class="caption2">Description</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabdata" > Uuser details synchronised from Direx </td> </tr>
+</table>
+
+<div class="caption2">User-defined variables</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" width="50%"> Name </td> <td class="tabhead" width="50%"> Value </td> </tr>
+ <tr>
+ <td class="tabdata" > Temporary table </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > If not exists </td> <td class="tabdata" > No </td> </tr>
+ <tr>
+ <td class="tabdata" > Table type </td> <td class="tabdata" > MyISAM </td> </tr>
+ <tr>
+ <td class="tabdata" > Character Set </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Row Format </td> <td class="tabdata" > Dynamic </td> </tr>
+ <tr>
+ <td class="tabdata" > Collation </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Database Name </td> <td class="tabdata" > </td> </tr>
+ <tr>
+ <td class="tabdata" > Initial AUTO_INCREMENT </td> <td class="tabdata" > </td> </tr>
+</table>
+
+ <br><br>
+<a name = "Table_18"></a>
+<div class="caption1">vlan</div>
+<div class="caption2">Columns</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Key </td> <td class="tabhead" > Column name </td> <td class="tabhead" > Domain </td> <td class="tabhead" > Data type </td> <td class="tabhead" > Not null </td> <td class="tabhead" > Unique </td> <td class="tabhead" > Check </td> <td class="tabhead" > Default </td> <td class="tabhead" colspan="2"> Description </td> </tr>
+ <tr>
+ <td class="tabdata" > PK </td> <td class="tabdata" > id </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > "0" </td> <td class="tabdata" colspan="2"> vlan numerical value </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > value </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (30) </td> <td class="tabdata" > YES </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> short name, reported by vmpsd (instead of the numerical value) </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > vlan_description </td> <td class="tabdata" > </td> <td class="tabdata" > Varchar (100) </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> long name </td> </tr>
+ <tr>
+ <td class="tabdata" > </td> <td class="tabdata" > vlan_group </td> <td class="tabdata" > </td> <td class="tabdata" > Integer </td> <td class="tabdata" > NO </td> <td class="tabdata" > NO </td> <td class="tabdata" > </td> <td class="tabdata" > </td> <td class="tabdata" colspan="2"> used during hub detection and conflict, to find out if a new system can be authorised on an existing dynamic vlan instead of his prefered one. </td> </tr>
+</table>
+
+<div class="caption2">Relationships</div>
+<table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%">
+
+ <tr>
+ <td class="tabhead" > Constraint (relationship) name </td> <td class="tabhead" > Relationship type </td> <td class="tabhead" > Parent table </td> <td class="tabhead" > Child table </td> <td class="tabhead" > Card. </td>