diff options
author | Justin Clarke Casey | 2009-04-09 16:56:01 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-04-09 16:56:01 +0000 |
commit | b5ba5634fbb025c426b22f0a63542fbbe1c49a2e (patch) | |
tree | d714f1f415bf115ba3015cb1bb1a7860e6ad65d2 /OpenSim/Data/SQLite/Resources | |
parent | * Added some more experimental code; nothing wired in so far. (diff) | |
download | opensim-SC_OLD-b5ba5634fbb025c426b22f0a63542fbbe1c49a2e.zip opensim-SC_OLD-b5ba5634fbb025c426b22f0a63542fbbe1c49a2e.tar.gz opensim-SC_OLD-b5ba5634fbb025c426b22f0a63542fbbe1c49a2e.tar.bz2 opensim-SC_OLD-b5ba5634fbb025c426b22f0a63542fbbe1c49a2e.tar.xz |
* Migrate UUID representations in SQLite inventory store to dashed format
* This makes the representation consistent with that most commonly used in the other supported database layers
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/004_InventoryStore.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/004_InventoryStore.sql b/OpenSim/Data/SQLite/Resources/004_InventoryStore.sql new file mode 100644 index 0000000..5985d80 --- /dev/null +++ b/OpenSim/Data/SQLite/Resources/004_InventoryStore.sql | |||
@@ -0,0 +1,15 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | update inventoryitems | ||
4 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21), | ||
5 | assetID = substr(assetID, 1, 8) || "-" || substr(assetID, 9, 4) || "-" || substr(assetID, 13, 4) || "-" || substr(assetID, 17, 4) || "-" || substr(assetID, 21), | ||
6 | parentFolderID = substr(parentFolderID, 1, 8) || "-" || substr(parentFolderID, 9, 4) || "-" || substr(parentFolderID, 13, 4) || "-" || substr(parentFolderID, 17, 4) || "-" || substr(parentFolderID, 21), | ||
7 | avatarID = substr(avatarID, 1, 8) || "-" || substr(avatarID, 9, 4) || "-" || substr(avatarID, 13, 4) || "-" || substr(avatarID, 17, 4) || "-" || substr(avatarID, 21), | ||
8 | creatorsID = substr(creatorsID, 1, 8) || "-" || substr(creatorsID, 9, 4) || "-" || substr(creatorsID, 13, 4) || "-" || substr(creatorsID, 17, 4) || "-" || substr(creatorsID, 21); | ||
9 | |||
10 | update inventoryfolders | ||
11 | set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21), | ||
12 | agentID = substr(agentID, 1, 8) || "-" || substr(agentID, 9, 4) || "-" || substr(agentID, 13, 4) || "-" || substr(agentID, 17, 4) || "-" || substr(agentID, 21), | ||
13 | parentID = substr(parentID, 1, 8) || "-" || substr(parentID, 9, 4) || "-" || substr(parentID, 13, 4) || "-" || substr(parentID, 17, 4) || "-" || substr(parentID, 21); | ||
14 | |||
15 | COMMIT; | ||