026_RegionStore.sql 3.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. begin;
  2. alter table prims change column `PositionX` `PositionX` double default NULL;
  3. alter table prims change column `PositionY` `PositionY` double default NULL;
  4. alter table prims change column `PositionZ` `PositionZ` double default NULL;
  5. alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL;
  6. alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL;
  7. alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL;
  8. alter table prims change column `VelocityX` `VelocityX` double default NULL;
  9. alter table prims change column `VelocityY` `VelocityY` double default NULL;
  10. alter table prims change column `VelocityZ` `VelocityZ` double default NULL;
  11. alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL;
  12. alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL;
  13. alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL;
  14. alter table prims change column `AccelerationX` `AccelerationX` double default NULL;
  15. alter table prims change column `AccelerationY` `AccelerationY` double default NULL;
  16. alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL;
  17. alter table prims change column `RotationX` `RotationX` double default NULL;
  18. alter table prims change column `RotationY` `RotationY` double default NULL;
  19. alter table prims change column `RotationZ` `RotationZ` double default NULL;
  20. alter table prims change column `RotationW` `RotationW` double default NULL;
  21. alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL;
  22. alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL;
  23. alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL;
  24. alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL;
  25. alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL;
  26. alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL;
  27. alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL;
  28. alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double NOT NULL default '0';
  29. alter table prims change column `OmegaX` `OmegaX` double NOT NULL default '0';
  30. alter table prims change column `OmegaY` `OmegaY` double NOT NULL default '0';
  31. alter table prims change column `OmegaZ` `OmegaZ` double NOT NULL default '0';
  32. alter table prims change column `CameraEyeOffsetX` `CameraEyeOffsetX` double NOT NULL default '0';
  33. alter table prims change column `CameraEyeOffsetY` `CameraEyeOffsetY` double NOT NULL default '0';
  34. alter table prims change column `CameraEyeOffsetZ` `CameraEyeOffsetZ` double NOT NULL default '0';
  35. alter table prims change column `CameraAtOffsetX` `CameraAtOffsetX` double NOT NULL default '0';
  36. alter table prims change column `CameraAtOffsetY` `CameraAtOffsetY` double NOT NULL default '0';
  37. alter table prims change column `CameraAtOffsetZ` `CameraAtOffsetZ` double NOT NULL default '0';
  38. alter table prims change column `CollisionSoundVolume` `CollisionSoundVolume` double NOT NULL default '0';
  39. commit;