aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorMelanie Thielker2008-11-26 09:05:11 +0000
committerMelanie Thielker2008-11-26 09:05:11 +0000
commit841c53003f74ef98f50590d854df7a199803dc36 (patch)
tree2fa3186b3694597253f5680c5c7a8a13e8ba2f51
parentFix 2 of the failed tests. Cause terrain queries to return null when no (diff)
downloadopensim-SC_OLD-841c53003f74ef98f50590d854df7a199803dc36.zip
opensim-SC_OLD-841c53003f74ef98f50590d854df7a199803dc36.tar.gz
opensim-SC_OLD-841c53003f74ef98f50590d854df7a199803dc36.tar.bz2
opensim-SC_OLD-841c53003f74ef98f50590d854df7a199803dc36.tar.xz
A migration to convert the floats int the database to doubles.
Maybe we don't have to say "Shift happens" as often anymore....
-rw-r--r--OpenSim/Data/MySQL/Resources/024_RegionStore.sql18
-rw-r--r--OpenSim/Data/MySQL/Resources/025_RegionStore.sql42
2 files changed, 60 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/024_RegionStore.sql b/OpenSim/Data/MySQL/Resources/024_RegionStore.sql
new file mode 100644
index 0000000..defbf5c
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/024_RegionStore.sql
@@ -0,0 +1,18 @@
1BEGIN;
2
3alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL;
4alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL;
5alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL;
6alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL;
7alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL;
8alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL;
9alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL;
10alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL;
11alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL;
12alter table regionsettings change column `water_height` `water_height` double NOT NULL;
13alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL;
14alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL;
15alter table regionsettings change column `sun_position` `sun_position` double NOT NULL;
16
17COMMIT;
18
diff --git a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql
new file mode 100644
index 0000000..47fb6dd
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql
@@ -0,0 +1,42 @@
1BEGIN;
2
3alter table prims change column `PositionX` `PositionX` float default NULL;
4alter table prims change column `PositionY` `PositionY` float default NULL;
5alter table prims change column `PositionZ` `PositionZ` float default NULL;
6alter table prims change column `GroupPositionX` `GroupPositionX` float default NULL;
7alter table prims change column `GroupPositionY` `GroupPositionY` float default NULL;
8alter table prims change column `GroupPositionZ` `GroupPositionZ` float default NULL;
9alter table prims change column `VelocityX` `VelocityX` float default NULL;
10alter table prims change column `VelocityY` `VelocityY` float default NULL;
11alter table prims change column `VelocityZ` `VelocityZ` float default NULL;
12alter table prims change column `AngularVelocityX` `AngularVelocityX` float default NULL;
13alter table prims change column `AngularVelocityY` `AngularVelocityY` float default NULL;
14alter table prims change column `AngularVelocityZ` `AngularVelocityZ` float default NULL;
15alter table prims change column `AccelerationX` `AccelerationX` float default NULL;
16alter table prims change column `AccelerationY` `AccelerationY` float default NULL;
17alter table prims change column `AccelerationZ` `AccelerationZ` float default NULL;
18alter table prims change column `RotationX` `RotationX` float default NULL;
19alter table prims change column `RotationY` `RotationY` float default NULL;
20alter table prims change column `RotationZ` `RotationZ` float default NULL;
21alter table prims change column `RotationW` `RotationW` float default NULL;
22alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` float default NULL;
23alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` float default NULL;
24alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` float default NULL;
25alter table prims change column `SitTargetOrientW` `SitTargetOrientW` float default NULL;
26alter table prims change column `SitTargetOrientX` `SitTargetOrientX` float default NULL;
27alter table prims change column `SitTargetOrientY` `SitTargetOrientY` float default NULL;
28alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` float default NULL;
29alter table prims change column `LoopedSoundGain` `LoopedSoundGain` float NOT NULL default '0';
30alter table prims change column `OmegaX` `OmegaX` float NOT NULL default '0';
31alter table prims change column `OmegaY` `OmegaY` float NOT NULL default '0';
32alter table prims change column `OmegaZ` `OmegaZ` float NOT NULL default '0';
33alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` float NOT NULL default '0';
34alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` float NOT NULL default '0';
35alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` float NOT NULL default '0';
36alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` float NOT NULL default '0';
37alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` float NOT NULL default '0';
38alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` float NOT NULL default '0';
39alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` float NOT NULL default '0';
40
41COMMIT;
42