aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite
diff options
context:
space:
mode:
authorMelanie Thielker2008-08-15 22:49:26 +0000
committerMelanie Thielker2008-08-15 22:49:26 +0000
commit04488d9d3819fd16502a095771d1513af02b7a93 (patch)
tree03e4673e0be665d07b45a456e8df2f11a0778bf2 /OpenSim/Data/SQLite
parentPantis #1957 (diff)
downloadopensim-SC_OLD-04488d9d3819fd16502a095771d1513af02b7a93.zip
opensim-SC_OLD-04488d9d3819fd16502a095771d1513af02b7a93.tar.gz
opensim-SC_OLD-04488d9d3819fd16502a095771d1513af02b7a93.tar.bz2
opensim-SC_OLD-04488d9d3819fd16502a095771d1513af02b7a93.tar.xz
Plumb in the partner and the account title fields for profile info.
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r--OpenSim/Data/SQLite/Resources/004_UserStore.sql6
-rw-r--r--OpenSim/Data/SQLite/SQLiteUserData.cs6
2 files changed, 12 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/004_UserStore.sql b/OpenSim/Data/SQLite/Resources/004_UserStore.sql
new file mode 100644
index 0000000..03142af
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/004_UserStore.sql
@@ -0,0 +1,6 @@
1BEGIN;
2
3ALTER TABLE users add customType varchar(32) not null default '';
4ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000';
5
6COMMIT;
diff --git a/OpenSim/Data/SQLite/SQLiteUserData.cs b/OpenSim/Data/SQLite/SQLiteUserData.cs
index c55eee8..910d313 100644
--- a/OpenSim/Data/SQLite/SQLiteUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteUserData.cs
@@ -683,6 +683,8 @@ namespace OpenSim.Data.SQLite
683 SQLiteUtil.createCol(users, "webLoginKey", typeof(String)); 683 SQLiteUtil.createCol(users, "webLoginKey", typeof(String));
684 SQLiteUtil.createCol(users, "userFlags", typeof (Int32)); 684 SQLiteUtil.createCol(users, "userFlags", typeof (Int32));
685 SQLiteUtil.createCol(users, "godLevel", typeof (Int32)); 685 SQLiteUtil.createCol(users, "godLevel", typeof (Int32));
686 SQLiteUtil.createCol(users, "customType", typeof (String));
687 SQLiteUtil.createCol(users, "partner", typeof (String));
686 // Add in contraints 688 // Add in contraints
687 users.PrimaryKey = new DataColumn[] {users.Columns["UUID"]}; 689 users.PrimaryKey = new DataColumn[] {users.Columns["UUID"]};
688 return users; 690 return users;
@@ -793,6 +795,8 @@ namespace OpenSim.Data.SQLite
793 user.WebLoginKey = new LLUUID((String) row["webLoginKey"]); 795 user.WebLoginKey = new LLUUID((String) row["webLoginKey"]);
794 user.UserFlags = Convert.ToInt32(row["userFlags"]); 796 user.UserFlags = Convert.ToInt32(row["userFlags"]);
795 user.GodLevel = Convert.ToInt32(row["godLevel"]); 797 user.GodLevel = Convert.ToInt32(row["godLevel"]);
798 user.CustomType = row["customType"].ToString();
799 user.Partner = new LLUUID((String) row["partner"]);
796 800
797 return user; 801 return user;
798 } 802 }
@@ -835,6 +839,8 @@ namespace OpenSim.Data.SQLite
835 row["webLoginKey"] = user.WebLoginKey; 839 row["webLoginKey"] = user.WebLoginKey;
836 row["userFlags"] = user.UserFlags; 840 row["userFlags"] = user.UserFlags;
837 row["godLevel"] = user.GodLevel; 841 row["godLevel"] = user.GodLevel;
842 row["customType"] = user.CustomType;
843 row["partner"] = user.Partner.ToString();
838 844
839 // ADO.NET doesn't handle NULL very well 845 // ADO.NET doesn't handle NULL very well
840 foreach (DataColumn col in ds.Tables["users"].Columns) 846 foreach (DataColumn col in ds.Tables["users"].Columns)