diff options
author | Charles Krinke | 2009-01-11 18:24:16 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-11 18:24:16 +0000 |
commit | 40f34aeffd64e2aa81cecb2e861f60d6e8886198 (patch) | |
tree | 5d0059eb7aa70799c8239bb273efc997138cabb5 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | |
parent | Thank you kindly, Tlaukkan (Tommil) for a patch that: (diff) | |
download | opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.zip opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.gz opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.bz2 opensim-SC_OLD-40f34aeffd64e2aa81cecb2e861f60d6e8886198.tar.xz |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Fixed all NHibernate unit tests by implementing missing persistency
methods, tables, columns and fixing bugs in the existing implementation.
Two minor changes to classes outside NHibernate module: Added Scene
instantiation for SceneObjectGroup in OpenSim.Data.Tests.BasicRegionTest
as this was required by the NHibernate persistency. In the process added
also mock constructor to Scene which only populates RegionInfo in the scene
which is used by ScenePart.RegionUUID. NHibernate module is still in
experimental state and has not been tested at opensim region or ugaim runtime
configuration. Adding unit tests to build is not yet advisable nor using
NHibernate module in any production setup.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | 39 |
1 files changed, 34 insertions, 5 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql index 8d1ba5c..c5e42d5 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_UserStore.sql | |||
@@ -12,15 +12,24 @@ create table UserAgents ( | |||
12 | LoginTime INTEGER, | 12 | LoginTime INTEGER, |
13 | LogoutTime INTEGER, | 13 | LogoutTime INTEGER, |
14 | Handle INTEGER, | 14 | Handle INTEGER, |
15 | PositionX NUMERIC, | ||
16 | PositionY NUMERIC, | ||
17 | PositionZ NUMERIC, | ||
18 | LookAtX NUMERIC, | ||
19 | LookAtY NUMERIC, | ||
20 | LookAtZ NUMERIC, | ||
15 | primary key (ProfileID) | 21 | primary key (ProfileID) |
16 | ); | 22 | ); |
23 | |||
17 | create table UserProfiles ( | 24 | create table UserProfiles ( |
18 | ID TEXT not null, | 25 | ID TEXT not null, |
26 | WebLoginKey TEXT, | ||
19 | FirstName TEXT, | 27 | FirstName TEXT, |
20 | SurName TEXT, | 28 | SurName TEXT, |
29 | Email TEXT, | ||
21 | PasswordHash TEXT, | 30 | PasswordHash TEXT, |
22 | PasswordSalt TEXT, | 31 | PasswordSalt TEXT, |
23 | WebLoginKey TEXT, | 32 | HomeRegionID TEXT, |
24 | HomeRegionX INTEGER, | 33 | HomeRegionX INTEGER, |
25 | HomeRegionY INTEGER, | 34 | HomeRegionY INTEGER, |
26 | HomeLocationX NUMERIC, | 35 | HomeLocationX NUMERIC, |
@@ -31,15 +40,22 @@ create table UserProfiles ( | |||
31 | HomeLookAtZ NUMERIC, | 40 | HomeLookAtZ NUMERIC, |
32 | Created INTEGER, | 41 | Created INTEGER, |
33 | LastLogin INTEGER, | 42 | LastLogin INTEGER, |
34 | RootInventoryFolderID TEXT, | ||
35 | UserInventoryURI TEXT, | 43 | UserInventoryURI TEXT, |
36 | UserAssetURI TEXT, | 44 | UserAssetURI TEXT, |
37 | Image TEXT, | 45 | Image TEXT, |
38 | FirstLifeImage TEXT, | 46 | FirstLifeImage TEXT, |
39 | AboutText TEXT, | 47 | AboutText TEXT, |
40 | FirstLifeAboutText TEXT, | 48 | FirstLifeAboutText TEXT, |
49 | RootInventoryFolderID TEXT, | ||
50 | `CanDoMask` INTEGER, | ||
51 | `WantDoMask` INTEGER, | ||
52 | `UserFlags` INTEGER, | ||
53 | `GodLevel` INTEGER, | ||
54 | `CustomType` TEXT, | ||
55 | `Partner` TEXT, | ||
41 | primary key (ID) | 56 | primary key (ID) |
42 | ); | 57 | ); |
58 | |||
43 | create table UserAppearances ( | 59 | create table UserAppearances ( |
44 | Owner TEXT not null, | 60 | Owner TEXT not null, |
45 | BodyItem TEXT, | 61 | BodyItem TEXT, |
@@ -71,9 +87,22 @@ create table UserAppearances ( | |||
71 | Texture BLOB, | 87 | Texture BLOB, |
72 | VisualParams BLOB, | 88 | VisualParams BLOB, |
73 | Serial INTEGER, | 89 | Serial INTEGER, |
90 | AvatarHeight NUMERIC, | ||
74 | primary key (Owner) | 91 | primary key (Owner) |
75 | ); | 92 | ); |
76 | create index user_firstname on UserProfiles (FirstName); | ||
77 | create index user_surname on UserProfiles (SurName); | ||
78 | 93 | ||
79 | COMMIT; \ No newline at end of file | 94 | |
95 | CREATE TABLE UserFriends ( | ||
96 | UserFriendID TEXT, | ||
97 | OwnerID TEXT, | ||
98 | FriendID TEXT, | ||
99 | FriendPermissions INTEGER, | ||
100 | primary key (UserFriendID) | ||
101 | ); | ||
102 | |||
103 | create index UserFirstNameIndex on UserProfiles (FirstName); | ||
104 | create index UserSurnameIndex on UserProfiles (SurName); | ||
105 | create unique index UserFullNameIndex on UserProfiles (FirstName,SurName); | ||
106 | create unique index UserFriendsOwnerFriendIndex on UserFriends (OwnerID,FriendID); | ||
107 | |||
108 | COMMIT; | ||