aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
authorHomer Horwitz2008-09-16 18:59:13 +0000
committerHomer Horwitz2008-09-16 18:59:13 +0000
commite3cbde0f3910c483ebe020089021575fa00959ea (patch)
tree88856ec3d829503967a238c7301cd7e06551aacc /OpenSim/Data/SQLite/Resources
parent* Apply http://opensimulator.org/mantis/view.php?id=2205 with a few small tweaks (diff)
downloadopensim-SC_OLD-e3cbde0f3910c483ebe020089021575fa00959ea.zip
opensim-SC_OLD-e3cbde0f3910c483ebe020089021575fa00959ea.tar.gz
opensim-SC_OLD-e3cbde0f3910c483ebe020089021575fa00959ea.tar.bz2
opensim-SC_OLD-e3cbde0f3910c483ebe020089021575fa00959ea.tar.xz
Mantis #904: Thanks jonc, for a patch that adds "useragents" table to
SQLite and stores the logout position in standalone mode. Note: This adds a migration for SQLite, so do your runprebuild
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/006_UserStore.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/006_UserStore.sql b/OpenSim/Data/SQLite/Resources/006_UserStore.sql
new file mode 100644
index 0000000..f9454c5
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/006_UserStore.sql
@@ -0,0 +1,20 @@
1BEGIN TRANSACTION;
2
3-- usersagents table
4CREATE TABLE IF NOT EXISTS useragents(
5 UUID varchar(255) primary key,
6 agentIP varchar(255),
7 agentPort integer,
8 agentOnline boolean,
9 sessionID varchar(255),
10 secureSessionID varchar(255),
11 regionID varchar(255),
12 loginTime integer,
13 logoutTime integer,
14 currentRegion varchar(255),
15 currentHandle varchar(255),
16 currentPosX float,
17 currentPosY float,
18 currentPosZ float);
19
20COMMIT;