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/004_AssetStore.sql | |
| parent | * Patch from RemedyTomm Mantis 3440 (diff) | |
| download | opensim-SC_OLD-bc515c324140ee9770ec5c6e2b960014b1e66be0.zip opensim-SC_OLD-bc515c324140ee9770ec5c6e2b960014b1e66be0.tar.gz opensim-SC_OLD-bc515c324140ee9770ec5c6e2b960014b1e66be0.tar.bz2 opensim-SC_OLD-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/004_AssetStore.sql')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/004_AssetStore.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/SQLite/Resources/004_AssetStore.sql b/OpenSim/Data/SQLite/Resources/004_AssetStore.sql index 721f2b5..39421c4 100644 --- a/OpenSim/Data/SQLite/Resources/004_AssetStore.sql +++ b/OpenSim/Data/SQLite/Resources/004_AssetStore.sql | |||
| @@ -1,7 +1,7 @@ | |||
| 1 | BEGIN; | 1 | BEGIN; |
| 2 | 2 | ||
| 3 | update assets | 3 | update assets |
| 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 | COMMIT; | 7 | COMMIT; |