1 files changed, 0 insertions, 79 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql b/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql
deleted file mode 100644
index 6a390c2..0000000
--- a/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql
+++ /dev/null
@@ -1,79 +0,0 @@
-BEGIN;
-update terrain 
-  set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
-  where RegionUUID not like '%-%';
-  
-update landaccesslist
-  set LandUUID = substr(LandUUID, 1, 8) || "-" || substr(LandUUID, 9, 4) || "-" || substr(LandUUID, 13, 4) || "-" || substr(LandUUID, 17, 4) || "-" || substr(LandUUID, 21, 12) 
-  where LandUUID not like '%-%';
-update landaccesslist
-  set AccessUUID = substr(AccessUUID, 1, 8) || "-" || substr(AccessUUID, 9, 4) || "-" || substr(AccessUUID, 13, 4) || "-" || substr(AccessUUID, 17, 4) || "-" || substr(AccessUUID, 21, 12) 
-  where AccessUUID not like '%-%';
-  
-update prims
-  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 '%-%';
-update prims
-  set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) 
-  where RegionUUID not like '%-%';
-update prims
-  set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12) 
-  where SceneGroupID not like '%-%';
-update prims
-  set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12) 
-  where CreatorID not like '%-%';
-update prims
-  set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12) 
-  where OwnerID not like '%-%';
-update prims
-  set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12) 
-  where GroupID not like '%-%';
-update prims
-  set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12) 
-  where LastOwnerID not like '%-%';
-update primshapes
-  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 '%-%';
-update land
-  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 '%-%';
-  
-update land
-  set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
-  where RegionUUID not like '%-%';
-update land
-  set OwnerUUID = substr(OwnerUUID, 1, 8) || "-" || substr(OwnerUUID, 9, 4) || "-" || substr(OwnerUUID, 13, 4) || "-" || substr(OwnerUUID, 17, 4) || "-" || substr(OwnerUUID, 21, 12)
-  where OwnerUUID not like '%-%';
-update land
-  set GroupUUID = substr(GroupUUID, 1, 8) || "-" || substr(GroupUUID, 9, 4) || "-" || substr(GroupUUID, 13, 4) || "-" || substr(GroupUUID, 17, 4) || "-" || substr(GroupUUID, 21, 12)
-  where GroupUUID not like '%-%';
-update land
-  set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) || "-" || substr(MediaTextureUUID, 9, 4) || "-" || substr(MediaTextureUUID, 13, 4) || "-" || substr(MediaTextureUUID, 17, 4) || "-" || substr(MediaTextureUUID, 21, 12)
-  where MediaTextureUUID not like '%-%';
-update land
-  set SnapshotUUID = substr(SnapshotUUID, 1, 8) || "-" || substr(SnapshotUUID, 9, 4) || "-" || substr(SnapshotUUID, 13, 4) || "-" || substr(SnapshotUUID, 17, 4) || "-" || substr(SnapshotUUID, 21, 12)
-  where SnapshotUUID not like '%-%';
-update land
-  set AuthbuyerID = substr(AuthbuyerID, 1, 8) || "-" || substr(AuthbuyerID, 9, 4) || "-" || substr(AuthbuyerID, 13, 4) || "-" || substr(AuthbuyerID, 17, 4) || "-" || substr(AuthbuyerID, 21, 12)
-  where AuthbuyerID not like '%-%';
-  
-COMMIT;
-\ No newline at end of file

diff --git a/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql b/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql deleted file mode 100644 index 6a390c2..0000000 --- a/OpenSim/Data/SQLiteLegacy/Resources/018_RegionStore.sql +++ /dev/null
@@ -1,79 +0,0 @@
1	BEGIN;
2
3	update terrain
4	set RegionUUID = substr(RegionUUID, 1, 8) \|\| "-" \|\| substr(RegionUUID, 9, 4) \|\| "-" \|\| substr(RegionUUID, 13, 4) \|\| "-" \|\| substr(RegionUUID, 17, 4) \|\| "-" \|\| substr(RegionUUID, 21, 12)
5	where RegionUUID not like '%-%';
6
7
8	update landaccesslist
9	set LandUUID = substr(LandUUID, 1, 8) \|\| "-" \|\| substr(LandUUID, 9, 4) \|\| "-" \|\| substr(LandUUID, 13, 4) \|\| "-" \|\| substr(LandUUID, 17, 4) \|\| "-" \|\| substr(LandUUID, 21, 12)
10	where LandUUID not like '%-%';
11
12	update landaccesslist
13	set AccessUUID = substr(AccessUUID, 1, 8) \|\| "-" \|\| substr(AccessUUID, 9, 4) \|\| "-" \|\| substr(AccessUUID, 13, 4) \|\| "-" \|\| substr(AccessUUID, 17, 4) \|\| "-" \|\| substr(AccessUUID, 21, 12)
14	where AccessUUID not like '%-%';
15
16
17	update prims
18	set UUID = substr(UUID, 1, 8) \|\| "-" \|\| substr(UUID, 9, 4) \|\| "-" \|\| substr(UUID, 13, 4) \|\| "-" \|\| substr(UUID, 17, 4) \|\| "-" \|\| substr(UUID, 21, 12)
19	where UUID not like '%-%';
20
21	update prims
22	set RegionUUID = substr(RegionUUID, 1, 8) \|\| "-" \|\| substr(RegionUUID, 9, 4) \|\| "-" \|\| substr(RegionUUID, 13, 4) \|\| "-" \|\| substr(RegionUUID, 17, 4) \|\| "-" \|\| substr(RegionUUID, 21, 12)
23	where RegionUUID not like '%-%';
24
25	update prims
26	set SceneGroupID = substr(SceneGroupID, 1, 8) \|\| "-" \|\| substr(SceneGroupID, 9, 4) \|\| "-" \|\| substr(SceneGroupID, 13, 4) \|\| "-" \|\| substr(SceneGroupID, 17, 4) \|\| "-" \|\| substr(SceneGroupID, 21, 12)
27	where SceneGroupID not like '%-%';
28
29	update prims
30	set CreatorID = substr(CreatorID, 1, 8) \|\| "-" \|\| substr(CreatorID, 9, 4) \|\| "-" \|\| substr(CreatorID, 13, 4) \|\| "-" \|\| substr(CreatorID, 17, 4) \|\| "-" \|\| substr(CreatorID, 21, 12)
31	where CreatorID not like '%-%';
32
33	update prims
34	set OwnerID = substr(OwnerID, 1, 8) \|\| "-" \|\| substr(OwnerID, 9, 4) \|\| "-" \|\| substr(OwnerID, 13, 4) \|\| "-" \|\| substr(OwnerID, 17, 4) \|\| "-" \|\| substr(OwnerID, 21, 12)
35	where OwnerID not like '%-%';
36
37	update prims
38	set GroupID = substr(GroupID, 1, 8) \|\| "-" \|\| substr(GroupID, 9, 4) \|\| "-" \|\| substr(GroupID, 13, 4) \|\| "-" \|\| substr(GroupID, 17, 4) \|\| "-" \|\| substr(GroupID, 21, 12)
39	where GroupID not like '%-%';
40
41	update prims
42	set LastOwnerID = substr(LastOwnerID, 1, 8) \|\| "-" \|\| substr(LastOwnerID, 9, 4) \|\| "-" \|\| substr(LastOwnerID, 13, 4) \|\| "-" \|\| substr(LastOwnerID, 17, 4) \|\| "-" \|\| substr(LastOwnerID, 21, 12)
43	where LastOwnerID not like '%-%';
44
45
46	update primshapes
47	set UUID = substr(UUID, 1, 8) \|\| "-" \|\| substr(UUID, 9, 4) \|\| "-" \|\| substr(UUID, 13, 4) \|\| "-" \|\| substr(UUID, 17, 4) \|\| "-" \|\| substr(UUID, 21, 12)
48	where UUID not like '%-%';
49
50
51	update land
52	set UUID = substr(UUID, 1, 8) \|\| "-" \|\| substr(UUID, 9, 4) \|\| "-" \|\| substr(UUID, 13, 4) \|\| "-" \|\| substr(UUID, 17, 4) \|\| "-" \|\| substr(UUID, 21, 12)
53	where UUID not like '%-%';
54
55	update land
56	set RegionUUID = substr(RegionUUID, 1, 8) \|\| "-" \|\| substr(RegionUUID, 9, 4) \|\| "-" \|\| substr(RegionUUID, 13, 4) \|\| "-" \|\| substr(RegionUUID, 17, 4) \|\| "-" \|\| substr(RegionUUID, 21, 12)
57	where RegionUUID not like '%-%';
58
59	update land
60	set OwnerUUID = substr(OwnerUUID, 1, 8) \|\| "-" \|\| substr(OwnerUUID, 9, 4) \|\| "-" \|\| substr(OwnerUUID, 13, 4) \|\| "-" \|\| substr(OwnerUUID, 17, 4) \|\| "-" \|\| substr(OwnerUUID, 21, 12)
61	where OwnerUUID not like '%-%';
62
63	update land
64	set GroupUUID = substr(GroupUUID, 1, 8) \|\| "-" \|\| substr(GroupUUID, 9, 4) \|\| "-" \|\| substr(GroupUUID, 13, 4) \|\| "-" \|\| substr(GroupUUID, 17, 4) \|\| "-" \|\| substr(GroupUUID, 21, 12)
65	where GroupUUID not like '%-%';
66
67	update land
68	set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) \|\| "-" \|\| substr(MediaTextureUUID, 9, 4) \|\| "-" \|\| substr(MediaTextureUUID, 13, 4) \|\| "-" \|\| substr(MediaTextureUUID, 17, 4) \|\| "-" \|\| substr(MediaTextureUUID, 21, 12)
69	where MediaTextureUUID not like '%-%';
70
71	update land
72	set SnapshotUUID = substr(SnapshotUUID, 1, 8) \|\| "-" \|\| substr(SnapshotUUID, 9, 4) \|\| "-" \|\| substr(SnapshotUUID, 13, 4) \|\| "-" \|\| substr(SnapshotUUID, 17, 4) \|\| "-" \|\| substr(SnapshotUUID, 21, 12)
73	where SnapshotUUID not like '%-%';
74
75	update land
76	set AuthbuyerID = substr(AuthbuyerID, 1, 8) \|\| "-" \|\| substr(AuthbuyerID, 9, 4) \|\| "-" \|\| substr(AuthbuyerID, 13, 4) \|\| "-" \|\| substr(AuthbuyerID, 17, 4) \|\| "-" \|\| substr(AuthbuyerID, 21, 12)
77	where AuthbuyerID not like '%-%';
78
79	COMMIT; \ No newline at end of file