diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Migration/SqliteAssets.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Migration/SqliteAssets.sql | 5 |
1 files changed, 0 insertions, 5 deletions
diff --git a/OpenSim/Data/NHibernate/Migration/SqliteAssets.sql b/OpenSim/Data/NHibernate/Migration/SqliteAssets.sql deleted file mode 100644 index 4a7e0d1..0000000 --- a/OpenSim/Data/NHibernate/Migration/SqliteAssets.sql +++ /dev/null | |||
@@ -1,5 +0,0 @@ | |||
1 | -- The following converts the UUID from XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | ||
2 | -- to XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX. This puts it in Guid native format | ||
3 | -- for .NET, and the prefered format for LLUUID. | ||
4 | |||
5 | update assets 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 '%-%'; \ No newline at end of file | ||