Support:Database Cleanup: Difference between revisions

DELETE FROM reached_achievement USING reached_achievement, del2 WHERE reached_achievement.charname = del2.charname;

DELETE FROM postman USING postman, del2 WHERE source = del2.charname;

DELETE FROM postman USING postman, del2 WHERE target = del2.charname;

DELETE FROM buddy USING buddy, del2 WHERE buddy.charname = del2.charname;

DELETE FROM buddy USING buddy, del2 WHERE buddy.buddy = del2.charname;

DELETE FROM character_stats USING character_stats, del2 WHERE name = del2.charname;

UPDATE halloffame, del2 SET halloffame.charname = concat('del.2012-05-06.', halloffame.charname) WHERE del2.charname=halloffame.charname;

UPDATE halloffame_archive_alltimes, del2 SET halloffame_archive_alltimes.charname = concat('del.2012-05-06.', halloffame_archive_alltimes.charname) WHERE del2.charname=halloffame_archive_alltimes.charname;

UPDATE halloffame_archive_recent, del2 SET halloffame_archive_recent.charname = concat('del.2012-05-06.', halloffame_archive_recent.charname) WHERE del2.charname=halloffame_archive_recent.charname;

UPDATE halloffame_archive, del2 SET halloffame_archive.charname = concat('del.2012-05-06.', halloffame_archive.charname) WHERE del2.charname=halloffame_archive.charname;

UPDATE cid, del2 SET cid.charname = concat('del.2012-05-06.', cid.charname) WHERE del2.charname=cid.charname;

-- TODO account

UPDATE characters, del2 SET characters.status='deleted' AND characters.charname = concat('del.2012-05-06.', characters.charname) WHERE del2.charname=characters.charname;

</source>