aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/Resources/EstateStore.migrations69
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations78
2 files changed, 69 insertions, 78 deletions
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
new file mode 100644
index 0000000..2e0d658
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
@@ -0,0 +1,69 @@
1:VERSION 13
2
3# The estate migrations used to be in Region store
4
5CREATE TABLE IF NOT EXISTS `estate_managers` (
6 `EstateID` int(10) unsigned NOT NULL,
7 `uuid` char(36) NOT NULL,
8 KEY `EstateID` (`EstateID`)
9) ENGINE=InnoDB;
10
11CREATE 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
17CREATE TABLE IF NOT EXISTS `estate_users` (
18 `EstateID` int(10) unsigned NOT NULL,
19 `uuid` char(36) NOT NULL,
20 KEY `EstateID` (`EstateID`)
21) ENGINE=InnoDB;
22
23CREATE TABLE IF NOT EXISTS `estateban` (
24 `EstateID` int(10) unsigned NOT NULL,
25 `bannedUUID` varchar(36) NOT NULL,
26 `bannedIp` varchar(16) NOT NULL,
27 `bannedIpHostMask` varchar(16) NOT NULL,
28 `bannedNameMask` varchar(64) default NULL,
29 KEY `estateban_EstateID` (`EstateID`)
30) ENGINE=InnoDB;
31
32CREATE TABLE IF NOT EXISTS `estate_settings` (
33 `EstateID` int(10) unsigned NOT NULL auto_increment,
34 `EstateName` varchar(64) default NULL,
35 `AbuseEmailToEstateOwner` tinyint(4) NOT NULL,
36 `DenyAnonymous` tinyint(4) NOT NULL,
37 `ResetHomeOnTeleport` tinyint(4) NOT NULL,
38 `FixedSun` tinyint(4) NOT NULL,
39 `DenyTransacted` tinyint(4) NOT NULL,
40 `BlockDwell` tinyint(4) NOT NULL,
41 `DenyIdentified` tinyint(4) NOT NULL,
42 `AllowVoice` tinyint(4) NOT NULL,
43 `UseGlobalTime` tinyint(4) NOT NULL,
44 `PricePerMeter` int(11) NOT NULL,
45 `TaxFree` tinyint(4) NOT NULL,
46 `AllowDirectTeleport` tinyint(4) NOT NULL,
47 `RedirectGridX` int(11) NOT NULL,
48 `RedirectGridY` int(11) NOT NULL,
49 `ParentEstateID` int(10) unsigned NOT NULL,
50 `SunPosition` double NOT NULL,
51 `EstateSkipScripts` tinyint(4) NOT NULL,
52 `BillableFactor` float NOT NULL,
53 `PublicAccess` tinyint(4) NOT NULL,
54 `AbuseEmail` varchar(255) not null,
55 `EstateOwner` varchar(36) not null,
56 `DenyMinors` tinyint not null,
57
58 PRIMARY KEY (`EstateID`)
59) ENGINE=InnoDB AUTO_INCREMENT=100;
60
61CREATE TABLE IF NOT EXISTS `estate_map` (
62 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
63 `EstateID` int(11) NOT NULL,
64 PRIMARY KEY (`RegionID`),
65 KEY `EstateID` (`EstateID`)
66) ENGINE=InnoDB;
67
68
69
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index baeeedd..383c328 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -386,84 +386,6 @@ CREATE TABLE `regionsettings` (
386 PRIMARY KEY (`regionUUID`) 386 PRIMARY KEY (`regionUUID`)
387) ENGINE=InnoDB; 387) ENGINE=InnoDB;
388 388
389CREATE TABLE `estate_managers` (
390 `EstateID` int(10) unsigned NOT NULL,
391 `uuid` char(36) NOT NULL,
392 KEY `EstateID` (`EstateID`)
393) ENGINE=InnoDB;
394
395CREATE TABLE `estate_groups` (
396 `EstateID` int(10) unsigned NOT NULL,
397 `uuid` char(36) NOT NULL,
398 KEY `EstateID` (`EstateID`)
399) ENGINE=InnoDB;
400
401CREATE TABLE `estate_users` (
402 `EstateID` int(10) unsigned NOT NULL,
403 `uuid` char(36) NOT NULL,
404 KEY `EstateID` (`EstateID`)
405) ENGINE=InnoDB;
406
407CREATE TABLE `estateban` (
408 `EstateID` int(10) unsigned NOT NULL,
409 `bannedUUID` varchar(36) NOT NULL,
410 `bannedIp` varchar(16) NOT NULL,
411 `bannedIpHostMask` varchar(16) NOT NULL,
412 `bannedNameMask` varchar(64) default NULL,
413 KEY `estateban_EstateID` (`EstateID`)
414) ENGINE=InnoDB;
415
416CREATE TABLE `estate_settings` (
417 `EstateID` int(10) unsigned NOT NULL auto_increment,
418 `EstateName` varchar(64) default NULL,
419 `AbuseEmailToEstateOwner` tinyint(4) NOT NULL,
420 `DenyAnonymous` tinyint(4) NOT NULL,
421 `ResetHomeOnTeleport` tinyint(4) NOT NULL,
422 `FixedSun` tinyint(4) NOT NULL,
423 `DenyTransacted` tinyint(4) NOT NULL,
424 `BlockDwell` tinyint(4) NOT NULL,
425 `DenyIdentified` tinyint(4) NOT NULL,
426 `AllowVoice` tinyint(4) NOT NULL,
427 `UseGlobalTime` tinyint(4) NOT NULL,
428 `PricePerMeter` int(11) NOT NULL,
429 `TaxFree` tinyint(4) NOT NULL,
430 `AllowDirectTeleport` tinyint(4) NOT NULL,
431 `RedirectGridX` int(11) NOT NULL,
432 `RedirectGridY` int(11) NOT NULL,
433 `ParentEstateID` int(10) unsigned NOT NULL,
434 `SunPosition` double NOT NULL,
435 `EstateSkipScripts` tinyint(4) NOT NULL,
436 `BillableFactor` float NOT NULL,
437 `PublicAccess` tinyint(4) NOT NULL,
438 PRIMARY KEY (`EstateID`)
439) ENGINE=InnoDB AUTO_INCREMENT=100;
440
441CREATE TABLE `estate_map` (
442 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
443 `EstateID` int(11) NOT NULL,
444 PRIMARY KEY (`RegionID`),
445 KEY `EstateID` (`EstateID`)
446) ENGINE=InnoDB;
447
448commit;
449
450:VERSION 14 #---------------------
451
452begin;
453
454alter table estate_settings add column AbuseEmail varchar(255) not null;
455
456alter table estate_settings add column EstateOwner varchar(36) not null;
457
458commit;
459
460
461:VERSION 15 #---------------------
462
463begin;
464
465alter table estate_settings add column DenyMinors tinyint not null;
466
467commit; 389commit;
468 390
469:VERSION 16 #--------------------- 391:VERSION 16 #---------------------