From 7aa3d4256e80c55b0e39f0c37ef679ef426be48d Mon Sep 17 00:00:00 2001 From: Geir Nøklebye Date: Wed, 16 Mar 2016 15:17:38 +0100 Subject: POSTGRES: Update database migrations to be in accordance with MySQL table definitions. Prerequisite for fixing PGSQLSimulationdata Signed-off-by: Kevin Cozens (mantis #7846) --- OpenSim/Data/PGSQL/Resources/AuthStore.migrations | 8 ++++++++ .../Data/PGSQL/Resources/RegionStore.migrations | 24 +++++++++++++++++++++- .../Data/PGSQL/Resources/UserProfiles.migrations | 8 ++++++++ 3 files changed, 39 insertions(+), 1 deletion(-) diff --git a/OpenSim/Data/PGSQL/Resources/AuthStore.migrations b/OpenSim/Data/PGSQL/Resources/AuthStore.migrations index a1f5b61..043a8f7 100644 --- a/OpenSim/Data/PGSQL/Resources/AuthStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/AuthStore.migrations @@ -30,3 +30,11 @@ BEGIN TRANSACTION; COMMIT; +:VERSION 3 + +BEGIN TRANSACTION; + +CREATE UNIQUE INDEX auth_pkey ON auth USING btree (uuid); +ALTER TABLE tokens ADD CONSTRAINT "uuid_token" UNIQUE ("uuid","token") NOT DEFERRABLE INITIALLY IMMEDIATE; + +COMMIT; \ No newline at end of file diff --git a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations index 1284ce0..9a2c19b 100644 --- a/OpenSim/Data/PGSQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/RegionStore.migrations @@ -1153,10 +1153,32 @@ 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; diff --git a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations index c1580b2..26104c0 100644 --- a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations @@ -153,3 +153,11 @@ BEGIN; ALTER TABLE usersettings ALTER COLUMN imviaemail SET DATA TYPE boolean USING CASE WHEN false THEN false ELSE true END; COMMIT; + +:VERSION 6 # ------------------------------- + +BEGIN TRANSACTION; + +ALTER TABLE userpicks ADD "gatekeeper" varchar(255) COLLATE "default"; + +COMMIT; -- cgit v1.1