From f9292c31284641f74ef5524af91afa7238e597d7 Mon Sep 17 00:00:00 2001
From: mingchen
Date: Wed, 27 Jun 2007 01:49:27 +0000
Subject: *Added mysql-reservations.txt with table layout for reservations in
 /share/sql/

---
 share/sql/mysql-reservations.txt | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 share/sql/mysql-reservations.txt

(limited to 'share/sql')

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 ;
-- 
cgit v1.1