aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite
diff options
context:
space:
mode:
authorSean Dague2008-11-04 14:54:42 +0000
committerSean Dague2008-11-04 14:54:42 +0000
commit702249358badda5413e67ee0267063c2e2a61498 (patch)
tree42775e792f77d391e5ad730b2bb15f65da3e96d1 /OpenSim/Data/SQLite
parentPrefix LSL variables which are C# keywords with @ instead of _ when translati... (diff)
downloadopensim-SC_OLD-702249358badda5413e67ee0267063c2e2a61498.zip
opensim-SC_OLD-702249358badda5413e67ee0267063c2e2a61498.tar.gz
opensim-SC_OLD-702249358badda5413e67ee0267063c2e2a61498.tar.bz2
opensim-SC_OLD-702249358badda5413e67ee0267063c2e2a61498.tar.xz
implement email field for MySQL and SQLite
From: Sean Dague <sdague@gmail.com>
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