diff options
Diffstat (limited to '')
| -rw-r--r-- | share/sql/mysql-inventoryitems.sql | 28 |
1 files changed, 14 insertions, 14 deletions
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; |