diff options
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/001_UserStore.sql')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/001_UserStore.sql | 64 |
1 files changed, 33 insertions, 31 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_UserStore.sql b/OpenSim/Data/SQLite/Resources/001_UserStore.sql index 070e340..b584594 100644 --- a/OpenSim/Data/SQLite/Resources/001_UserStore.sql +++ b/OpenSim/Data/SQLite/Resources/001_UserStore.sql | |||
@@ -1,37 +1,39 @@ | |||
1 | BEGIN TRANSACTION; | 1 | BEGIN TRANSACTION; |
2 | 2 | ||
3 | -- users table | ||
3 | CREATE TABLE users( | 4 | CREATE TABLE users( |
4 | UUID varchar(255) primary key, | 5 | UUID varchar(255) primary key, |
5 | username varchar(255), | 6 | username varchar(255), |
6 | surname varchar(255), | 7 | surname varchar(255), |
7 | passwordHash varchar(255), | 8 | passwordHash varchar(255), |
8 | passwordSalt varchar(255), | 9 | passwordSalt varchar(255), |
9 | homeRegionX integer, | 10 | homeRegionX integer, |
10 | homeRegionY integer, | 11 | homeRegionY integer, |
11 | homeLocationX float, | 12 | homeLocationX float, |
12 | homeLocationY float, | 13 | homeLocationY float, |
13 | homeLocationZ float, | 14 | homeLocationZ float, |
14 | homeLookAtX float, | 15 | homeLookAtX float, |
15 | homeLookAtY float, | 16 | homeLookAtY float, |
16 | homeLookAtZ float, | 17 | homeLookAtZ float, |
17 | created integer, | 18 | created integer, |
18 | lastLogin integer, | 19 | lastLogin integer, |
19 | rootInventoryFolderID varchar(255), | 20 | rootInventoryFolderID varchar(255), |
20 | userInventoryURI varchar(255), | 21 | userInventoryURI varchar(255), |
21 | userAssetURI varchar(255), | 22 | userAssetURI varchar(255), |
22 | profileCanDoMask integer, | 23 | profileCanDoMask integer, |
23 | profileWantDoMask integer, | 24 | profileWantDoMask integer, |
24 | profileAboutText varchar(255), | 25 | profileAboutText varchar(255), |
25 | profileFirstText varchar(255), | 26 | profileFirstText varchar(255), |
26 | profileImage varchar(255), | 27 | profileImage varchar(255), |
27 | profileFirstImage varchar(255), | 28 | profileFirstImage varchar(255), |
28 | webLoginKey text default '00000000-0000-0000-0000-000000000000'); | 29 | webLoginKey text default '00000000-0000-0000-0000-000000000000'); |
29 | 30 | -- friends table | |
30 | CREATE TABLE userfriends( | 31 | CREATE TABLE userfriends( |
31 | ownerID varchar(255), | 32 | ownerID varchar(255), |
32 | friendID varchar(255), | 33 | friendID varchar(255), |
33 | friendPerms integer, | 34 | friendPerms integer, |
34 | ownerPerms integer, | 35 | ownerPerms integer, |
35 | datetimestamp integer); | 36 | datetimestamp integer); |
36 | 37 | ||
37 | COMMIT; | 38 | COMMIT; |
39 | |||