1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
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 ;
|
