aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-reservations.txt
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--share/sql/mysql-reservations.txt32
1 files changed, 16 insertions, 16 deletions
diff --git a/share/sql/mysql-reservations.txt b/share/sql/mysql-reservations.txt
index d6d84b9..9dab31d 100644
--- a/share/sql/mysql-reservations.txt
+++ b/share/sql/mysql-reservations.txt
@@ -1,16 +1,16 @@
1CREATE TABLE `reservations` ( 1CREATE TABLE `reservations` (
2 `resID` int(10) unsigned NOT NULL auto_increment, 2 `resID` int(10) unsigned NOT NULL auto_increment,
3 `userUUID` varchar(36) default NULL, 3 `userUUID` varchar(36) default NULL,
4 `gridSendKey` varchar(64) default NULL, 4 `gridSendKey` varchar(64) default NULL,
5 `gridRecvKey` varchar(64) default NULL, 5 `gridRecvKey` varchar(64) default NULL,
6 `resName` varchar(255) default NULL, 6 `resName` varchar(255) default NULL,
7 `resCompany` varchar(128) default NULL, 7 `resCompany` varchar(128) default NULL,
8 `resXMin` int(10) unsigned default NULL, 8 `resXMin` int(10) unsigned default NULL,
9 `resXMax` int(10) unsigned default NULL, 9 `resXMax` int(10) unsigned default NULL,
10 `resYMin` int(10) unsigned default NULL, 10 `resYMin` int(10) unsigned default NULL,
11 `resYMax` int(10) unsigned default NULL, 11 `resYMax` int(10) unsigned default NULL,
12 `status` int(10) unsigned default NULL, 12 `status` int(10) unsigned default NULL,
13 PRIMARY KEY (`resID`), 13 PRIMARY KEY (`resID`),
14 KEY `resident` (`userUUID`), 14 KEY `resident` (`userUUID`),
15 KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`) 15 KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; 16) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;