diff options
| author | mingchen | 2007-06-27 01:49:27 +0000 |
|---|---|---|
| committer | mingchen | 2007-06-27 01:49:27 +0000 |
| commit | f9292c31284641f74ef5524af91afa7238e597d7 (patch) | |
| tree | 667c123af312eef81df3650bb7312f5e88498581 /share/sql | |
| parent | *Added support for reservations in OpenGridServices (mysql only for now) (diff) | |
| download | opensim-SC-f9292c31284641f74ef5524af91afa7238e597d7.zip opensim-SC-f9292c31284641f74ef5524af91afa7238e597d7.tar.gz opensim-SC-f9292c31284641f74ef5524af91afa7238e597d7.tar.bz2 opensim-SC-f9292c31284641f74ef5524af91afa7238e597d7.tar.xz | |
*Added mysql-reservations.txt with table layout for reservations in /share/sql/
Diffstat (limited to 'share/sql')
| -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 ; | ||