aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_UserStore.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_UserStore.sql64
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 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3-- users table
3CREATE TABLE users( 4CREATE 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
30CREATE TABLE userfriends( 31CREATE 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
37COMMIT; 38COMMIT;
39