diff options
author | Melanie Thielker | 2008-11-26 12:23:56 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-11-26 12:23:56 +0000 |
commit | fdf5f55a5b0e8936277053d3d24faef23a8f3061 (patch) | |
tree | 1f6620272c0aec847d81026cd7457d7c8f23464d /OpenSim/Data/MySQL/Resources/025_RegionStore.sql | |
parent | A migration to make the floats in prims table be doubles (diff) | |
download | opensim-SC_OLD-fdf5f55a5b0e8936277053d3d24faef23a8f3061.zip opensim-SC_OLD-fdf5f55a5b0e8936277053d3d24faef23a8f3061.tar.gz opensim-SC_OLD-fdf5f55a5b0e8936277053d3d24faef23a8f3061.tar.bz2 opensim-SC_OLD-fdf5f55a5b0e8936277053d3d24faef23a8f3061.tar.xz |
Yay for unit tests. Increased the type width of the prims and primshapes
tables, and changed the database modules to actually push these doubles
down into the database layer.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/025_RegionStore.sql | 78 |
1 files changed, 41 insertions, 37 deletions
diff --git a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql index 47fb6dd..e8f5d70 100644 --- a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql +++ b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql | |||
@@ -1,42 +1,46 @@ | |||
1 | BEGIN; | 1 | BEGIN; |
2 | 2 | ||
3 | alter table prims change column `PositionX` `PositionX` float default NULL; | 3 | alter table prims change column `PositionX` `PositionX` double default NULL; |
4 | alter table prims change column `PositionY` `PositionY` float default NULL; | 4 | alter table prims change column `PositionY` `PositionY` double default NULL; |
5 | alter table prims change column `PositionZ` `PositionZ` float default NULL; | 5 | alter table prims change column `PositionZ` `PositionZ` double default NULL; |
6 | alter table prims change column `GroupPositionX` `GroupPositionX` float default NULL; | 6 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; |
7 | alter table prims change column `GroupPositionY` `GroupPositionY` float default NULL; | 7 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; |
8 | alter table prims change column `GroupPositionZ` `GroupPositionZ` float default NULL; | 8 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; |
9 | alter table prims change column `VelocityX` `VelocityX` float default NULL; | 9 | alter table prims change column `VelocityX` `VelocityX` double default NULL; |
10 | alter table prims change column `VelocityY` `VelocityY` float default NULL; | 10 | alter table prims change column `VelocityY` `VelocityY` double default NULL; |
11 | alter table prims change column `VelocityZ` `VelocityZ` float default NULL; | 11 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; |
12 | alter table prims change column `AngularVelocityX` `AngularVelocityX` float default NULL; | 12 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; |
13 | alter table prims change column `AngularVelocityY` `AngularVelocityY` float default NULL; | 13 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; |
14 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` float default NULL; | 14 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; |
15 | alter table prims change column `AccelerationX` `AccelerationX` float default NULL; | 15 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; |
16 | alter table prims change column `AccelerationY` `AccelerationY` float default NULL; | 16 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; |
17 | alter table prims change column `AccelerationZ` `AccelerationZ` float default NULL; | 17 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; |
18 | alter table prims change column `RotationX` `RotationX` float default NULL; | 18 | alter table prims change column `RotationX` `RotationX` double default NULL; |
19 | alter table prims change column `RotationY` `RotationY` float default NULL; | 19 | alter table prims change column `RotationY` `RotationY` double default NULL; |
20 | alter table prims change column `RotationZ` `RotationZ` float default NULL; | 20 | alter table prims change column `RotationZ` `RotationZ` double default NULL; |
21 | alter table prims change column `RotationW` `RotationW` float default NULL; | 21 | alter table prims change column `RotationW` `RotationW` double default NULL; |
22 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` float default NULL; | 22 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; |
23 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` float default NULL; | 23 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; |
24 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` float default NULL; | 24 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; |
25 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` float default NULL; | 25 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; |
26 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` float default NULL; | 26 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; |
27 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` float default NULL; | 27 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; |
28 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` float default NULL; | 28 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; |
29 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` float NOT NULL default '0'; | 29 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0'; |
30 | alter table prims change column `OmegaX` `OmegaX` float NOT NULL default '0'; | 30 | alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0'; |
31 | alter table prims change column `OmegaY` `OmegaY` float NOT NULL default '0'; | 31 | alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0'; |
32 | alter table prims change column `OmegaZ` `OmegaZ` float NOT NULL default '0'; | 32 | alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0'; |
33 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` float NOT NULL default '0'; | 33 | alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0'; |
34 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` float NOT NULL default '0'; | 34 | alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0'; |
35 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` float NOT NULL default '0'; | 35 | alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0'; |
36 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` float NOT NULL default '0'; | 36 | alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0'; |
37 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` float NOT NULL default '0'; | 37 | alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0'; |
38 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` float NOT NULL default '0'; | 38 | alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0'; |
39 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` float NOT NULL default '0'; | 39 | alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0'; |
40 | |||
41 | alter table primshapes change column `ScaleX` `ScaleX` double NOT NULL default '0'; | ||
42 | alter table primshapes change column `ScaleY` `ScaleY` double NOT NULL default '0'; | ||
43 | alter table primshapes change column `ScaleZ` `ScaleZ` double NOT NULL default '0'; | ||
40 | 44 | ||
41 | COMMIT; | 45 | COMMIT; |
42 | 46 | ||