diff options
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources')
-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 | ||