diff options
| author | onefang | 2019-05-19 21:24:15 +1000 |
|---|---|---|
| committer | onefang | 2019-05-19 21:24:15 +1000 |
| commit | 5e4d6cab00cb29cd088ab7b62ab13aff103b64cb (patch) | |
| tree | a9fbc62df9eb2d1d9ba2698d8552eae71eca20d8 /OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | |
| parent | Add a build script. (diff) | |
| download | opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.zip opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.gz opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.bz2 opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.xz | |
Dump OpenSim 0.9.0.1 into it's own branch.
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/UserProfiles.migrations')
| -rw-r--r-- | OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations index a6bd8ca..26104c0 100644 --- a/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/PGSQL/Resources/UserProfiles.migrations | |||
| @@ -152,4 +152,12 @@ BEGIN; | |||
| 152 | 152 | ||
| 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; \ No newline at end of file | 155 | COMMIT; |
| 156 | |||
| 157 | :VERSION 6 # ------------------------------- | ||
| 158 | |||
| 159 | BEGIN TRANSACTION; | ||
| 160 | |||
| 161 | ALTER TABLE userpicks ADD "gatekeeper" varchar(255) COLLATE "default"; | ||
| 162 | |||
| 163 | COMMIT; | ||