diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/004_UserStore.sql | 6 | ||||
-rw-r--r-- | OpenSim/Data/SQLite/SQLiteUserData.cs | 6 |
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 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE users add customType varchar(32) not null default ''; | ||
4 | ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
5 | |||
6 | 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 | |||
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) |