aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
diff options
context:
space:
mode:
authorSean Dague2007-08-28 12:34:00 +0000
committerSean Dague2007-08-28 12:34:00 +0000
commit6dd6ef3fa21e5a0673191505ba6bc04ee2c00db3 (patch)
tree4c5dabde8a44feb8988085f16eb60d2fa5b22f8d /OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
parentadded some more types that will be needed (diff)
downloadopensim-SC_OLD-6dd6ef3fa21e5a0673191505ba6bc04ee2c00db3.zip
opensim-SC_OLD-6dd6ef3fa21e5a0673191505ba6bc04ee2c00db3.tar.gz
opensim-SC_OLD-6dd6ef3fa21e5a0673191505ba6bc04ee2c00db3.tar.bz2
opensim-SC_OLD-6dd6ef3fa21e5a0673191505ba6bc04ee2c00db3.tar.xz
sqlite is storing now, uint64 makes things "interesting".
however lookup isn't working
Diffstat (limited to 'OpenSim/Framework/Data.SQLite/SQLiteUserData.cs')
-rw-r--r--OpenSim/Framework/Data.SQLite/SQLiteUserData.cs15
1 files changed, 8 insertions, 7 deletions
diff --git a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
index f1e5afa..d442784 100644
--- a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
+++ b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
@@ -199,6 +199,7 @@ namespace OpenSim.Framework.Data.SQLite
199 fillUserAgentRow(row, user.currentAgent); 199 fillUserAgentRow(row, user.currentAgent);
200 } 200 }
201 } 201 }
202 MainLog.Instance.Verbose("DATASTORE", "Adding user: " + ds.GetXml());
202 // save changes off to disk 203 // save changes off to disk
203 da.Update(ds, "users"); 204 da.Update(ds, "users");
204 } 205 }
@@ -299,7 +300,7 @@ namespace OpenSim.Framework.Data.SQLite
299 createCol(users, "passwordHash", typeof(System.String)); 300 createCol(users, "passwordHash", typeof(System.String));
300 createCol(users, "passwordSalt", typeof(System.String)); 301 createCol(users, "passwordSalt", typeof(System.String));
301 302
302 createCol(users, "homeRegion", typeof(System.UInt64)); 303 createCol(users, "homeRegion", typeof(System.Int64));
303 createCol(users, "homeLocationX", typeof(System.Double)); 304 createCol(users, "homeLocationX", typeof(System.Double));
304 createCol(users, "homeLocationY", typeof(System.Double)); 305 createCol(users, "homeLocationY", typeof(System.Double));
305 createCol(users, "homeLocationZ", typeof(System.Double)); 306 createCol(users, "homeLocationZ", typeof(System.Double));
@@ -311,8 +312,8 @@ namespace OpenSim.Framework.Data.SQLite
311 createCol(users, "rootInventoryFolderID", typeof(System.String)); 312 createCol(users, "rootInventoryFolderID", typeof(System.String));
312 createCol(users, "userInventoryURI", typeof(System.String)); 313 createCol(users, "userInventoryURI", typeof(System.String));
313 createCol(users, "userAssetURI", typeof(System.String)); 314 createCol(users, "userAssetURI", typeof(System.String));
314 createCol(users, "profileCanDoMask", typeof(System.UInt32)); 315 createCol(users, "profileCanDoMask", typeof(System.Int32));
315 createCol(users, "profileWantDoMask", typeof(System.UInt32)); 316 createCol(users, "profileWantDoMask", typeof(System.Int32));
316 createCol(users, "profileAboutText", typeof(System.String)); 317 createCol(users, "profileAboutText", typeof(System.String));
317 createCol(users, "profileFirstText", typeof(System.String)); 318 createCol(users, "profileFirstText", typeof(System.String));
318 createCol(users, "profileImage", typeof(System.String)); 319 createCol(users, "profileImage", typeof(System.String));
@@ -328,7 +329,7 @@ namespace OpenSim.Framework.Data.SQLite
328 // this is the UUID of the user 329 // this is the UUID of the user
329 createCol(ua, "UUID", typeof(System.String)); 330 createCol(ua, "UUID", typeof(System.String));
330 createCol(ua, "agentIP", typeof(System.String)); 331 createCol(ua, "agentIP", typeof(System.String));
331 createCol(ua, "agentPort", typeof(System.UInt32)); 332 createCol(ua, "agentPort", typeof(System.Int32));
332 createCol(ua, "agentOnline", typeof(System.Boolean)); 333 createCol(ua, "agentOnline", typeof(System.Boolean));
333 createCol(ua, "sessionID", typeof(System.String)); 334 createCol(ua, "sessionID", typeof(System.String));
334 createCol(ua, "secureSessionID", typeof(System.String)); 335 createCol(ua, "secureSessionID", typeof(System.String));
@@ -336,7 +337,7 @@ namespace OpenSim.Framework.Data.SQLite
336 createCol(ua, "loginTime", typeof(System.Int32)); 337 createCol(ua, "loginTime", typeof(System.Int32));
337 createCol(ua, "logoutTime", typeof(System.Int32)); 338 createCol(ua, "logoutTime", typeof(System.Int32));
338 createCol(ua, "currentRegion", typeof(System.String)); 339 createCol(ua, "currentRegion", typeof(System.String));
339 createCol(ua, "currentHandle", typeof(System.UInt32)); 340 createCol(ua, "currentHandle", typeof(System.Int32));
340 // vectors 341 // vectors
341 createCol(ua, "currentPosX", typeof(System.Double)); 342 createCol(ua, "currentPosX", typeof(System.Double));
342 createCol(ua, "currentPosY", typeof(System.Double)); 343 createCol(ua, "currentPosY", typeof(System.Double));
@@ -661,9 +662,9 @@ namespace OpenSim.Framework.Data.SQLite
661 } else if (type == typeof(System.UInt32)) { 662 } else if (type == typeof(System.UInt32)) {
662 return "integer"; 663 return "integer";
663 } else if (type == typeof(System.Int64)) { 664 } else if (type == typeof(System.Int64)) {
664 return "integer"; 665 return "varchar(255)";
665 } else if (type == typeof(System.UInt64)) { 666 } else if (type == typeof(System.UInt64)) {
666 return "integer"; 667 return "varchar(255)";
667 } else if (type == typeof(System.Double)) { 668 } else if (type == typeof(System.Double)) {
668 return "float"; 669 return "float";
669 } else if (type == typeof(System.Byte[])) { 670 } else if (type == typeof(System.Byte[])) {