 #
 
 CREATE TABLE interface_types (
-  type enum('fxp','cs') NOT NULL default 'fxp',
+  type enum('fxp','cs','cisco_supervisor','dc','xl','cisco_ip') NOT NULL default 'fxp',
   max_speed int(11) default NULL,
   full_duplex tinyint(1) default NULL,
   manufacturuer varchar(30) default NULL,
   model varchar(30) default NULL,
   ports tinyint(4) default NULL,
-  connector enum('RJ45') default NULL,
+  connector enum('RJ45','SC') default NULL,
   PRIMARY KEY  (type)
 ) TYPE=MyISAM;
 

  unix_gid smallint(5) unsigned NOT NULL auto_increment,
  approved tinyint(4) default '0',
  public tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY unix_gid (unix_gid)
) TYPE=MyISAM;

#
# Table structure for table 'reloads'
#

CREATE TABLE reloads (
  node_id varchar(10) NOT NULL default '',
  image_id varchar(30) NOT NULL default '',
  PRIMARY KEY  (node_id)
) TYPE=MyISAM;

#
# Table structure for table 'reserved'
#


  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;

