   startstatus tinytext,
   ready tinyint(4) unsigned NOT NULL default '0',
   priority smallint(6) NOT NULL default '-1',
+  bootstatus enum('okay','failed','unknown') default 'unknown',
   status enum('up','possibly down','down','unpingable') default NULL,
+  failureaction enum('fatal','nonfatal','ignore') NOT NULL default 'fatal',
+  routertype enum('none','ospf','static') NOT NULL default 'none',
+  next_pxe_boot_path text,
+  bios_version varchar(64) default NULL,
+  PRIMARY KEY  (node_id)
+) TYPE=MyISAM;
+
+#
+# Table structure for table 'nodeuidlastlogin'
+#
+
+CREATE TABLE nodeuidlastlogin (
+  node_id varchar(10) NOT NULL default '',
+  uid varchar(10) NOT NULL default '',
+  date date default NULL,
+  time time default NULL,
   PRIMARY KEY  (node_id)
 ) TYPE=MyISAM;
 

) TYPE=MyISAM;

#
# Table structure for table 'node_types'
#

CREATE TABLE node_types (
  type enum('pc','shark','intel','cisco','APC') NOT NULL default 'pc',
  proc enum('PIII','StrongARM','Intel510','Cisco6509') default NULL,
  speed smallint(5) unsigned default NULL,
  RAM smallint(5) unsigned default NULL,
  HD float(10,2) default NULL,

  startupcmd tinytext,
  tarfiles text,
  vname varchar(32) NOT NULL default '',
  type enum('pc','shark','pc600','pc850','dnard','pc1500') default NULL,
  failureaction enum('fatal','nonfatal','ignore') NOT NULL default 'fatal',
  routertype enum('none','ospf','static') NOT NULL default 'none'
) TYPE=MyISAM;

#
