cleaning a bit, including moving out some old docs, and renaming

[feisty_meow.git] / infobase / patterns / mysql / opensim / db_queries_for_opensim.txt

diff --git a/infobase/patterns/mysql/opensim/db_queries_for_opensim.txt b/infobase/patterns/mysql/opensim/db_queries_for_opensim.txt
new file mode 100644 (file)
index 0000000..cc43c7a
--- /dev/null
+++ b/infobase/patterns/mysql/opensim/db_queries_for_opensim.txt
@@ -0,0 +1,43 @@
+
+
+==============
+
+find all the tables that have a CreatorID column:
+
+  SELECT DISTINCT TABLE_NAME 
+    FROM INFORMATION_SCHEMA.COLUMNS
+    WHERE COLUMN_NAME IN ('CreatorId')
+        AND TABLE_SCHEMA='opensim';
+
+=> yields assets inventoryitems prims primitems
+as tables matching the column.
+
+==============
+
+replace all the creator ids with fred's id on ducky:
+
+  update inventoryitems set creatorid = 'NEWGUID'
+
+=> do for each of the tables.
+
+==============
+
+checking to make sure the changes to creatorid took effect:
+
+  select * from assets where creatorid != 'YOURGUID'
+
+=> there should be no matches after running a setting operation.
+
+==============
+
+if you have a more selective update to do, try replacing using a pattern:
+
+  update assets set creatorid = replace(creatorid, 'OLDGUID', 'NEWGUID')
+
+==============
+
+note: replacing all creator ids like above still does not secure total
+ownership for everything in inventory or even in the sim; nested objects in
+inventory do not seem to be affected, and the contents of objects nested in
+live objects also are not affected.
+