diff options
author | Justin Clark-Casey (justincc) | 2010-06-04 18:00:48 +0100 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2010-06-04 18:00:48 +0100 |
commit | 2f6d401db13b31c6cac7450266dade6e678c8aa6 (patch) | |
tree | 8ae3f924dfecbea30835d0172ac5464c6b8325b6 /OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql | |
parent | Revert "Next OSG test. Don't remove app domains if they contain running threa... (diff) | |
parent | switch 0.6.9 flavour to release (diff) | |
download | opensim-SC-2f6d401db13b31c6cac7450266dade6e678c8aa6.zip opensim-SC-2f6d401db13b31c6cac7450266dade6e678c8aa6.tar.gz opensim-SC-2f6d401db13b31c6cac7450266dade6e678c8aa6.tar.bz2 opensim-SC-2f6d401db13b31c6cac7450266dade6e678c8aa6.tar.xz |
Merge remote branch 'origin/0.6.9' into 0.6.9-post-fixes
This chiefly brings in the new sqlite adaptor and renames the old one to SQLiteLegacy
Existing configuratios should continue to work without changes unless you are using Mac OSX and mono 2.6 or later, in which case you will need to enable SQLiteLegacy instead. Please se the instructions in OpenSim.ini.example and the relevant config/include .ini files
Conflicts:
OpenSim/Framework/Servers/VersionInfo.cs
OpenSim/Region/Framework/Scenes/Scene.Inventory.cs
Diffstat (limited to 'OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql')
-rw-r--r-- | OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql b/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql new file mode 100644 index 0000000..b584594 --- /dev/null +++ b/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql | |||
@@ -0,0 +1,39 @@ | |||
1 | BEGIN TRANSACTION; | ||
2 | |||
3 | -- users table | ||
4 | CREATE TABLE users( | ||
5 | UUID varchar(255) primary key, | ||
6 | username varchar(255), | ||
7 | surname varchar(255), | ||
8 | passwordHash varchar(255), | ||
9 | passwordSalt varchar(255), | ||
10 | homeRegionX integer, | ||
11 | homeRegionY integer, | ||
12 | homeLocationX float, | ||
13 | homeLocationY float, | ||
14 | homeLocationZ float, | ||
15 | homeLookAtX float, | ||
16 | homeLookAtY float, | ||
17 | homeLookAtZ float, | ||
18 | created integer, | ||
19 | lastLogin integer, | ||
20 | rootInventoryFolderID varchar(255), | ||
21 | userInventoryURI varchar(255), | ||
22 | userAssetURI varchar(255), | ||
23 | profileCanDoMask integer, | ||
24 | profileWantDoMask integer, | ||
25 | profileAboutText varchar(255), | ||
26 | profileFirstText varchar(255), | ||
27 | profileImage varchar(255), | ||
28 | profileFirstImage varchar(255), | ||
29 | webLoginKey text default '00000000-0000-0000-0000-000000000000'); | ||
30 | -- friends table | ||
31 | CREATE TABLE userfriends( | ||
32 | ownerID varchar(255), | ||
33 | friendID varchar(255), | ||
34 | friendPerms integer, | ||
35 | ownerPerms integer, | ||
36 | datetimestamp integer); | ||
37 | |||
38 | COMMIT; | ||
39 | |||