aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2011-04-07 23:16:36 +0100
committerJustin Clark-Casey (justincc)2011-04-07 23:20:04 +0100
commit9d40c0dcc70462d78d6347676927b05eed245a9a (patch)
tree2f7fb8f320a93c15dde9e1bf7ef53d4999743601 /OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql
parentBundle a built-from-source Mac OS X sqlite3 universal dylib with OpenSim and ... (diff)
downloadopensim-SC-9d40c0dcc70462d78d6347676927b05eed245a9a.zip
opensim-SC-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.gz
opensim-SC-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.bz2
opensim-SC-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.xz
Remove the SQLite legacy adaptor. This is no longer needed now that the main adaptor works on Mac OS X.
The SQLite legacy adapator was also not at all well maintained, even worse than the mainline sqlite adapator.
Diffstat (limited to 'OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql')
-rw-r--r--OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql39
1 files changed, 0 insertions, 39 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql b/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql
deleted file mode 100644
index b584594..0000000
--- a/OpenSim/Data/SQLiteLegacy/Resources/001_UserStore.sql
+++ /dev/null
@@ -1,39 +0,0 @@
1BEGIN TRANSACTION;
2
3-- users table
4CREATE 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
31CREATE TABLE userfriends(
32 ownerID varchar(255),
33 friendID varchar(255),
34 friendPerms integer,
35 ownerPerms integer,
36 datetimestamp integer);
37
38COMMIT;
39