Dump OpenSim 0.9.0.1 into it's own branch.

1 files changed, 66 insertions, 1 deletions

diff --git a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations
index 1284ce0..fcefb6b 100644
--- a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations
@@ -1153,10 +1153,75 @@ ALTER TABLE regionwindlight ALTER COLUMN draw_classic_clouds SET DEFAULT FALSE;
 
 COMMIT;
 
-VERSION 41       #-- Change Landlags to bigint
+:VERSION 41       #-- Change Landlags to bigint
 
 BEGIN TRANSACTION;
 
 ALTER TABLE land ALTER "LandFlags" TYPE bigint;
 
 COMMIT;
+
+:VERSION 42      #-- avination fields
+
+BEGIN TRANSACTION;
+
+ALTER TABLE prims ADD "PassCollisions" smallint NOT NULL DEFAULT (0);
+ALTER TABLE prims ADD "Vehicle" text COLLATE "default";
+ALTER TABLE regionsettings ADD "block_search" smallint NOT NULL DEFAULT (0);
+ALTER TABLE regionsettings ADD  "casino" smallint NOT NULL DEFAULT (0);
+ALTER TABLE land ADD "SeeAVs" smallint NOT NULL DEFAULT (1);
+ALTER TABLE land ADD "AnyAVSounds" smallint NOT NULL DEFAULT (1);
+ALTER TABLE land ADD "GroupAVSounds" smallint NOT NULL DEFAULT (1);
+
+COMMIT;
+
+:VERSION 43     #---- STATUS ROTATION axis locks
+
+BEGIN TRANSACTION;
+
+ALTER TABLE prims ADD "RotationAxisLocks" smallint NOT NULL DEFAULT (0);
+
+COMMIT;
+
+:VERSION 44     #---- add baked terrain store
+
+BEGIN TRANSACTION;
+
+CREATE TABLE bakedterrain
+        (
+        "RegionUUID" uuid NULL,
+        "Revision" int NULL,
+        "Heightfield" bytea NULL
+        );
+
+COMMIT;
+
+:VERSION 45 #---- Add RezzerID filed in table prims
+
+BEGIN TRANSACTION;
+
+ALTER TABLE prims ADD "RezzerID" uuid NULL;
+
+COMMIT;
+
+:VERSION 46 #---- Add physics inertia data to table prims
+
+BEGIN TRANSACTION;
+
+ALTER TABLE prims ADD "PhysInertia" TEXT;
+
+COMMIT;
+
+
+:VERSION 47 #---- Convert field PassCollisions in table prims to BOOLEAN
+
+BEGIN TRANSACTION;
+
+ALTER TABLE "public"."prims" ALTER COLUMN "PassCollisions" DROP DEFAULT;
+ALTER TABLE "public"."prims"
+    ALTER COLUMN "PassCollisions" TYPE BOOLEAN
+        USING CASE WHEN "PassCollisions" = 0 THEN FALSE
+            WHEN "PassCollisions" = 1 THEN TRUE
+            ELSE NULL
+            END;
+COMMIT;