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/PGSQL/Resources/UserProfiles.migrations | |
| parent | Updated the code to handle Agent Preferences. Thanks to TomDataworks for prov... (diff) | |
| download | opensim-SC-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.zip opensim-SC-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.tar.gz opensim-SC-7aa3d4256e80c55b0e39f0c37ef679ef426be48d.tar.bz2 opensim-SC-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/PGSQL/Resources/UserProfiles.migrations')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | 8 |
1 files changed, 8 insertions, 0 deletions
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; | ||