diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/EstateStore.migrations | 69 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 78 |
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 | |||
5 | CREATE 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 | |||
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 | |||
17 | CREATE 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 | |||
23 | CREATE 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 | |||
32 | CREATE 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 | |||
61 | CREATE 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 | ||
389 | CREATE TABLE `estate_managers` ( | ||
390 | `EstateID` int(10) unsigned NOT NULL, | ||
391 | `uuid` char(36) NOT NULL, | ||
392 | KEY `EstateID` (`EstateID`) | ||
393 | ) ENGINE=InnoDB; | ||
394 | |||
395 | CREATE TABLE `estate_groups` ( | ||
396 | `EstateID` int(10) unsigned NOT NULL, | ||
397 | `uuid` char(36) NOT NULL, | ||
398 | KEY `EstateID` (`EstateID`) | ||
399 | ) ENGINE=InnoDB; | ||
400 | |||
401 | CREATE TABLE `estate_users` ( | ||
402 | `EstateID` int(10) unsigned NOT NULL, | ||
403 | `uuid` char(36) NOT NULL, | ||
404 | KEY `EstateID` (`EstateID`) | ||
405 | ) ENGINE=InnoDB; | ||
406 | |||
407 | CREATE 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 | |||
416 | CREATE 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 | |||
441 | CREATE 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 | |||
448 | commit; | ||
449 | |||
450 | :VERSION 14 #--------------------- | ||
451 | |||
452 | begin; | ||
453 | |||
454 | alter table estate_settings add column AbuseEmail varchar(255) not null; | ||
455 | |||
456 | alter table estate_settings add column EstateOwner varchar(36) not null; | ||
457 | |||
458 | commit; | ||
459 | |||
460 | |||
461 | :VERSION 15 #--------------------- | ||
462 | |||
463 | begin; | ||
464 | |||
465 | alter table estate_settings add column DenyMinors tinyint not null; | ||
466 | |||
467 | commit; | 389 | commit; |
468 | 390 | ||
469 | :VERSION 16 #--------------------- | 391 | :VERSION 16 #--------------------- |