diff options
author | Justin Clark-Casey (justincc) | 2014-03-26 20:34:04 +0000 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2014-03-26 20:34:04 +0000 |
commit | 5e8dfb4f7edaf1125eed4b80c1b535fd460f9ebd (patch) | |
tree | 115a2779904acb72e3213d3c517e8b21a20b0a76 /OpenSim/Data/MSSQL/Resources/RegionStore.migrations | |
parent | Reinsert code to extract size_x and size_y parameters from GetHomeRegion resp... (diff) | |
download | opensim-SC_OLD-5e8dfb4f7edaf1125eed4b80c1b535fd460f9ebd.zip opensim-SC_OLD-5e8dfb4f7edaf1125eed4b80c1b535fd460f9ebd.tar.gz opensim-SC_OLD-5e8dfb4f7edaf1125eed4b80c1b535fd460f9ebd.tar.bz2 opensim-SC_OLD-5e8dfb4f7edaf1125eed4b80c1b535fd460f9ebd.tar.xz |
Fix extra physics params MSSQL migration (version 39).
This was failing because it used MySQL syntax
This is taken from Lucius Sirnah's entry in http://opensimulator.org/mantis/view.php?id=6593
But with the column existence checking removed, as this should not be necessary in a migration and is inconsistent with all other migrations, though I can see a case for doing it.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations index bb89884..46b1988 100644 --- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations | |||
@@ -1161,11 +1161,11 @@ COMMIT | |||
1161 | 1161 | ||
1162 | BEGIN TRANSACTION | 1162 | BEGIN TRANSACTION |
1163 | 1163 | ||
1164 | ALTER TABLE prims ADD `PhysicsShapeType` tinyint(4) NOT NULL default '0'; | 1164 | ALTER TABLE prims ADD PhysicsShapeType tinyint NOT NULL default 0; |
1165 | ALTER TABLE prims ADD `Density` double NOT NULL default '1000'; | 1165 | ALTER TABLE prims ADD Density float NOT NULL default 1000; |
1166 | ALTER TABLE prims ADD `GravityModifier` double NOT NULL default '1'; | 1166 | ALTER TABLE prims ADD GravityModifier float NOT NULL default 1; |
1167 | ALTER TABLE prims ADD `Friction` double NOT NULL default '0.6'; | 1167 | ALTER TABLE prims ADD Friction float NOT NULL default 0.6; |
1168 | ALTER TABLE prims ADD `Restitution` double NOT NULL default '0.5'; | 1168 | ALTER TABLE prims ADD Restitution float NOT NULL default 0.5; |
1169 | 1169 | ||
1170 | COMMIT | 1170 | COMMIT |
1171 | 1171 | ||