File contents

<?xml version="1.0" ?>
<!-- WWWSQLEditor XML export -->
<sql>
	<table id="0" title="person" x="42" y="137" >
		<row id="0" pk="pk" index="index" nn="nn">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" special="63">
			<title>first</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="2" special="31">
			<title>middle</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="3" special="63">
			<title>last</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="4" special="127">
			<title>email</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="9" nn="nn" special="255">
			<title>website</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="5" special="10">
			<title>phone</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="6" special="10">
			<title>phone2</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="7" special="10">
			<title>fax</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="8" special="10">
			<title>fax2</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="10" fk="fk" index="index">
			<title>location_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="11" fk="fk" index="index">
			<title>location_id2</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="16" special="255">
			<title>hours</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="17" nn="nn" special="'M','F','U'">
			<title>sex</title>
			<default>'U'</default>
			<type>Enum</type>
		</row>
		<row id="18" nn="nn" special="'citizen','workvisa','unknown'">
			<title>citizenship</title>
			<default>'unknown'</default>
			<type>Enum</type>
		</row>
		<row id="19" nn="nn" special="31">
			<title>campusid</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="21" nn="nn">
			<title>dob</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="22" nn="nn">
			<title>aup</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="20">
			<title>notes</title>
			<default></default>
			<type>Text</type>
		</row>
		<row id="14" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="15" nn="nn">
			<title>modified</title>
			<default>CURRENT_TIMESTAMP on update </default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="1" title="group" x="1209" y="364" >
		<row id="0" pk="pk" index="index" nn="nn">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="3" nn="nn">
			<title>gid</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn" special="32">
			<title>name</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="2" special="32">
			<title>description</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="4" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="5" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="2" title="people_groups" x="805" y="308" >
		<row id="0" fk="fk" index="index">
			<title>person_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" fk="fk" index="index">
			<title>group_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="2" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="3" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="3" title="affiliation" x="561" y="137" >
		<row id="0" fk="fk" index="index">
			<title>person_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" fk="fk" index="index">
			<title>entity_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="2" nn="nn" special="'yes','no'">
			<title>active</title>
			<default>'no'</default>
			<type>Enum</type>
		</row>
		<row id="3" nn="nn" special="'staff','member','faculty','director','grad','postgrad','projsci','undergrad','visitor','other'">
			<title>type</title>
			<default>'other'</default>
			<type>Enum</type>
		</row>
		<row id="6" nn="nn">
			<title>notes</title>
			<default></default>
			<type>Text</type>
		</row>
		<row id="4" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="5" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="4" title="entity" x="1025" y="160" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn" special="">
			<title>type</title>
			<default>'other'</default>
			<type>Enum</type>
		</row>
		<row id="2" nn="nn" special="31">
			<title>short_name</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="3" nn="nn" special="255">
			<title>long_name</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="4" nn="nn" special="255">
			<title>website</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="5" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="6" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="5" title="user_groups" x="822" y="446" >
		<row id="0" fk="fk" index="index">
			<title>group_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="3" fk="fk" index="index">
			<title>user_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="2" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="6" title="user" x="269" y="361" >
		<row id="0" pk="pk" index="index" special="31">
			<title>uid</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="2" fk="fk" index="index">
			<title>person_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn" special="34">
			<title>password</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="5" nn="nn">
			<title>publickey</title>
			<default></default>
			<type>BLOB</type>
		</row>
		<row id="6" nn="nn" special="'yes','no'">
			<title>active</title>
			<default>'yes'</default>
			<type>Enum</type>
		</row>
		<row id="3" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="4" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="8" title="machine" x="259" y="571" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="3" fk="fk" index="index">
			<title>location_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="4" nn="nn">
			<title>notes</title>
			<default></default>
			<type>Text</type>
		</row>
		<row id="5" nn="nn">
			<title>hostkey_dsa</title>
			<default></default>
			<type>BLOB</type>
		</row>
		<row id="6" nn="nn">
			<title>hostkey_rsa</title>
			<default></default>
			<type>BLOB</type>
		</row>
		<row id="7" nn="nn">
			<title>hostkey_rsa1</title>
			<default></default>
			<type>BLOB</type>
		</row>
		<row id="8" nn="nn" special="'x86_64','x86','ia64','sparc','other'">
			<title>arch</title>
			<default></default>
			<type>Enum</type>
		</row>
		<row id="1" nn="nn">
			<title>notes</title>
			<default></default>
			<type>Text</type>
		</row>
		<row id="9" nn="nn">
			<title>cpu_count</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="10" nn="nn">
			<title>ram</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="11" nn="nn">
			<title>cpu_speed</title>
			<default>0</default>
			<type>Double precision</type>
		</row>
		<row id="13" nn="nn" special="">
			<title>os_major</title>
			<default>'other'</default>
			<type>Enum</type>
		</row>
		<row id="14" special="31">
			<title>os_minor</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="15" nn="nn">
			<title>patched</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="2" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="12" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="9" title="IP" x="823" y="578" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" fk="fk" index="index">
			<title>mac_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="5" nn="nn">
			<title>octet1</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="6" nn="nn">
			<title>octet2</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="7" nn="nn">
			<title>octet3</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="8" nn="nn">
			<title>octet4</title>
			<default>0</default>
			<type>Double precision</type>
		</row>
		<row id="9" nn="nn" special="63">
			<title>hostname</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="10" nn="nn" special="255">
			<title>domain</title>
			<default>cse.ucdavis.edu</default>
			<type>String</type>
		</row>
		<row id="11" nn="nn" special="63">
			<title>mx</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="12" nn="nn" special="255">
			<title>cname</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="13" nn="nn">
			<title>bitmask</title>
			<default>25</default>
			<type>Integer</type>
		</row>
		<row id="14" nn="nn" special="'fixed','static','dynamic'">
			<title>type</title>
			<default>'fixed'</default>
			<type>Enum</type>
		</row>
		<row id="15" nn="nn" special="255">
			<title>comment</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="4" nn="nn">
			<title>last_seen</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="2" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="3" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="10" title="machine_users" x="492" y="517" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" fk="fk" index="index">
			<title>user_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="2" fk="fk" index="index">
			<title>machine_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="3" nn="nn">
			<title>admin</title>
			<default>0</default>
			<type>Double precision</type>
		</row>
		<row id="4" nn="nn">
			<title>ownership_ack</title>
			<default>1900-01-01</default>
			<type>Date</type>
		</row>
		<row id="5" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="6" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="11" title="mac" x="491" y="751" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="2" fk="fk" index="index">
			<title>machine_id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn" special="17">
			<title>mac</title>
			<default>'00:00:00:00:00:00'</default>
			<type>String</type>
		</row>
		<row id="3" nn="nn" special="'yes','no'">
			<title>primary</title>
			<default>'yes'</default>
			<type>Enum</type>
		</row>
		<row id="4" nn="nn" special="'yes','no'">
			<title>active</title>
			<default>'yes'</default>
			<type>Enum</type>
		</row>
		<row id="5" nn="nn">
			<title>last_seen</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="6" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="7" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<table id="12" title="location" x="54" y="696" >
		<row id="0" pk="pk" index="index">
			<title>id</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="1" nn="nn" special="127">
			<title>building</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="4" nn="nn" special="63">
			<title>room</title>
			<default></default>
			<type>String</type>
		</row>
		<row id="2" nn="nn">
			<title>longitude</title>
			<default>0</default>
			<type>Double precision</type>
		</row>
		<row id="3" nn="nn">
			<title>latitude</title>
			<default>0</default>
			<type>Double precision</type>
		</row>
		<row id="5" nn="nn">
			<title>rack</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="6" nn="nn">
			<title>unit</title>
			<default>0</default>
			<type>Integer</type>
		</row>
		<row id="8" nn="nn">
			<title>notes</title>
			<default></default>
			<type>Text</type>
		</row>
		<row id="7" nn="nn">
			<title>created</title>
			<default>1900-01-01 00:00:00</default>
			<type>Datetime</type>
		</row>
		<row id="9" nn="nn">
			<title>modified</title>
			<default>0</default>
			<type>Timestamp</type>
		</row>
	</table>
	<relation>
		<table_1>0</table_1>
		<row_1>0</row_1>
		<table_2>2</table_2>
		<row_2>0</row_2>
	</relation>
	<relation>
		<table_1>1</table_1>
		<row_1>0</row_1>
		<table_2>2</table_2>
		<row_2>1</row_2>
	</relation>
	<relation>
		<table_1>4</table_1>
		<row_1>0</row_1>
		<table_2>3</table_2>
		<row_2>1</row_2>
	</relation>
	<relation>
		<table_1>0</table_1>
		<row_1>0</row_1>
		<table_2>3</table_2>
		<row_2>0</row_2>
	</relation>
	<relation>
		<table_1>1</table_1>
		<row_1>0</row_1>
		<table_2>5</table_2>
		<row_2>0</row_2>
	</relation>
	<relation>
		<table_1>0</table_1>
		<row_1>0</row_1>
		<table_2>6</table_2>
		<row_2>2</row_2>
	</relation>
	<relation>
		<table_1>6</table_1>
		<row_1>0</row_1>
		<table_2>5</table_2>
		<row_2>3</row_2>
	</relation>
	<relation>
		<table_1>12</table_1>
		<row_1>0</row_1>
		<table_2>0</table_2>
		<row_2>10</row_2>
	</relation>
	<relation>
		<table_1>12</table_1>
		<row_1>0</row_1>
		<table_2>0</table_2>
		<row_2>11</row_2>
	</relation>
	<relation>
		<table_1>6</table_1>
		<row_1>0</row_1>
		<table_2>10</table_2>
		<row_2>1</row_2>
	</relation>
	<relation>
		<table_1>8</table_1>
		<row_1>0</row_1>
		<table_2>10</table_2>
		<row_2>2</row_2>
	</relation>
	<relation>
		<table_1>11</table_1>
		<row_1>0</row_1>
		<table_2>9</table_2>
		<row_2>1</row_2>
	</relation>
	<relation>
		<table_1>8</table_1>
		<row_1>0</row_1>
		<table_2>11</table_2>
		<row_2>2</row_2>
	</relation>
	<relation>
		<table_1>12</table_1>
		<row_1>0</row_1>
		<table_2>8</table_2>
		<row_2>3</row_2>
	</relation>
</sql>