some changes which get us closer to Sqlite storage for users

1 files changed, 6 insertions, 3 deletions

diff --git a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
index bba5791..48dac87 100644
--- a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
+++ b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
@@ -300,7 +300,8 @@ namespace OpenSim.Framework.Data.SQLite
             createCol(users, "passwordHash", typeof(System.String));
             createCol(users, "passwordSalt", typeof(System.String));
 
-            createCol(users, "homeRegion", typeof(System.Int64));
+            createCol(users, "homeRegionX", typeof(System.Int32));
+            createCol(users, "homeRegionY", typeof(System.Int32));
             createCol(users, "homeLocationX", typeof(System.Double));
             createCol(users, "homeLocationY", typeof(System.Double));
             createCol(users, "homeLocationZ", typeof(System.Double));
@@ -368,7 +369,8 @@ namespace OpenSim.Framework.Data.SQLite
             user.passwordHash = (String)row["passwordHash"];
             user.passwordSalt = (String)row["passwordSalt"];
 
-            // user.homeRegion = Convert.ToUInt64(row["homeRegion"]);
+            user.homeRegionX = Convert.ToUInt32(row["homeRegionX"]);
+            user.homeRegionY = Convert.ToUInt32(row["homeRegionY"]);
             user.homeLocation = new LLVector3(
                                               Convert.ToSingle(row["homeLocationX"]),
                                               Convert.ToSingle(row["homeLocationY"]),
@@ -402,7 +404,8 @@ namespace OpenSim.Framework.Data.SQLite
             row["passwordSalt"] = user.passwordSalt;
             
             
-            row["homeRegion"] = user.homeRegion;
+            row["homeRegionX"] = user.homeRegionX;
+            row["homeRegionY"] = user.homeRegionY;
             row["homeLocationX"] = user.homeLocation.X;
             row["homeLocationY"] = user.homeLocation.Y;
             row["homeLocationZ"] = user.homeLocation.Z;