X-Git-Url: https://feistymeow.org/gitweb/?a=blobdiff_plain;f=database%2Fpatterns%2Fmysql%2Fopensim%2Fdb_queries_for_opensim.txt;fp=database%2Fpatterns%2Fmysql%2Fopensim%2Fdb_queries_for_opensim.txt;h=0000000000000000000000000000000000000000;hb=0f49452f40415efb2a62048397ed8514a1058bb7;hp=cc43c7a75736602ae738e3577b306b339e9cf25c;hpb=dfe6c3aedd3487a00acf94683163be7ed0baa6da;p=feisty_meow.git

diff --git a/database/patterns/mysql/opensim/db_queries_for_opensim.txt b/database/patterns/mysql/opensim/db_queries_for_opensim.txt
deleted file mode 100644
index cc43c7a7..00000000
--- a/database/patterns/mysql/opensim/db_queries_for_opensim.txt
+++ /dev/null
@@ -1,43 +0,0 @@
-
-
-==============
-
-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.
-