1
0

mysql-inventoryitems.sql 598 B

1234567891011121314
  1. CREATE TABLE `inventoryitems` (
  2. `inventoryID` varchar(36) NOT NULL default '',
  3. `assetID` varchar(36) default NULL,
  4. `type` int(11) default NULL,
  5. `parentFolderID` varchar(36) default NULL,
  6. `avatarID` varchar(36) default NULL,
  7. `inventoryName` varchar(64) default NULL,
  8. `inventoryDescription` varchar(64) default NULL,
  9. `inventoryNextPermissions` int(10) unsigned default NULL,
  10. `inventoryCurrentPermissions` int(10) unsigned default NULL,
  11. PRIMARY KEY (`inventoryID`),
  12. KEY `owner` (`avatarID`),
  13. KEY `folder` (`parentFolderID`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;