   iface text,
   current_speed enum('100','10','1000') NOT NULL default '100',
   duplex enum('full','half') NOT NULL default 'full',
-  PRIMARY KEY  (node_id,card,port)
+  PRIMARY KEY  (node_id,card,port),
+  KEY mac (mac)
 ) TYPE=MyISAM;
 
 #

  mac varchar(12) NOT NULL default '0',
  ipkts int(11) NOT NULL default '0',
  opkts int(11) NOT NULL default '0',
  PRIMARY KEY  (node_id,tstamp,mac)
) TYPE=MyISAM;

#

  rdelay float(10,2) default NULL,
  rbandwidth int(10) unsigned default NULL,
  rlossrate float(10,3) default NULL,
  cost float NOT NULL default '1',
  widearea tinyint(4) default '0'
) TYPE=MyISAM;

#
