diff options
Diffstat (limited to 'share/sql/mysql-reservations.txt')
-rw-r--r-- | share/sql/mysql-reservations.txt | 32 |
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 @@ | |||
1 | CREATE TABLE `reservations` ( | 1 | CREATE 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 ; |