aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-reservations.txt
blob: d6d84b9af85cb0d5cb6f5a285d539cb63d5e17aa (plain)
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 ;