aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mysql-reservations.txt
diff options
context:
space:
mode:
authormingchen2007-06-27 01:49:27 +0000
committermingchen2007-06-27 01:49:27 +0000
commitf9292c31284641f74ef5524af91afa7238e597d7 (patch)
tree667c123af312eef81df3650bb7312f5e88498581 /share/sql/mysql-reservations.txt
parent*Added support for reservations in OpenGridServices (mysql only for now) (diff)
downloadopensim-SC_OLD-f9292c31284641f74ef5524af91afa7238e597d7.zip
opensim-SC_OLD-f9292c31284641f74ef5524af91afa7238e597d7.tar.gz
opensim-SC_OLD-f9292c31284641f74ef5524af91afa7238e597d7.tar.bz2
opensim-SC_OLD-f9292c31284641f74ef5524af91afa7238e597d7.tar.xz
*Added mysql-reservations.txt with table layout for reservations in /share/sql/
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 ;