1 files changed, 16 insertions, 0 deletions

diff --git a/share/sql/mysql-reservations.txt b/share/sql/mysql-reservations.txt
new file mode 100644
index 0000000..d6d84b9
--- /dev/null
+++ b/share/sql/mysql-reservations.txt
@@ -0,0 +1,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 ;