CreateItemsTable.sql 817 B

123456789101112131415161718
  1. CREATE TABLE `inventoryitems` (
  2. `inventoryID` varchar(36) NOT NULL default '',
  3. `assetID` varchar(36) default NULL,
  4. `assetType` 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(128) default NULL,
  9. `inventoryNextPermissions` int(10) unsigned default NULL,
  10. `inventoryCurrentPermissions` int(10) unsigned default NULL,
  11. `invType` int(11) default NULL,
  12. `creatorID` varchar(36) default NULL,
  13. `inventoryBasePermissions` int(10) unsigned NOT NULL default 0,
  14. `inventoryEveryOnePermissions` int(10) unsigned NOT NULL default 0,
  15. PRIMARY KEY (`inventoryID`),
  16. KEY `owner` (`avatarID`),
  17. KEY `folder` (`parentFolderID`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2';