aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLRegionData.cs6
-rw-r--r--OpenSim/Data/MSSQL/Resources/011_RegionStore.sql6
2 files changed, 12 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLRegionData.cs b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
index 5faaec4..6298a19 100644
--- a/OpenSim/Data/MSSQL/MSSQLRegionData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
@@ -1048,6 +1048,9 @@ VALUES
1048 if (!primRow.IsNull("ClickAction")) 1048 if (!primRow.IsNull("ClickAction"))
1049 prim.ClickAction = Convert.ToByte(primRow["ClickAction"]); 1049 prim.ClickAction = Convert.ToByte(primRow["ClickAction"]);
1050 1050
1051 prim.CollisionSound = new UUID(primRow["CollisionSound"].ToString());
1052 prim.CollisionSoundVolume = Convert.ToSingle(primRow["CollisionSoundVolume"]);
1053
1051 return prim; 1054 return prim;
1052 } 1055 }
1053 1056
@@ -1419,6 +1422,9 @@ VALUES
1419 row["ClickAction"] = clickAction; 1422 row["ClickAction"] = clickAction;
1420 1423
1421 row["Material"] = prim.Material; 1424 row["Material"] = prim.Material;
1425
1426 row["CollisionSound"] = prim.CollisionSound.ToString();
1427 row["CollisionSoundVolume"] = prim.CollisionSoundVolume;
1422 } 1428 }
1423 1429
1424 /// <summary> 1430 /// <summary>
diff --git a/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql
new file mode 100644
index 0000000..2218216
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/011_RegionStore.sql
@@ -0,0 +1,6 @@
1BEGIN TRANSACTION
2
3ALTER TABLE prims ADD CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'
4ALTER TABLE prims ADD CollisionSoundVolume float not null default 0.0
5
6COMMIT