diff options
author | Geir Nøklebye | 2015-08-03 10:05:04 +0200 |
---|---|---|
committer | Oren Hurvitz | 2015-08-03 13:32:11 +0100 |
commit | 818735ae2c52fc298ea7cc44951b9512ab330d35 (patch) | |
tree | fb9c954f34cda484c5a94e60d58a3f69b6759cd9 /OpenSim/Data/PGSQL/Resources/Presence.migrations | |
parent | Removed unused variable (diff) | |
download | opensim-SC_OLD-818735ae2c52fc298ea7cc44951b9512ab330d35.zip opensim-SC_OLD-818735ae2c52fc298ea7cc44951b9512ab330d35.tar.gz opensim-SC_OLD-818735ae2c52fc298ea7cc44951b9512ab330d35.tar.bz2 opensim-SC_OLD-818735ae2c52fc298ea7cc44951b9512ab330d35.tar.xz |
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>
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/Presence.migrations')
-rwxr-xr-x | OpenSim/Data/PGSQL/Resources/Presence.migrations | 10 |
1 files changed, 10 insertions, 0 deletions
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; | |||
36 | CREATE INDEX RegionID ON Presence("RegionID"); | 36 | CREATE INDEX RegionID ON Presence("RegionID"); |
37 | 37 | ||
38 | COMMIT; | 38 | COMMIT; |
39 | |||
40 | :VERSION 4 # Making sure LastSeen is actually defined in the table as it most likely erred in the double version 2 migration above | ||
41 | |||
42 | BEGIN; | ||
43 | |||
44 | ALTER TABLE Presence | ||
45 | DROP COLUMN IF EXISTS "LastSeen", | ||
46 | ADD COLUMN "LastSeen" Timestamp; | ||
47 | |||
48 | COMMIT; \ No newline at end of file | ||