diff options
| author | Justin Clarke Casey | 2009-04-10 11:34:37 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2009-04-10 11:34:37 +0000 |
| commit | bc515c324140ee9770ec5c6e2b960014b1e66be0 (patch) | |
| tree | e0ba10f0553b39839e7a09adbc78edbe90d32b29 /OpenSim/Data/SQLite/Resources/009_UserStore.sql | |
| parent | * Patch from RemedyTomm Mantis 3440 (diff) | |
| download | opensim-SC-bc515c324140ee9770ec5c6e2b960014b1e66be0.zip opensim-SC-bc515c324140ee9770ec5c6e2b960014b1e66be0.tar.gz opensim-SC-bc515c324140ee9770ec5c6e2b960014b1e66be0.tar.bz2 opensim-SC-bc515c324140ee9770ec5c6e2b960014b1e66be0.tar.xz | |
* Apply http://opensimulator.org/mantis/view.php?id=3439
* This corrects problems seen on some SQLite systems where the migration fails because the two argument substr() isn't implemented
* Thanks RemedyTomm!
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/009_UserStore.sql')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/009_UserStore.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/SQLite/Resources/009_UserStore.sql b/OpenSim/Data/SQLite/Resources/009_UserStore.sql index b4cc00c..8ab03ef 100644 --- a/OpenSim/Data/SQLite/Resources/009_UserStore.sql +++ b/OpenSim/Data/SQLite/Resources/009_UserStore.sql | |||
| @@ -1,11 +1,11 @@ | |||
| 1 | BEGIN; | 1 | BEGIN; |
| 2 | 2 | ||
| 3 | update users | 3 | update users |
| 4 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21) | 4 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
| 5 | where UUID not like '%-%'; | 5 | where UUID not like '%-%'; |
| 6 | 6 | ||
| 7 | update useragents | 7 | update useragents |
| 8 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21) | 8 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) |
| 9 | where UUID not like '%-%'; | 9 | where UUID not like '%-%'; |
| 10 | 10 | ||
| 11 | COMMIT; | 11 | COMMIT; |