diff options
author | AlexRa | 2010-05-01 17:43:10 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:06 +0300 |
commit | e4419c34c30e1cf6529ced125f0c05aed24644a4 (patch) | |
tree | b54d5aff69c63fefc27dea2b938c1838974d77ac /OpenSim/Data/MySQL/Resources/025_RegionStore.sql | |
parent | Added MySqlMigrations.cs (supports stored proc/funcs) (diff) | |
download | opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.zip opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.gz opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.bz2 opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.xz |
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more
readable, single-file-per-store
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/025_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/025_RegionStore.sql | 46 |
1 files changed, 0 insertions, 46 deletions
diff --git a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql b/OpenSim/Data/MySQL/Resources/025_RegionStore.sql deleted file mode 100644 index e8f5d70..0000000 --- a/OpenSim/Data/MySQL/Resources/025_RegionStore.sql +++ /dev/null | |||
@@ -1,46 +0,0 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | alter table prims change column `PositionX` `PositionX` double default NULL; | ||
4 | alter table prims change column `PositionY` `PositionY` double default NULL; | ||
5 | alter table prims change column `PositionZ` `PositionZ` double default NULL; | ||
6 | alter table prims change column `GroupPositionX` `GroupPositionX` double default NULL; | ||
7 | alter table prims change column `GroupPositionY` `GroupPositionY` double default NULL; | ||
8 | alter table prims change column `GroupPositionZ` `GroupPositionZ` double default NULL; | ||
9 | alter table prims change column `VelocityX` `VelocityX` double default NULL; | ||
10 | alter table prims change column `VelocityY` `VelocityY` double default NULL; | ||
11 | alter table prims change column `VelocityZ` `VelocityZ` double default NULL; | ||
12 | alter table prims change column `AngularVelocityX` `AngularVelocityX` double default NULL; | ||
13 | alter table prims change column `AngularVelocityY` `AngularVelocityY` double default NULL; | ||
14 | alter table prims change column `AngularVelocityZ` `AngularVelocityZ` double default NULL; | ||
15 | alter table prims change column `AccelerationX` `AccelerationX` double default NULL; | ||
16 | alter table prims change column `AccelerationY` `AccelerationY` double default NULL; | ||
17 | alter table prims change column `AccelerationZ` `AccelerationZ` double default NULL; | ||
18 | alter table prims change column `RotationX` `RotationX` double default NULL; | ||
19 | alter table prims change column `RotationY` `RotationY` double default NULL; | ||
20 | alter table prims change column `RotationZ` `RotationZ` double default NULL; | ||
21 | alter table prims change column `RotationW` `RotationW` double default NULL; | ||
22 | alter table prims change column `SitTargetOffsetX` `SitTargetOffsetX` double default NULL; | ||
23 | alter table prims change column `SitTargetOffsetY` `SitTargetOffsetY` double default NULL; | ||
24 | alter table prims change column `SitTargetOffsetZ` `SitTargetOffsetZ` double default NULL; | ||
25 | alter table prims change column `SitTargetOrientW` `SitTargetOrientW` double default NULL; | ||
26 | alter table prims change column `SitTargetOrientX` `SitTargetOrientX` double default NULL; | ||
27 | alter table prims change column `SitTargetOrientY` `SitTargetOrientY` double default NULL; | ||
28 | alter table prims change column `SitTargetOrientZ` `SitTargetOrientZ` double default NULL; | ||
29 | alter table prims change column `LoopedSoundGain` `LoopedSoundGain` double 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` double 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` double 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` double 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` double 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` 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'; | ||
44 | |||
45 | COMMIT; | ||
46 | |||