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.
15 (note: replacing all creator ids like below still did not secure total ownership
16 to fred; some things retained their original creator. how!?)
20 replace all the creator ids with fred's id on ducky:
22 update inventoryitems set creatorid = 'NEWGUID'
24 => do for each of the tables.
28 checking to make sure the changes to creatorid took effect:
30 select * from assets where creatorid != 'YOURGUID'
32 => there should be no matches after running a setting operation.
36 if you have a more selective update to do, try replacing using a pattern:
38 update assets set creatorid = replace(creatorid, 'OLDGUID', 'NEWGUID')