diff options
Diffstat (limited to '')
-rw-r--r-- | share/sql/mysql-inventoryfolders.sql | 18 | ||||
-rw-r--r-- | share/sql/mysql-inventoryitems.sql | 28 | ||||
-rw-r--r-- | share/sql/mysql-reservations.txt | 32 |
3 files changed, 39 insertions, 39 deletions
diff --git a/share/sql/mysql-inventoryfolders.sql b/share/sql/mysql-inventoryfolders.sql index c30239e..8704702 100644 --- a/share/sql/mysql-inventoryfolders.sql +++ b/share/sql/mysql-inventoryfolders.sql | |||
@@ -1,9 +1,9 @@ | |||
1 | CREATE TABLE `inventoryfolders` ( | 1 | CREATE TABLE `inventoryfolders` ( |
2 | `folderID` varchar(36) NOT NULL default '', | 2 | `folderID` varchar(36) NOT NULL default '', |
3 | `agentID` varchar(36) default NULL, | 3 | `agentID` varchar(36) default NULL, |
4 | `parentFolderID` varchar(36) default NULL, | 4 | `parentFolderID` varchar(36) default NULL, |
5 | `folderName` varchar(64) default NULL, | 5 | `folderName` varchar(64) default NULL, |
6 | PRIMARY KEY (`folderID`), | 6 | PRIMARY KEY (`folderID`), |
7 | KEY `owner` (`agentID`), | 7 | KEY `owner` (`agentID`), |
8 | KEY `parent` (`parentFolderID`) | 8 | KEY `parent` (`parentFolderID`) |
9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
diff --git a/share/sql/mysql-inventoryitems.sql b/share/sql/mysql-inventoryitems.sql index 6e90005..5e03b8d 100644 --- a/share/sql/mysql-inventoryitems.sql +++ b/share/sql/mysql-inventoryitems.sql | |||
@@ -1,14 +1,14 @@ | |||
1 | CREATE TABLE `inventoryitems` ( | 1 | CREATE TABLE `inventoryitems` ( |
2 | `inventoryID` varchar(36) NOT NULL default '', | 2 | `inventoryID` varchar(36) NOT NULL default '', |
3 | `assetID` varchar(36) default NULL, | 3 | `assetID` varchar(36) default NULL, |
4 | `type` int(11) default NULL, | 4 | `type` int(11) default NULL, |
5 | `parentFolderID` varchar(36) default NULL, | 5 | `parentFolderID` varchar(36) default NULL, |
6 | `avatarID` varchar(36) default NULL, | 6 | `avatarID` varchar(36) default NULL, |
7 | `inventoryName` varchar(64) default NULL, | 7 | `inventoryName` varchar(64) default NULL, |
8 | `inventoryDescription` varchar(64) default NULL, | 8 | `inventoryDescription` varchar(64) default NULL, |
9 | `inventoryNextPermissions` int(10) unsigned default NULL, | 9 | `inventoryNextPermissions` int(10) unsigned default NULL, |
10 | `inventoryCurrentPermissions` int(10) unsigned default NULL, | 10 | `inventoryCurrentPermissions` int(10) unsigned default NULL, |
11 | PRIMARY KEY (`inventoryID`), | 11 | PRIMARY KEY (`inventoryID`), |
12 | KEY `owner` (`avatarID`), | 12 | KEY `owner` (`avatarID`), |
13 | KEY `folder` (`parentFolderID`) | 13 | KEY `folder` (`parentFolderID`) |
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
diff --git a/share/sql/mysql-reservations.txt b/share/sql/mysql-reservations.txt index d6d84b9..9dab31d 100644 --- a/share/sql/mysql-reservations.txt +++ b/share/sql/mysql-reservations.txt | |||
@@ -1,16 +1,16 @@ | |||
1 | CREATE TABLE `reservations` ( | 1 | CREATE TABLE `reservations` ( |
2 | `resID` int(10) unsigned NOT NULL auto_increment, | 2 | `resID` int(10) unsigned NOT NULL auto_increment, |
3 | `userUUID` varchar(36) default NULL, | 3 | `userUUID` varchar(36) default NULL, |
4 | `gridSendKey` varchar(64) default NULL, | 4 | `gridSendKey` varchar(64) default NULL, |
5 | `gridRecvKey` varchar(64) default NULL, | 5 | `gridRecvKey` varchar(64) default NULL, |
6 | `resName` varchar(255) default NULL, | 6 | `resName` varchar(255) default NULL, |
7 | `resCompany` varchar(128) default NULL, | 7 | `resCompany` varchar(128) default NULL, |
8 | `resXMin` int(10) unsigned default NULL, | 8 | `resXMin` int(10) unsigned default NULL, |
9 | `resXMax` int(10) unsigned default NULL, | 9 | `resXMax` int(10) unsigned default NULL, |
10 | `resYMin` int(10) unsigned default NULL, | 10 | `resYMin` int(10) unsigned default NULL, |
11 | `resYMax` int(10) unsigned default NULL, | 11 | `resYMax` int(10) unsigned default NULL, |
12 | `status` int(10) unsigned default NULL, | 12 | `status` int(10) unsigned default NULL, |
13 | PRIMARY KEY (`resID`), | 13 | PRIMARY KEY (`resID`), |
14 | KEY `resident` (`userUUID`), | 14 | KEY `resident` (`userUUID`), |
15 | KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`) | 15 | KEY `coords` (`resXMin`,`resXMax`,`resYMin`,`resYMax`) |
16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; | 16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ; |