diff options
Diffstat (limited to '')
| -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 | |||