Support:Database Cleanup: Difference between revisions

← Older edit

Content deleted Content added

VisualWikitext

Revision as of 18:28, 6 May 2012 view source imported>Hendrik Brummermann →Delete ← Older edit		Latest revision as of 18:46, 6 May 2012 view source imported>Hendrik Brummermann →Delete
(8 intermediate revisions by the same user not shown)
Line 90: <source lang="sql"> DELETE FROM ~~reached_archivement~~reached_achievement USING reached_achievement, del2 WHERE ~~reached_archivement~~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; Line 102: UPDATE halloffame_archive, del2 SET halloffame_archive.charname = concat('del.2012-05-06.', halloffame_archive.charname) WHERE del2.charname=halloffame_archive.charname; UPDATE ~~characters~~cid, del2 SET ~~characters~~cid.charname = concat('del.2012-05-06.', ~~characters~~cid.charname) WHERE del2.charname=~~characters~~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>