CREATE TABLE `inventoryitems` ( `inventoryID` varchar(36) NOT NULL default '', `assetID` varchar(36) default NULL, `assetType` int(11) default NULL, `parentFolderID` varchar(36) default NULL, `avatarID` varchar(36) default NULL, `inventoryName` varchar(64) default NULL, `inventoryDescription` varchar(128) default NULL, `inventoryNextPermissions` int(10) unsigned default NULL, `inventoryCurrentPermissions` int(10) unsigned default NULL, `invType` int(11) default NULL, `creatorID` varchar(36) default NULL, `inventoryBasePermissions` int(10) unsigned NOT NULL default 0, `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0, `salePrice` int(11) default NULL, `saleType` tinyint(4) default NULL, `creationDate` int(11) default NULL, `groupID` varchar(63) default NULL, `groupOwned` tinyint(4) default NULL, `flags` int(11) unsigned default NULL, PRIMARY KEY (`inventoryID`), KEY `owner` (`avatarID`), KEY `folder` (`parentFolderID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 3';