   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)
+  PRIMARY KEY  (node_id,tstamp,mac),
+  KEY macindex (mac),
+  KEY node_idindex (node_id)
 ) TYPE=MyISAM;
 
 #

  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)
) 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;

#
