diff options
| author | Geir Nøklebye | 2015-07-27 14:25:28 +0200 |
|---|---|---|
| committer | Oren Hurvitz | 2015-07-31 15:57:22 +0100 |
| commit | 1de8c3570d0c8d18c181286334de81bf436dfbb4 (patch) | |
| tree | f1223afc3ac3997039d5c3e8aa7e77648d92b5b8 /OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | |
| parent | Fixed bad log message (diff) | |
| download | opensim-SC_OLD-1de8c3570d0c8d18c181286334de81bf436dfbb4.zip opensim-SC_OLD-1de8c3570d0c8d18c181286334de81bf436dfbb4.tar.gz opensim-SC_OLD-1de8c3570d0c8d18c181286334de81bf436dfbb4.tar.bz2 opensim-SC_OLD-1de8c3570d0c8d18c181286334de81bf436dfbb4.tar.xz | |
PGSQL migrations for IM_Store, UserProfiles, removal of casting exception for UserProfiles and adding double precision to PGSQL Manager
PGSQL migrations for IM_Store, UserProfiles, removal of casting
exception for UserProfiles and adding double precision to PGSQL Manager.
Fixes the Offline IM to Email toggle and prepares for fixing Offline
IM.
Signed-off-by: Oren Hurvitz <orenh@kitely.com>
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations index 1544b48..a6bd8ca 100644 --- a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | |||
| @@ -143,4 +143,13 @@ ALTER TABLE usersettings ALTER COLUMN visible SET DATA TYPE boolean USING CASE W | |||
| 143 | ALTER TABLE usersettings ADD COLUMN email varchar(254) NOT NULL; | 143 | ALTER TABLE usersettings ADD COLUMN email varchar(254) NOT NULL; |
| 144 | ALTER TABLE usersettings ADD PRIMARY KEY (useruuid); | 144 | ALTER TABLE usersettings ADD PRIMARY KEY (useruuid); |
| 145 | 145 | ||
| 146 | COMMIT; | ||
| 147 | |||
| 148 | |||
| 149 | :VERSION 5 # ------------------------------- | ||
| 150 | |||
| 151 | BEGIN; | ||
| 152 | |||
| 153 | ALTER TABLE usersettings ALTER COLUMN imviaemail SET DATA TYPE boolean USING CASE WHEN false THEN false ELSE true END; | ||
| 154 | |||
| 146 | COMMIT; \ No newline at end of file | 155 | COMMIT; \ No newline at end of file |