aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
authorJustin Clarke Casey2009-04-09 19:01:52 +0000
committerJustin Clarke Casey2009-04-09 19:01:52 +0000
commit67333d48fc0b9e70804b7ceef80494484b2a247c (patch)
treed9d191522f0ba65a02d6bf4480cbe606b6e37f02 /OpenSim/Data/SQLite/Resources
parent* Improve inventory uuid conversions to make sure that we aren't converting a... (diff)
downloadopensim-SC_OLD-67333d48fc0b9e70804b7ceef80494484b2a247c.zip
opensim-SC_OLD-67333d48fc0b9e70804b7ceef80494484b2a247c.tar.gz
opensim-SC_OLD-67333d48fc0b9e70804b7ceef80494484b2a247c.tar.bz2
opensim-SC_OLD-67333d48fc0b9e70804b7ceef80494484b2a247c.tar.xz
* Change UUIDs in SQLite user db to dashed format to match representations elsewhere
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/009_UserStore.sql11
1 files changed, 11 insertions, 0 deletions
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 @@
1BEGIN;
2
3update users
4 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21)
5 where UUID not like '%-%';
6
7update useragents
8 set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21)
9 where UUID not like '%-%';
10
11COMMIT;