1
0

EstateStore.migrations 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. :VERSION 34
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `estate_groups` (
  4. `EstateID` int(10) unsigned NOT NULL,
  5. `uuid` char(36) NOT NULL,
  6. KEY `EstateID` (`EstateID`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  8. CREATE TABLE IF NOT EXISTS `estate_managers` (
  9. `EstateID` int(10) unsigned NOT NULL,
  10. `uuid` char(36) NOT NULL,
  11. KEY `EstateID` (`EstateID`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  13. CREATE TABLE IF NOT EXISTS `estate_map` (
  14. `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  15. `EstateID` int(11) NOT NULL,
  16. PRIMARY KEY (`RegionID`),
  17. KEY `EstateID` (`EstateID`)
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  19. CREATE TABLE IF NOT EXISTS `estate_settings` (
  20. `EstateID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  21. `EstateName` varchar(64) DEFAULT NULL,
  22. `AbuseEmailToEstateOwner` tinyint(4) NOT NULL,
  23. `DenyAnonymous` tinyint(4) NOT NULL,
  24. `ResetHomeOnTeleport` tinyint(4) NOT NULL,
  25. `FixedSun` tinyint(4) NOT NULL,
  26. `DenyTransacted` tinyint(4) NOT NULL,
  27. `BlockDwell` tinyint(4) NOT NULL,
  28. `DenyIdentified` tinyint(4) NOT NULL,
  29. `AllowVoice` tinyint(4) NOT NULL,
  30. `UseGlobalTime` tinyint(4) NOT NULL,
  31. `PricePerMeter` int(11) NOT NULL,
  32. `TaxFree` tinyint(4) NOT NULL,
  33. `AllowDirectTeleport` tinyint(4) NOT NULL,
  34. `RedirectGridX` int(11) NOT NULL,
  35. `RedirectGridY` int(11) NOT NULL,
  36. `ParentEstateID` int(10) unsigned NOT NULL,
  37. `SunPosition` double NOT NULL,
  38. `EstateSkipScripts` tinyint(4) NOT NULL,
  39. `BillableFactor` float NOT NULL,
  40. `PublicAccess` tinyint(4) NOT NULL,
  41. `AbuseEmail` varchar(255) NOT NULL,
  42. `EstateOwner` varchar(36) NOT NULL,
  43. `DenyMinors` tinyint(4) NOT NULL,
  44. `AllowLandmark` tinyint(4) NOT NULL DEFAULT '1',
  45. `AllowParcelChanges` tinyint(4) NOT NULL DEFAULT '1',
  46. `AllowSetHome` tinyint(4) NOT NULL DEFAULT '1',
  47. PRIMARY KEY (`EstateID`)
  48. ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  49. CREATE TABLE IF NOT EXISTS `estate_users` (
  50. `EstateID` int(10) unsigned NOT NULL,
  51. `uuid` char(36) NOT NULL,
  52. KEY `EstateID` (`EstateID`)
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  54. CREATE TABLE IF NOT EXISTS `estateban` (
  55. `EstateID` int(10) unsigned NOT NULL,
  56. `bannedUUID` varchar(36) NOT NULL,
  57. `bannedIp` varchar(16) NOT NULL,
  58. `bannedIpHostMask` varchar(16) NOT NULL,
  59. `bannedNameMask` varchar(64) DEFAULT NULL,
  60. KEY `estateban_EstateID` (`EstateID`)
  61. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  62. COMMIT;
  63. :VERSION 35
  64. BEGIN;
  65. ALTER TABLE `estateban`
  66. ADD COLUMN `banningUUID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  67. ADD COLUMN `banTime` int(11) NOT NULL DEFAULT 0;
  68. COMMIT;
  69. :VERSION 36
  70. BEGIN;
  71. ALTER TABLE `estate_settings`
  72. ADD COLUMN `AllowEnviromentOverride` tinyint(4) NOT NULL DEFAULT '0';
  73. COMMIT;