From 646bbbc84b8010e0dacbeed5342cdb045f46cc49 Mon Sep 17 00:00:00 2001
From: MW
Date: Wed, 27 Jun 2007 15:28:52 +0000
Subject: Some work on restructuring the namespaces / project names. Note this
 doesn't compile yet as not all the code has been changed to use the new
 namespaces. Am committing it now for feedback on the namespaces.

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

(limited to 'share/sql/mysql-reservations.txt')

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