GridStore.migrations 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596
  1. :VERSION 1
  2. CREATE TABLE `regions` (
  3. `uuid` varchar(36) NOT NULL,
  4. `regionHandle` bigint(20) unsigned NOT NULL,
  5. `regionName` varchar(32) default NULL,
  6. `regionRecvKey` varchar(128) default NULL,
  7. `regionSendKey` varchar(128) default NULL,
  8. `regionSecret` varchar(128) default NULL,
  9. `regionDataURI` varchar(255) default NULL,
  10. `serverIP` varchar(64) default NULL,
  11. `serverPort` int(10) unsigned default NULL,
  12. `serverURI` varchar(255) default NULL,
  13. `locX` int(10) unsigned default NULL,
  14. `locY` int(10) unsigned default NULL,
  15. `locZ` int(10) unsigned default NULL,
  16. `eastOverrideHandle` bigint(20) unsigned default NULL,
  17. `westOverrideHandle` bigint(20) unsigned default NULL,
  18. `southOverrideHandle` bigint(20) unsigned default NULL,
  19. `northOverrideHandle` bigint(20) unsigned default NULL,
  20. `regionAssetURI` varchar(255) default NULL,
  21. `regionAssetRecvKey` varchar(128) default NULL,
  22. `regionAssetSendKey` varchar(128) default NULL,
  23. `regionUserURI` varchar(255) default NULL,
  24. `regionUserRecvKey` varchar(128) default NULL,
  25. `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
  26. `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
  27. `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
  28. `originUUID` varchar(36),
  29. PRIMARY KEY (`uuid`),
  30. KEY `regionName` (`regionName`),
  31. KEY `regionHandle` (`regionHandle`),
  32. KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
  34. :VERSION 2
  35. BEGIN;
  36. ALTER TABLE regions add column access integer unsigned default 1;
  37. COMMIT;
  38. :VERSION 3
  39. BEGIN;
  40. ALTER TABLE regions add column ScopeID char(36) not null default '00000000-0000-0000-0000-000000000000';
  41. create index ScopeID on regions(ScopeID);
  42. COMMIT;
  43. :VERSION 4
  44. BEGIN;
  45. ALTER TABLE regions add column sizeX integer not null default 0;
  46. ALTER TABLE regions add column sizeY integer not null default 0;
  47. COMMIT;
  48. :VERSION 5
  49. BEGIN;
  50. ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0;
  51. CREATE INDEX flags ON regions(flags);
  52. COMMIT;
  53. :VERSION 6
  54. BEGIN;
  55. ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0;
  56. COMMIT;
  57. :VERSION 7
  58. BEGIN;
  59. ALTER TABLE `regions` ADD COLUMN `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
  60. ALTER TABLE `regions` ADD COLUMN `Token` varchar(255) NOT NULL;
  61. COMMIT;
  62. :VERSION 8 # ------------
  63. BEGIN;
  64. alter table regions modify column regionName varchar(128) default NULL;
  65. COMMIT;