From 5f8e241e81620e48b59c0b08d6fb74133c0385bc Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Fri, 3 Oct 2008 12:36:54 +0000
Subject: fix the sqlite break.  There were two issue here:  1. type issues on
 column create in ado.net  2. not setting a field in the ado.net row
 translates into explicitely     setting it to null in sqlite land (because it
 can't read the defaults     stanzas out of the database)

Things should work again after this.


---
 OpenSim/Data/SQLite/SQLiteRegionData.cs | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/OpenSim/Data/SQLite/SQLiteRegionData.cs b/OpenSim/Data/SQLite/SQLiteRegionData.cs
index c6cd08f..c87d2e3 100644
--- a/OpenSim/Data/SQLite/SQLiteRegionData.cs
+++ b/OpenSim/Data/SQLite/SQLiteRegionData.cs
@@ -859,7 +859,7 @@ namespace OpenSim.Data.SQLite
             // click action
             createCol(prims, "ClickAction", typeof (Byte));
 
-            createCol(prims, "Material", typeof(Int32));
+            createCol(prims, "Material", typeof(Byte));
 
             // Add in contraints
             prims.PrimaryKey = new DataColumn[] {prims.Columns["UUID"]};
@@ -1535,6 +1535,7 @@ namespace OpenSim.Data.SQLite
             row["ClickAction"] = prim.ClickAction;
 
             row["SalePrice"] = prim.SalePrice;
+            row["Material"] = prim.Material;
         }
 
         /// <summary>
-- 
cgit v1.1