From 67333d48fc0b9e70804b7ceef80494484b2a247c Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 9 Apr 2009 19:01:52 +0000
Subject: * Change UUIDs in SQLite user db to dashed format to match
 representations elsewhere

---
 OpenSim/Data/SQLite/Resources/009_UserStore.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/009_UserStore.sql

(limited to 'OpenSim/Data/SQLite/Resources/009_UserStore.sql')

diff --git a/OpenSim/Data/SQLite/Resources/009_UserStore.sql b/OpenSim/Data/SQLite/Resources/009_UserStore.sql
new file mode 100644
index 0000000..b4cc00c
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/009_UserStore.sql
@@ -0,0 +1,11 @@
+BEGIN;
+
+update users
+  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 '%-%';
+
+update useragents
+  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

