5 find all the tables that have a CreatorID column:
7 SELECT DISTINCT TABLE_NAME
8 FROM INFORMATION_SCHEMA.COLUMNS
9 WHERE COLUMN_NAME IN ('CreatorId')
10 AND TABLE_SCHEMA='opensim';
12 => yields assets inventoryitems prims primitems
13 as tables matching the column.
17 replace all the creator ids with fred's id on ducky:
19 update inventoryitems set creatorid = 'NEWGUID'
21 => do for each of the tables.
25 checking to make sure the changes to creatorid took effect:
27 select * from assets where creatorid != 'YOURGUID'
29 => there should be no matches after running a setting operation.
33 if you have a more selective update to do, try replacing using a pattern:
35 update assets set creatorid = replace(creatorid, 'OLDGUID', 'NEWGUID')
39 note: replacing all creator ids like above still does not secure total
40 ownership for everything in inventory or even in the sim; nested objects in
41 inventory do not seem to be affected, and the contents of objects nested in
42 live objects also are not affected.