From 818735ae2c52fc298ea7cc44951b9512ab330d35 Mon Sep 17 00:00:00 2001
From: Geir Nøklebye
Date: Mon, 3 Aug 2015 10:05:04 +0200
Subject: PGSL Presence migration to correct a double version 2 migration that
existed
The migration file had a version 2 migration defined twice and
therefore the LastSeen field most likely never was defined in the
presence file. This migration adds the field and migrates the table to
version 4.
Signed-off-by: Oren Hurvitz <orenh@kitely.com>
---
OpenSim/Data/PGSQL/Resources/Presence.migrations | 10 ++++++++++
1 file changed, 10 insertions(+)
(limited to 'OpenSim/Data')
diff --git a/OpenSim/Data/PGSQL/Resources/Presence.migrations b/OpenSim/Data/PGSQL/Resources/Presence.migrations
index 482beef..5489f88 100755
--- a/OpenSim/Data/PGSQL/Resources/Presence.migrations
+++ b/OpenSim/Data/PGSQL/Resources/Presence.migrations
@@ -36,3 +36,13 @@ BEGIN;
CREATE INDEX RegionID ON Presence("RegionID");
COMMIT;
+
+:VERSION 4 # Making sure LastSeen is actually defined in the table as it most likely erred in the double version 2 migration above
+
+BEGIN;
+
+ALTER TABLE Presence
+DROP COLUMN IF EXISTS "LastSeen",
+ADD COLUMN "LastSeen" Timestamp;
+
+COMMIT;
\ No newline at end of file
--
cgit v1.1