diff options
author | Geir Nøklebye | 2017-05-13 17:43:59 +0100 |
---|---|---|
committer | UbitUmarov | 2017-05-13 17:15:47 +0100 |
commit | 7cf82a71d6db53fd3705ae65b4bc45d8f8488ada (patch) | |
tree | f3a7ab03d9b13ca0ff0921502f9475540a9171c3 /OpenSim/Data/PGSQL/Resources/RegionStore.migrations | |
parent | we can't allow abort to change only one dic (diff) | |
download | opensim-SC_OLD-7cf82a71d6db53fd3705ae65b4bc45d8f8488ada.zip opensim-SC_OLD-7cf82a71d6db53fd3705ae65b4bc45d8f8488ada.tar.gz opensim-SC_OLD-7cf82a71d6db53fd3705ae65b4bc45d8f8488ada.tar.bz2 opensim-SC_OLD-7cf82a71d6db53fd3705ae65b4bc45d8f8488ada.tar.xz |
PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast that fails with newer versions of NPGSQL.
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/RegionStore.migrations | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations index 948d177..fcefb6b 100644 --- a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations | |||
@@ -1211,3 +1211,17 @@ BEGIN TRANSACTION; | |||
1211 | ALTER TABLE prims ADD "PhysInertia" TEXT; | 1211 | ALTER TABLE prims ADD "PhysInertia" TEXT; |
1212 | 1212 | ||
1213 | COMMIT; | 1213 | COMMIT; |
1214 | |||
1215 | |||
1216 | :VERSION 47 #---- Convert field PassCollisions in table prims to BOOLEAN | ||
1217 | |||
1218 | BEGIN TRANSACTION; | ||
1219 | |||
1220 | ALTER TABLE "public"."prims" ALTER COLUMN "PassCollisions" DROP DEFAULT; | ||
1221 | ALTER TABLE "public"."prims" | ||
1222 | ALTER COLUMN "PassCollisions" TYPE BOOLEAN | ||
1223 | USING CASE WHEN "PassCollisions" = 0 THEN FALSE | ||
1224 | WHEN "PassCollisions" = 1 THEN TRUE | ||
1225 | ELSE NULL | ||
1226 | END; | ||
1227 | COMMIT; | ||