X-Git-Url: https://feistymeow.org/gitweb/?a=blobdiff_plain;ds=inline;f=database%2Fconfiguration%2Fdatabase%2Fsql%2Freplace_creatorid_fields.sql;fp=database%2Fconfiguration%2Fdatabase%2Fsql%2Freplace_creatorid_fields.sql;h=0000000000000000000000000000000000000000;hb=0f49452f40415efb2a62048397ed8514a1058bb7;hp=6f3162c1190aa7ed1c08a5db134634a4c6d4c04e;hpb=dfe6c3aedd3487a00acf94683163be7ed0baa6da;p=feisty_meow.git

diff --git a/database/configuration/database/sql/replace_creatorid_fields.sql b/database/configuration/database/sql/replace_creatorid_fields.sql
deleted file mode 100644
index 6f3162c1..00000000
--- a/database/configuration/database/sql/replace_creatorid_fields.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-
-# this sql statement fixes ownership for items that may have come in with
-# erroneous owner UUIDs due to second inventory and the vagaries of crossing
-# between grids.
-# this particular example is pretty brutal.  it finds any item that is owned
-# by the old avatar ID {old_ID} and swaps out the owner with the {new_ID}
-# avatar.  This task is made more difficult by the lack of a wildcard in
-# the SQL replace function, so we only stomp out one bogus ID at a time.
-
-UPDATE inventoryitems
-SET creatorid = replace(creatorid, '{old_ID}', '{new_ID}')
-WHERE creatorid == '{old_ID}';
-
-