From: Chris Yeoh <cyeoh@au1.ibm.com>

The attached patch implements llPassTouches. It has been added
to the export/import XML along with the flag for AllowedInventoryDrop.

The MySQL backend has been updated as well, though I haven't
done one of those before so could do with a check. I added
the migration mysql file as well.

The other data backends need updating as well.

2 files changed, 17 insertions, 2 deletions

diff --git a/OpenSim/Data/MySQL/MySQLRegionData.cs b/OpenSim/Data/MySQL/MySQLRegionData.cs
index b13813f..8a24fec 100644
--- a/OpenSim/Data/MySQL/MySQLRegionData.cs
+++ b/OpenSim/Data/MySQL/MySQLRegionData.cs
@@ -196,6 +196,7 @@ namespace OpenSim.Data.MySQL
                             "ColorR, ColorG, ColorB, ColorA, "+
                             "ParticleSystem, ClickAction, Material, "+
                             "CollisionSound, CollisionSoundVolume, "+
+                            "PassTouches, "+
                             "LinkNumber) values (" + "?UUID, "+
                             "?CreationDate, ?Name, ?Text, "+
                             "?Description, ?SitName, ?TouchName, "+
@@ -227,7 +228,7 @@ namespace OpenSim.Data.MySQL
                             "?SaleType, ?ColorR, ?ColorG, "+
                             "?ColorB, ?ColorA, ?ParticleSystem, "+
                             "?ClickAction, ?Material, ?CollisionSound, "+
-                            "?CollisionSoundVolume, ?LinkNumber)";
+                            "?CollisionSoundVolume, ?PassTouches, ?LinkNumber)";
 
                     FillPrimCommand(cmd, prim, obj.UUID, regionUUID);
 
@@ -950,6 +951,9 @@ namespace OpenSim.Data.MySQL
 
             prim.CollisionSound = new UUID(row["CollisionSound"].ToString());
             prim.CollisionSoundVolume = Convert.ToSingle(row["CollisionSoundVolume"]);
+            
+            if (Convert.ToInt16(row["PassTouches"]) != 0)
+                prim.PassTouches = true;
             prim.LinkNum = Convert.ToInt32(row["LinkNumber"]);
 
             return prim;
@@ -1272,6 +1276,12 @@ namespace OpenSim.Data.MySQL
 
             cmd.Parameters.AddWithValue("CollisionSound", prim.CollisionSound.ToString());
             cmd.Parameters.AddWithValue("CollisionSoundVolume", prim.CollisionSoundVolume);
+
+            if (prim.PassTouches)
+                cmd.Parameters.AddWithValue("PassTouches", 1);
+            else
+                cmd.Parameters.AddWithValue("PassTouches", 0);
+
             cmd.Parameters.AddWithValue("LinkNumber", prim.LinkNum);
         }
 
@@ -1534,4 +1544,4 @@ namespace OpenSim.Data.MySQL
             }
         }
     }
-}
\ No newline at end of file
+}
diff --git a/OpenSim/Data/MySQL/Resources/029_RegionStore.sql b/OpenSim/Data/MySQL/Resources/029_RegionStore.sql
new file mode 100644
index 0000000..b5962a2
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/029_RegionStore.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE prims ADD COLUMN PassTouches tinyint not null default 0;
+
+COMMIT;