diff options
| author | Adam Frisby | 2007-07-11 08:10:25 +0000 |
|---|---|---|
| committer | Adam Frisby | 2007-07-11 08:10:25 +0000 |
| commit | e2ff441e31328e60c8bb1d4bb32fa4ac64f91978 (patch) | |
| tree | 8405b6cef57b66a58f31a24c859846085d0b81f7 /share/sql/mysql-reservations.txt | |
| parent | * Wiping trunk in prep for Sugilite (diff) | |
| parent | * Applying dalien's patches from bug#177 and #179 (diff) | |
| download | opensim-SC-e2ff441e31328e60c8bb1d4bb32fa4ac64f91978.zip opensim-SC-e2ff441e31328e60c8bb1d4bb32fa4ac64f91978.tar.gz opensim-SC-e2ff441e31328e60c8bb1d4bb32fa4ac64f91978.tar.bz2 opensim-SC-e2ff441e31328e60c8bb1d4bb32fa4ac64f91978.tar.xz | |
* Bringing Sugilite in to trunk
Diffstat (limited to '')
| -rw-r--r-- | share/sql/mysql-reservations.txt | 16 |
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 @@ | |||
| 1 | CREATE 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 ; | ||