diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/025_RegionStore.sql')
| -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 | ||