EstateStore.migrations 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. :VERSION 13
  2. # The estate migrations used to be in Region store
  3. # here they will do nothing (bad) if the tables are already there,
  4. # just update the store version.
  5. BEGIN;
  6. CREATE TABLE IF NOT EXISTS `estate_managers` (
  7. `EstateID` int(10) unsigned NOT NULL,
  8. `uuid` char(36) NOT NULL,
  9. KEY `EstateID` (`EstateID`)
  10. ) ENGINE=InnoDB;
  11. CREATE TABLE IF NOT EXISTS `estate_groups` (
  12. `EstateID` int(10) unsigned NOT NULL,
  13. `uuid` char(36) NOT NULL,
  14. KEY `EstateID` (`EstateID`)
  15. ) ENGINE=InnoDB;
  16. CREATE TABLE IF NOT EXISTS `estate_users` (
  17. `EstateID` int(10) unsigned NOT NULL,
  18. `uuid` char(36) NOT NULL,
  19. KEY `EstateID` (`EstateID`)
  20. ) ENGINE=InnoDB;
  21. CREATE TABLE IF NOT EXISTS `estateban` (
  22. `EstateID` int(10) unsigned NOT NULL,
  23. `bannedUUID` varchar(36) NOT NULL,
  24. `bannedIp` varchar(16) NOT NULL,
  25. `bannedIpHostMask` varchar(16) NOT NULL,
  26. `bannedNameMask` varchar(64) default NULL,
  27. KEY `estateban_EstateID` (`EstateID`)
  28. ) ENGINE=InnoDB;
  29. CREATE TABLE IF NOT EXISTS `estate_settings` (
  30. `EstateID` int(10) unsigned NOT NULL auto_increment,
  31. `EstateName` varchar(64) default NULL,
  32. `AbuseEmailToEstateOwner` tinyint(4) NOT NULL,
  33. `DenyAnonymous` tinyint(4) NOT NULL,
  34. `ResetHomeOnTeleport` tinyint(4) NOT NULL,
  35. `FixedSun` tinyint(4) NOT NULL,
  36. `DenyTransacted` tinyint(4) NOT NULL,
  37. `BlockDwell` tinyint(4) NOT NULL,
  38. `DenyIdentified` tinyint(4) NOT NULL,
  39. `AllowVoice` tinyint(4) NOT NULL,
  40. `UseGlobalTime` tinyint(4) NOT NULL,
  41. `PricePerMeter` int(11) NOT NULL,
  42. `TaxFree` tinyint(4) NOT NULL,
  43. `AllowDirectTeleport` tinyint(4) NOT NULL,
  44. `RedirectGridX` int(11) NOT NULL,
  45. `RedirectGridY` int(11) NOT NULL,
  46. `ParentEstateID` int(10) unsigned NOT NULL,
  47. `SunPosition` double NOT NULL,
  48. `EstateSkipScripts` tinyint(4) NOT NULL,
  49. `BillableFactor` float NOT NULL,
  50. `PublicAccess` tinyint(4) NOT NULL,
  51. `AbuseEmail` varchar(255) not null,
  52. `EstateOwner` varchar(36) not null,
  53. `DenyMinors` tinyint not null,
  54. PRIMARY KEY (`EstateID`)
  55. ) ENGINE=InnoDB AUTO_INCREMENT=100;
  56. CREATE TABLE IF NOT EXISTS `estate_map` (
  57. `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  58. `EstateID` int(11) NOT NULL,
  59. PRIMARY KEY (`RegionID`),
  60. KEY `EstateID` (`EstateID`)
  61. ) ENGINE=InnoDB;
  62. COMMIT;
  63. :VERSION 32 #--------------------- (moved from RegionStore migr, just in case)
  64. BEGIN;
  65. ALTER TABLE estate_settings AUTO_INCREMENT = 100;
  66. COMMIT;