From bc515c324140ee9770ec5c6e2b960014b1e66be0 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Fri, 10 Apr 2009 11:34:37 +0000
Subject: * 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!

---
 OpenSim/Data/SQLite/Resources/004_AssetStore.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/SQLite/Resources/004_AssetStore.sql')

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 @@
 BEGIN;
 
 update assets
-  set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21)
+  set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
   where UUID not like '%-%';
 
 COMMIT;
-- 
cgit v1.1

