aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations70
1 files changed, 58 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 071f64e..ac31380 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -146,7 +146,7 @@ CREATE TABLE `land` (
146 `UserLookAtZ` float default NULL, 146 `UserLookAtZ` float default NULL,
147 `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 147 `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
148 PRIMARY KEY (`UUID`) 148 PRIMARY KEY (`UUID`)
149) ENGINE=MyISAM DEFAULT CHARSET=utf8; 149) ENGINE=InnoDB DEFAULT CHARSET=utf8;
150 150
151CREATE TABLE `landaccesslist` ( 151CREATE TABLE `landaccesslist` (
152 `LandUUID` varchar(255) default NULL, 152 `LandUUID` varchar(255) default NULL,
@@ -168,7 +168,7 @@ COMMIT;
168:VERSION 3 #--------------------- 168:VERSION 3 #---------------------
169 169
170BEGIN; 170BEGIN;
171 CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 171 CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
172COMMIT; 172COMMIT;
173 173
174:VERSION 4 #--------------------- 174:VERSION 4 #---------------------
@@ -226,13 +226,13 @@ COMMIT;
226 226
227BEGIN; 227BEGIN;
228 228
229alter table landaccesslist ENGINE = MyISAM; 229alter table landaccesslist ENGINE = InnoDB;
230alter table migrations ENGINE = MyISAM; 230alter table migrations ENGINE = InnoDB;
231alter table primitems ENGINE = MyISAM; 231alter table primitems ENGINE = InnoDB;
232alter table prims ENGINE = MyISAM; 232alter table prims ENGINE = InnoDB;
233alter table primshapes ENGINE = MyISAM; 233alter table primshapes ENGINE = InnoDB;
234alter table regionsettings ENGINE = MyISAM; 234alter table regionsettings ENGINE = InnoDB;
235alter table terrain ENGINE = MyISAM; 235alter table terrain ENGINE = InnoDB;
236 236
237COMMIT; 237COMMIT;
238 238
@@ -384,7 +384,7 @@ CREATE TABLE `regionsettings` (
384 `covenant` char(36) default NULL, 384 `covenant` char(36) default NULL,
385 `Sandbox` tinyint(4) NOT NULL, 385 `Sandbox` tinyint(4) NOT NULL,
386 PRIMARY KEY (`regionUUID`) 386 PRIMARY KEY (`regionUUID`)
387) ENGINE=MyISAM; 387) ENGINE=InnoDB;
388 388
389commit; 389commit;
390 390
@@ -852,7 +852,7 @@ CREATE TABLE IF NOT EXISTS `spawn_points` (
852 `Pitch` float NOT NULL, 852 `Pitch` float NOT NULL,
853 `Distance` float NOT NULL, 853 `Distance` float NOT NULL,
854 KEY `RegionID` (`RegionID`) 854 KEY `RegionID` (`RegionID`)
855) ENGINE=MyISAM; 855) ENGINE=Innodb;
856 856
857ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; 857ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL;
858COMMIT; 858COMMIT;
@@ -891,7 +891,7 @@ CREATE TABLE `regionenvironment` (
891 `region_id` varchar(36) NOT NULL, 891 `region_id` varchar(36) NOT NULL,
892 `llsd_settings` TEXT NOT NULL, 892 `llsd_settings` TEXT NOT NULL,
893 PRIMARY KEY (`region_id`) 893 PRIMARY KEY (`region_id`)
894) ENGINE=MyISAM DEFAULT CHARSET=utf8; 894) ENGINE=InnoDB DEFAULT CHARSET=utf8;
895 895
896COMMIT; 896COMMIT;
897 897
@@ -902,3 +902,49 @@ BEGIN;
902CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`)); 902CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`));
903 903
904COMMIT; 904COMMIT;
905
906:VERSION 46 #---------------- Dynamic attributes
907
908BEGIN;
909
910ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
911
912COMMIT;
913
914:VERSION 47 #---------------- Extra physics params
915
916BEGIN;
917
918ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0';
919ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000';
920ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1';
921ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6';
922ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5';
923
924COMMIT;
925
926:VERSION 48 #---------------- Keyframes
927
928BEGIN;
929
930ALTER TABLE prims ADD COLUMN `KeyframeMotion` blob;
931
932COMMIT;
933
934:VERSION 49 #--------------------- Save attachment info
935
936BEGIN;
937ALTER TABLE prims ADD COLUMN AttachedPosX double default 0;
938ALTER TABLE prims ADD COLUMN AttachedPosY double default 0;
939ALTER TABLE prims ADD COLUMN AttachedPosZ double default 0;
940ALTER TABLE primshapes ADD COLUMN LastAttachPoint int(4) not null default '0';
941COMMIT;
942
943:VERSION 50 #---- Change LandFlags to unsigned
944
945BEGIN;
946
947ALTER TABLE land CHANGE COLUMN LandFlags LandFlags int unsigned default null;
948
949COMMIT;
950