From 7f8552fe63df19913364d04b133adf5856eed11a Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 9 Apr 2009 19:23:19 +0000
Subject: * Change SQLite asset UUID to dashed format to be consistent *
 Remaining inconsistent uuids (non dashed) are in region store for sqlite and
 mysql * Migration of these will happen at a later date, unless someone else
 wants to do it

---
 OpenSim/Data/SQLite/Resources/004_AssetStore.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/004_AssetStore.sql

(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
new file mode 100644
index 0000000..721f2b5
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/004_AssetStore.sql
@@ -0,0 +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)
+  where UUID not like '%-%';
+
+COMMIT;
-- 
cgit v1.1

