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 | |
| parent | Removed unused variable (diff) | |
| download | opensim-SC-818735ae2c52fc298ea7cc44951b9512ab330d35.zip opensim-SC-818735ae2c52fc298ea7cc44951b9512ab330d35.tar.gz opensim-SC-818735ae2c52fc298ea7cc44951b9512ab330d35.tar.bz2 opensim-SC-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')
| -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 | ||