aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-reservations.txt
diff options
context:
space:
mode:
authorMW2007-06-27 15:28:52 +0000
committerMW2007-06-27 15:28:52 +0000
commit646bbbc84b8010e0dacbeed5342cdb045f46cc49 (patch)
tree770b34d19855363c3c113ab9a0af9a56d821d887 /share/sql/mysql-reservations.txt
downloadopensim-SC_OLD-646bbbc84b8010e0dacbeed5342cdb045f46cc49.zip
opensim-SC_OLD-646bbbc84b8010e0dacbeed5342cdb045f46cc49.tar.gz
opensim-SC_OLD-646bbbc84b8010e0dacbeed5342cdb045f46cc49.tar.bz2
opensim-SC_OLD-646bbbc84b8010e0dacbeed5342cdb045f46cc49.tar.xz
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.
Diffstat (limited to 'share/sql/mysql-reservations.txt')
-rw-r--r--share/sql/mysql-reservations.txt16
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 @@
1CREATE TABLE `reservations` (
2 `resID` int(10) unsigned NOT NULL auto_increment,
3 `userUUID` varchar(36) default NULL,
4 `gridSendKey` varchar(64) default NULL,
5 `gridRecvKey` varchar(64) default NULL,
6 `resName` varchar(255) default NULL,
7 `resCompany` varchar(128) default NULL,
8 `resXMin` int(10) unsigned default NULL,
9 `resXMax` int(10) unsigned default NULL,
10 `resYMin` int(10) unsigned default NULL,
11 `resYMax` int(10) unsigned default NULL,
12 `status` int(10) unsigned default NULL,
13 PRIMARY KEY (`resID`),
14 KEY `resident` (`userUUID`),
15 KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;