| 123456789101112131415161718 |
- 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,
- PRIMARY KEY (`inventoryID`),
- KEY `owner` (`avatarID`),
- KEY `folder` (`parentFolderID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';
|
