diff options
author | Melanie Thielker | 2008-11-26 09:05:11 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-11-26 09:05:11 +0000 |
commit | 841c53003f74ef98f50590d854df7a199803dc36 (patch) | |
tree | 2fa3186b3694597253f5680c5c7a8a13e8ba2f51 /OpenSim/Data/MySQL/Resources/024_RegionStore.sql | |
parent | Fix 2 of the failed tests. Cause terrain queries to return null when no (diff) | |
download | opensim-SC-841c53003f74ef98f50590d854df7a199803dc36.zip opensim-SC-841c53003f74ef98f50590d854df7a199803dc36.tar.gz opensim-SC-841c53003f74ef98f50590d854df7a199803dc36.tar.bz2 opensim-SC-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....
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/024_RegionStore.sql | 18 |
1 files changed, 18 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 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | alter table regionsettings change column `object_bonus` `object_bonus` double NOT NULL; | ||
4 | alter table regionsettings change column `elevation_1_nw` `elevation_1_nw` double NOT NULL; | ||
5 | alter table regionsettings change column `elevation_2_nw` `elevation_2_nw` double NOT NULL; | ||
6 | alter table regionsettings change column `elevation_1_ne` `elevation_1_ne` double NOT NULL; | ||
7 | alter table regionsettings change column `elevation_2_ne` `elevation_2_ne` double NOT NULL; | ||
8 | alter table regionsettings change column `elevation_1_se` `elevation_1_se` double NOT NULL; | ||
9 | alter table regionsettings change column `elevation_2_se` `elevation_2_se` double NOT NULL; | ||
10 | alter table regionsettings change column `elevation_1_sw` `elevation_1_sw` double NOT NULL; | ||
11 | alter table regionsettings change column `elevation_2_sw` `elevation_2_sw` double NOT NULL; | ||
12 | alter table regionsettings change column `water_height` `water_height` double NOT NULL; | ||
13 | alter table regionsettings change column `terrain_raise_limit` `terrain_raise_limit` double NOT NULL; | ||
14 | alter table regionsettings change column `terrain_lower_limit` `terrain_lower_limit` double NOT NULL; | ||
15 | alter table regionsettings change column `sun_position` `sun_position` double NOT NULL; | ||
16 | |||
17 | COMMIT; | ||
18 | |||