aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite')
-rw-r--r--OpenSim/Data/SQLite/Resources/008_UserStore.sql5
-rw-r--r--OpenSim/Data/SQLite/SQLiteUserData.cs3
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 @@
1BEGIN TRANSACTION;
2
3ALTER TABLE users add email varchar(250);
4
5COMMIT;
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
710 SQLiteUtil.createCol(users, "UUID", typeof (String)); 710 SQLiteUtil.createCol(users, "UUID", typeof (String));
711 SQLiteUtil.createCol(users, "username", typeof (String)); 711 SQLiteUtil.createCol(users, "username", typeof (String));
712 SQLiteUtil.createCol(users, "surname", typeof (String)); 712 SQLiteUtil.createCol(users, "surname", typeof (String));
713 SQLiteUtil.createCol(users, "email", typeof (String));
713 SQLiteUtil.createCol(users, "passwordHash", typeof (String)); 714 SQLiteUtil.createCol(users, "passwordHash", typeof (String));
714 SQLiteUtil.createCol(users, "passwordSalt", typeof (String)); 715 SQLiteUtil.createCol(users, "passwordSalt", typeof (String));
715 716
@@ -812,6 +813,7 @@ namespace OpenSim.Data.SQLite
812 user.ID = tmp; 813 user.ID = tmp;
813 user.FirstName = (String) row["username"]; 814 user.FirstName = (String) row["username"];
814 user.SurName = (String) row["surname"]; 815 user.SurName = (String) row["surname"];
816 user.Email = (String) row["email"];
815 user.PasswordHash = (String) row["passwordHash"]; 817 user.PasswordHash = (String) row["passwordHash"];
816 user.PasswordSalt = (String) row["passwordSalt"]; 818 user.PasswordSalt = (String) row["passwordSalt"];
817 819
@@ -864,6 +866,7 @@ namespace OpenSim.Data.SQLite
864 row["UUID"] = Util.ToRawUuidString(user.ID); 866 row["UUID"] = Util.ToRawUuidString(user.ID);
865 row["username"] = user.FirstName; 867 row["username"] = user.FirstName;
866 row["surname"] = user.SurName; 868 row["surname"] = user.SurName;
869 row["email"] = user.Email;
867 row["passwordHash"] = user.PasswordHash; 870 row["passwordHash"] = user.PasswordHash;
868 row["passwordSalt"] = user.PasswordSalt; 871 row["passwordSalt"] = user.PasswordSalt;
869 872