1
0

InventoryStore.migrations 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. :VERSION 7 # ------------
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `inventoryitems` (
  4. `assetID` varchar(36) DEFAULT NULL,
  5. `assetType` int(11) DEFAULT NULL,
  6. `inventoryName` varchar(64) DEFAULT NULL,
  7. `inventoryDescription` varchar(128) DEFAULT NULL,
  8. `inventoryNextPermissions` int(10) unsigned DEFAULT NULL,
  9. `inventoryCurrentPermissions` int(10) unsigned DEFAULT NULL,
  10. `invType` int(11) DEFAULT NULL,
  11. `creatorID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  12. `inventoryBasePermissions` int(10) unsigned NOT NULL DEFAULT '0',
  13. `inventoryEveryOnePermissions` int(10) unsigned NOT NULL DEFAULT '0',
  14. `salePrice` int(11) NOT NULL DEFAULT '0',
  15. `saleType` tinyint(4) NOT NULL DEFAULT '0',
  16. `creationDate` int(11) NOT NULL DEFAULT '0',
  17. `groupID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  18. `groupOwned` tinyint(4) NOT NULL DEFAULT '0',
  19. `flags` int(11) unsigned NOT NULL DEFAULT '0',
  20. `inventoryID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  21. `avatarID` char(36) DEFAULT NULL,
  22. `parentFolderID` char(36) DEFAULT NULL,
  23. `inventoryGroupPermissions` int(10) unsigned NOT NULL DEFAULT '0',
  24. PRIMARY KEY (`inventoryID`),
  25. KEY `inventoryitems_avatarid` (`avatarID`),
  26. KEY `inventoryitems_parentFolderid` (`parentFolderID`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  28. CREATE TABLE IF NOT EXISTS `inventoryfolders` (
  29. `folderName` varchar(64) DEFAULT NULL,
  30. `type` smallint(6) NOT NULL DEFAULT '0',
  31. `version` int(11) NOT NULL DEFAULT '0',
  32. `folderID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  33. `agentID` char(36) DEFAULT NULL,
  34. `parentFolderID` char(36) DEFAULT NULL,
  35. PRIMARY KEY (`folderID`),
  36. KEY `inventoryfolders_agentid` (`agentID`),
  37. KEY `inventoryfolders_parentFolderid` (`parentFolderID`)
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  39. COMMIT;