implement email field for MySQL and SQLite

From: Sean Dague <sdague@gmail.com>

2 files changed, 8 insertions, 0 deletions

diff --git a/OpenSim/Data/SQLite/Resources/008_UserStore.sql b/OpenSim/Data/SQLite/Resources/008_UserStore.sql
new file mode 100644
index 0000000..97da818
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/008_UserStore.sql
@@ -0,0 +1,5 @@
+BEGIN TRANSACTION;
+
+ALTER TABLE users add email varchar(250);
+
+COMMIT;
diff --git a/OpenSim/Data/SQLite/SQLiteUserData.cs b/OpenSim/Data/SQLite/SQLiteUserData.cs
index 2f0863e..50a1d73 100644
--- a/OpenSim/Data/SQLite/SQLiteUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteUserData.cs
@@ -710,6 +710,7 @@ namespace OpenSim.Data.SQLite
             SQLiteUtil.createCol(users, "UUID", typeof (String));
             SQLiteUtil.createCol(users, "username", typeof (String));
             SQLiteUtil.createCol(users, "surname", typeof (String));
+            SQLiteUtil.createCol(users, "email", typeof (String));
             SQLiteUtil.createCol(users, "passwordHash", typeof (String));
             SQLiteUtil.createCol(users, "passwordSalt", typeof (String));
 
@@ -812,6 +813,7 @@ namespace OpenSim.Data.SQLite
             user.ID = tmp;
             user.FirstName = (String) row["username"];
             user.SurName = (String) row["surname"];
+            user.Email = (String) row["email"];
             user.PasswordHash = (String) row["passwordHash"];
             user.PasswordSalt = (String) row["passwordSalt"];
 
@@ -864,6 +866,7 @@ namespace OpenSim.Data.SQLite
             row["UUID"] = Util.ToRawUuidString(user.ID);
             row["username"] = user.FirstName;
             row["surname"] = user.SurName;
+            row["email"] = user.Email;
             row["passwordHash"] = user.PasswordHash;
             row["passwordSalt"] = user.PasswordSalt;