From 04488d9d3819fd16502a095771d1513af02b7a93 Mon Sep 17 00:00:00 2001
From: Melanie Thielker
Date: Fri, 15 Aug 2008 22:49:26 +0000
Subject: Plumb in the partner and the account title fields for profile info.

---
 OpenSim/Data/SQLite/Resources/004_UserStore.sql | 6 ++++++
 OpenSim/Data/SQLite/SQLiteUserData.cs           | 6 ++++++
 2 files changed, 12 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/004_UserStore.sql

(limited to 'OpenSim/Data/SQLite')

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 @@
+BEGIN;
+
+ALTER TABLE users add customType varchar(32) not null default '';
+ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000';
+
+COMMIT;
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
             SQLiteUtil.createCol(users, "webLoginKey", typeof(String));
             SQLiteUtil.createCol(users, "userFlags", typeof (Int32));
             SQLiteUtil.createCol(users, "godLevel", typeof (Int32));
+            SQLiteUtil.createCol(users, "customType", typeof (String));
+            SQLiteUtil.createCol(users, "partner", typeof (String));
             // Add in contraints
             users.PrimaryKey = new DataColumn[] {users.Columns["UUID"]};
             return users;
@@ -793,6 +795,8 @@ namespace OpenSim.Data.SQLite
             user.WebLoginKey = new LLUUID((String) row["webLoginKey"]);
             user.UserFlags = Convert.ToInt32(row["userFlags"]);
             user.GodLevel = Convert.ToInt32(row["godLevel"]);
+            user.CustomType = row["customType"].ToString();
+            user.Partner = new LLUUID((String) row["partner"]);
 
             return user;
         }
@@ -835,6 +839,8 @@ namespace OpenSim.Data.SQLite
             row["webLoginKey"] = user.WebLoginKey;
             row["userFlags"] = user.UserFlags;
             row["godLevel"] = user.GodLevel;
+            row["customType"] = user.CustomType;
+            row["partner"] = user.Partner.ToString();
 
             // ADO.NET doesn't handle NULL very well
             foreach (DataColumn col in ds.Tables["users"].Columns)
-- 
cgit v1.1