CREATE TABLE `nodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `machineID` varchar(255) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `purpose` varchar(255) DEFAULT NULL,
  `aceID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
engine=federated
connection='mysql://root@localhost/cs_production/state_machine_objs';