diff options
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; | ||