From e3cbde0f3910c483ebe020089021575fa00959ea Mon Sep 17 00:00:00 2001
From: Homer Horwitz
Date: Tue, 16 Sep 2008 18:59:13 +0000
Subject: 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

---
 OpenSim/Data/SQLite/Resources/006_UserStore.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/006_UserStore.sql

(limited to 'OpenSim/Data/SQLite/Resources/006_UserStore.sql')

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 @@
+BEGIN TRANSACTION;
+
+-- usersagents table
+CREATE TABLE IF NOT EXISTS useragents(
+       UUID varchar(255) primary key,
+       agentIP varchar(255),
+       agentPort integer,
+       agentOnline boolean,
+       sessionID varchar(255),
+       secureSessionID varchar(255),
+       regionID varchar(255),
+       loginTime integer,
+       logoutTime integer,
+       currentRegion varchar(255),
+       currentHandle varchar(255),
+       currentPosX float,
+       currentPosY float,
+       currentPosZ float);
+
+COMMIT;
-- 
cgit v1.1