From b0ee8fc271fdb12958c91f9e567ed21d35472f8d Mon Sep 17 00:00:00 2001
From: Charles Krinke
Date: Wed, 19 Nov 2008 23:57:19 +0000
Subject: Mantis#2658. Thank you kindly, StrawberryFride for a patch that:
 Keeping up with MySQL and SQLite. Small code changes and another resource
 file to add.

---
 OpenSim/Data/MSSQL/MSSQLRegionData.cs            | 6 ++++++
 OpenSim/Data/MSSQL/Resources/011_RegionStore.sql | 6 ++++++
 2 files changed, 12 insertions(+)
 create mode 100644 OpenSim/Data/MSSQL/Resources/011_RegionStore.sql

(limited to 'OpenSim/Data/MSSQL')

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
             if (!primRow.IsNull("ClickAction"))
                 prim.ClickAction = Convert.ToByte(primRow["ClickAction"]);
 
+            prim.CollisionSound = new UUID(primRow["CollisionSound"].ToString());
+            prim.CollisionSoundVolume = Convert.ToSingle(primRow["CollisionSoundVolume"]);
+
             return prim;
         }
 
@@ -1419,6 +1422,9 @@ VALUES
             row["ClickAction"] = clickAction;
 
             row["Material"] = prim.Material;
+
+            row["CollisionSound"] = prim.CollisionSound.ToString();
+            row["CollisionSoundVolume"] = prim.CollisionSoundVolume;
         }
 
         /// <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 @@
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD CollisionSound char(36) not null default '00000000-0000-0000-0000-000000000000'
+ALTER TABLE prims ADD CollisionSoundVolume float not null default 0.0
+
+COMMIT
-- 
cgit v1.1