Home Explore Help
Sign In
GwynethLlewelyn
/
OpenSim-Test
1
0
Fork 0
Files Issues 0 Pull Requests 0
Tree: bf8e07606f
Branches Tags
OpenSim-Test
/
OpenSim
/
Data
/
SQLite
/
Resources
/
018_RegionStore.sql

018_RegionStore.sql 4.1 KB
History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879 
  1. BEGIN;
    2. 

  2. 

  3. update terrain 
    4. 

  4.   set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
    5. 

  5.   where RegionUUID not like '%-%';
    6. 

  6.   
    7. 

  7. 

  8. update landaccesslist
    9. 

  9.   set LandUUID = substr(LandUUID, 1, 8) || "-" || substr(LandUUID, 9, 4) || "-" || substr(LandUUID, 13, 4) || "-" || substr(LandUUID, 17, 4) || "-" || substr(LandUUID, 21, 12) 
    10. 

  10.   where LandUUID not like '%-%';
    11. 

  11. 

  12. update landaccesslist
    13. 

  13.   set AccessUUID = substr(AccessUUID, 1, 8) || "-" || substr(AccessUUID, 9, 4) || "-" || substr(AccessUUID, 13, 4) || "-" || substr(AccessUUID, 17, 4) || "-" || substr(AccessUUID, 21, 12) 
    14. 

  14.   where AccessUUID not like '%-%';
    15. 

  15.   
    16. 

  16. 

  17. update prims
    18. 

  18.   set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) 
    19. 

  19.   where UUID not like '%-%';
    20. 

  20. 

  21. update prims
    22. 

  22.   set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12) 
    23. 

  23.   where RegionUUID not like '%-%';
    24. 

  24. 

  25. update prims
    26. 

  26.   set SceneGroupID = substr(SceneGroupID, 1, 8) || "-" || substr(SceneGroupID, 9, 4) || "-" || substr(SceneGroupID, 13, 4) || "-" || substr(SceneGroupID, 17, 4) || "-" || substr(SceneGroupID, 21, 12) 
    27. 

  27.   where SceneGroupID not like '%-%';
    28. 

  28. 

  29. update prims
    30. 

  30.   set CreatorID = substr(CreatorID, 1, 8) || "-" || substr(CreatorID, 9, 4) || "-" || substr(CreatorID, 13, 4) || "-" || substr(CreatorID, 17, 4) || "-" || substr(CreatorID, 21, 12) 
    31. 

  31.   where CreatorID not like '%-%';
    32. 

  32. 

  33. update prims
    34. 

  34.   set OwnerID = substr(OwnerID, 1, 8) || "-" || substr(OwnerID, 9, 4) || "-" || substr(OwnerID, 13, 4) || "-" || substr(OwnerID, 17, 4) || "-" || substr(OwnerID, 21, 12) 
    35. 

  35.   where OwnerID not like '%-%';
    36. 

  36. 

  37. update prims
    38. 

  38.   set GroupID = substr(GroupID, 1, 8) || "-" || substr(GroupID, 9, 4) || "-" || substr(GroupID, 13, 4) || "-" || substr(GroupID, 17, 4) || "-" || substr(GroupID, 21, 12) 
    39. 

  39.   where GroupID not like '%-%';
    40. 

  40. 

  41. update prims
    42. 

  42.   set LastOwnerID = substr(LastOwnerID, 1, 8) || "-" || substr(LastOwnerID, 9, 4) || "-" || substr(LastOwnerID, 13, 4) || "-" || substr(LastOwnerID, 17, 4) || "-" || substr(LastOwnerID, 21, 12) 
    43. 

  43.   where LastOwnerID not like '%-%';
    44. 

  44. 

  45. 

  46. update primshapes
    47. 

  47.   set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) 
    48. 

  48.   where UUID not like '%-%';
    49. 

  49. 

  50. 

  51. update land
    52. 

  52.   set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12) 
    53. 

  53.   where UUID not like '%-%';
    54. 

  54.   
    55. 

  55. update land
    56. 

  56.   set RegionUUID = substr(RegionUUID, 1, 8) || "-" || substr(RegionUUID, 9, 4) || "-" || substr(RegionUUID, 13, 4) || "-" || substr(RegionUUID, 17, 4) || "-" || substr(RegionUUID, 21, 12)
    57. 

  57.   where RegionUUID not like '%-%';
    58. 

  58. 

  59. update land
    60. 

  60.   set OwnerUUID = substr(OwnerUUID, 1, 8) || "-" || substr(OwnerUUID, 9, 4) || "-" || substr(OwnerUUID, 13, 4) || "-" || substr(OwnerUUID, 17, 4) || "-" || substr(OwnerUUID, 21, 12)
    61. 

  61.   where OwnerUUID not like '%-%';
    62. 

  62. 

  63. update land
    64. 

  64.   set GroupUUID = substr(GroupUUID, 1, 8) || "-" || substr(GroupUUID, 9, 4) || "-" || substr(GroupUUID, 13, 4) || "-" || substr(GroupUUID, 17, 4) || "-" || substr(GroupUUID, 21, 12)
    65. 

  65.   where GroupUUID not like '%-%';
    66. 

  66. 

  67. update land
    68. 

  68.   set MediaTextureUUID = substr(MediaTextureUUID, 1, 8) || "-" || substr(MediaTextureUUID, 9, 4) || "-" || substr(MediaTextureUUID, 13, 4) || "-" || substr(MediaTextureUUID, 17, 4) || "-" || substr(MediaTextureUUID, 21, 12)
    69. 

  69.   where MediaTextureUUID not like '%-%';
    70. 

  70. 

  71. update land
    72. 

  72.   set SnapshotUUID = substr(SnapshotUUID, 1, 8) || "-" || substr(SnapshotUUID, 9, 4) || "-" || substr(SnapshotUUID, 13, 4) || "-" || substr(SnapshotUUID, 17, 4) || "-" || substr(SnapshotUUID, 21, 12)
    73. 

  73.   where SnapshotUUID not like '%-%';
    74. 

  74. 

  75. update land
    76. 

  76.   set AuthbuyerID = substr(AuthbuyerID, 1, 8) || "-" || substr(AuthbuyerID, 9, 4) || "-" || substr(AuthbuyerID, 13, 4) || "-" || substr(AuthbuyerID, 17, 4) || "-" || substr(AuthbuyerID, 21, 12)
    77. 

  77.   where AuthbuyerID not like '%-%';
    78. 

  78.   
    79. 

  79. COMMIT;
    80.