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 --- OpenSim/Data/PGSQL/Resources/Presence.migrations | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'OpenSim/Data/PGSQL') 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