1
0

GridStore.migrations 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. :VERSION 10
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `regions` (
  4. `uuid` varchar(36) NOT NULL,
  5. `regionHandle` bigint(20) unsigned NOT NULL,
  6. `regionName` varchar(128) DEFAULT NULL,
  7. `regionRecvKey` varchar(128) DEFAULT NULL,
  8. `regionSendKey` varchar(128) DEFAULT NULL,
  9. `regionSecret` varchar(128) DEFAULT NULL,
  10. `regionDataURI` varchar(255) DEFAULT NULL,
  11. `serverIP` varchar(64) DEFAULT NULL,
  12. `serverPort` int(10) unsigned DEFAULT NULL,
  13. `serverURI` varchar(255) DEFAULT NULL,
  14. `locX` int(10) unsigned DEFAULT NULL,
  15. `locY` int(10) unsigned DEFAULT NULL,
  16. `locZ` int(10) unsigned DEFAULT NULL,
  17. `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
  18. `westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
  19. `southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
  20. `northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
  21. `regionAssetURI` varchar(255) DEFAULT NULL,
  22. `regionAssetRecvKey` varchar(128) DEFAULT NULL,
  23. `regionAssetSendKey` varchar(128) DEFAULT NULL,
  24. `regionUserURI` varchar(255) DEFAULT NULL,
  25. `regionUserRecvKey` varchar(128) DEFAULT NULL,
  26. `regionUserSendKey` varchar(128) DEFAULT NULL,
  27. `regionMapTexture` varchar(36) DEFAULT NULL,
  28. `serverHttpPort` int(10) DEFAULT NULL,
  29. `serverRemotingPort` int(10) DEFAULT NULL,
  30. `owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  31. `originUUID` varchar(36) DEFAULT NULL,
  32. `access` int(10) unsigned DEFAULT '1',
  33. `ScopeID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  34. `sizeX` int(11) NOT NULL DEFAULT '0',
  35. `sizeY` int(11) NOT NULL DEFAULT '0',
  36. `flags` int(11) NOT NULL DEFAULT '0',
  37. `last_seen` int(11) NOT NULL DEFAULT '0',
  38. `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  39. `Token` varchar(255) NOT NULL,
  40. `parcelMapTexture` varchar(36) DEFAULT NULL,
  41. PRIMARY KEY (`uuid`),
  42. KEY `regionName` (`regionName`),
  43. KEY `regionHandle` (`regionHandle`),
  44. KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
  45. KEY `ScopeID` (`ScopeID`),
  46. KEY `flags` (`flags`)
  47. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  48. COMMIT;