1
0

CreateRegionsTable.sql 1.6 KB

1234567891011121314151617181920212223242526272829303132
  1. CREATE TABLE `regions` (
  2. `uuid` varchar(36) NOT NULL,
  3. `regionHandle` bigint(20) unsigned NOT NULL,
  4. `regionName` varchar(32) default NULL,
  5. `regionRecvKey` varchar(128) default NULL,
  6. `regionSendKey` varchar(128) default NULL,
  7. `regionSecret` varchar(128) default NULL,
  8. `regionDataURI` varchar(255) default NULL,
  9. `serverIP` varchar(64) default NULL,
  10. `serverPort` int(10) unsigned default NULL,
  11. `serverURI` varchar(255) default NULL,
  12. `locX` int(10) unsigned default NULL,
  13. `locY` int(10) unsigned default NULL,
  14. `locZ` int(10) unsigned default NULL,
  15. `eastOverrideHandle` bigint(20) unsigned default NULL,
  16. `westOverrideHandle` bigint(20) unsigned default NULL,
  17. `southOverrideHandle` bigint(20) unsigned default NULL,
  18. `northOverrideHandle` bigint(20) unsigned default NULL,
  19. `regionAssetURI` varchar(255) default NULL,
  20. `regionAssetRecvKey` varchar(128) default NULL,
  21. `regionAssetSendKey` varchar(128) default NULL,
  22. `regionUserURI` varchar(255) default NULL,
  23. `regionUserRecvKey` varchar(128) default NULL,
  24. `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
  25. `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
  26. `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
  27. `originUUID` varchar(36),
  28. PRIMARY KEY (`uuid`),
  29. KEY `regionName` (`regionName`),
  30. KEY `regionHandle` (`regionHandle`),
  31. KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';