aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/004_AssetStore.sql
blob: 721f2b51e9ca76e46bc9f07e942b68505630df67 (plain)
1
2
3
4
5
6
7
BEGIN;

update assets
  set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21)
  where UUID not like '%-%';

COMMIT;