diff options
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; |