CREATE TABLE `reservations` (
  `resID` int(10) unsigned NOT NULL auto_increment,
  `userUUID` varchar(36) default NULL,
  `gridSendKey` varchar(64) default NULL,
  `gridRecvKey` varchar(64) default NULL,
  `resName` varchar(255) default NULL,
  `resCompany` varchar(128) default NULL,
  `resXMin` int(10) unsigned default NULL,
  `resXMax` int(10) unsigned default NULL,
  `resYMin` int(10) unsigned default NULL,
  `resYMax` int(10) unsigned default NULL,
  `status` int(10) unsigned default NULL,
  PRIMARY KEY  (`resID`),
  KEY `resident` (`userUUID`),
  KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;