diff options
author | Geir Nøklebye | 2016-03-16 15:17:38 +0100 |
---|---|---|
committer | Kevin Cozens | 2016-04-25 12:17:17 -0400 |
commit | 7aa3d4256e80c55b0e39f0c37ef679ef426be48d (patch) | |
tree | 64f0caa81d0a2f7d17b82d6640903bff727fb46a /OpenSim/Data | |
parent | Updated the code to handle Agent Preferences. Thanks to TomDataworks for prov... (diff) | |
download | opensim-SC_OLD-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.zip opensim-SC_OLD-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.tar.gz opensim-SC_OLD-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.tar.bz2 opensim-SC_OLD-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.tar.xz |
POSTGRES: Update database migrations to be in accordance with MySQL table definitions. Prerequisite for fixing PGSQLSimulationdata
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846)
Diffstat (limited to 'OpenSim/Data')
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/AuthStore.migrations | 8 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/RegionStore.migrations | 24 | ||||
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | 8 |
3 files changed, 39 insertions, 1 deletions
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; | |||
30 | 30 | ||
31 | COMMIT; | 31 | COMMIT; |
32 | 32 | ||
33 | :VERSION 3 | ||
34 | |||
35 | BEGIN TRANSACTION; | ||
36 | |||
37 | CREATE UNIQUE INDEX auth_pkey ON auth USING btree (uuid); | ||
38 | ALTER TABLE tokens ADD CONSTRAINT "uuid_token" UNIQUE ("uuid","token") NOT DEFERRABLE INITIALLY IMMEDIATE; | ||
39 | |||
40 | 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; | |||
1153 | 1153 | ||
1154 | COMMIT; | 1154 | COMMIT; |
1155 | 1155 | ||
1156 | VERSION 41 #-- Change Landlags to bigint | 1156 | :VERSION 41 #-- Change Landlags to bigint |
1157 | 1157 | ||
1158 | BEGIN TRANSACTION; | 1158 | BEGIN TRANSACTION; |
1159 | 1159 | ||
1160 | ALTER TABLE land ALTER "LandFlags" TYPE bigint; | 1160 | ALTER TABLE land ALTER "LandFlags" TYPE bigint; |
1161 | 1161 | ||
1162 | COMMIT; | 1162 | COMMIT; |
1163 | |||
1164 | :VERSION 42 #-- avination fields | ||
1165 | |||
1166 | BEGIN TRANSACTION; | ||
1167 | |||
1168 | ALTER TABLE prims ADD "PassCollisions" smallint NOT NULL DEFAULT (0); | ||
1169 | ALTER TABLE prims ADD "Vehicle" text COLLATE "default"; | ||
1170 | ALTER TABLE regionsettings ADD "block_search" smallint NOT NULL DEFAULT (0); | ||
1171 | ALTER TABLE regionsettings ADD "casino" smallint NOT NULL DEFAULT (0); | ||
1172 | ALTER TABLE land ADD "SeeAVs" smallint NOT NULL DEFAULT (1); | ||
1173 | ALTER TABLE land ADD "AnyAVSounds" smallint NOT NULL DEFAULT (1); | ||
1174 | ALTER TABLE land ADD "GroupAVSounds" smallint NOT NULL DEFAULT (1); | ||
1175 | |||
1176 | COMMIT; | ||
1177 | |||
1178 | :VERSION 43 #---- STATUS ROTATION axis locks | ||
1179 | |||
1180 | BEGIN TRANSACTION; | ||
1181 | |||
1182 | ALTER TABLE prims ADD "RotationAxisLocks" smallint NOT NULL DEFAULT (0); | ||
1183 | |||
1184 | 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; | |||
153 | ALTER TABLE usersettings ALTER COLUMN imviaemail SET DATA TYPE boolean USING CASE WHEN false THEN false ELSE true END; | 153 | ALTER TABLE usersettings ALTER COLUMN imviaemail SET DATA TYPE boolean USING CASE WHEN false THEN false ELSE true END; |
154 | 154 | ||
155 | COMMIT; | 155 | COMMIT; |
156 | |||
157 | :VERSION 6 # ------------------------------- | ||
158 | |||
159 | BEGIN TRANSACTION; | ||
160 | |||
161 | ALTER TABLE userpicks ADD "gatekeeper" varchar(255) COLLATE "default"; | ||
162 | |||
163 | COMMIT; | ||