Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 90: | Line 90: | ||
<source lang="sql"> |
<source lang="sql"> |
||
DELETE FROM |
DELETE FROM reached_achievement USING reached_achievement, del2 WHERE reached_achievement.charname = del2.charname; |
||
DELETE FROM postman USING del2 WHERE source = del2.charname; |
DELETE FROM postman USING postman, del2 WHERE source = del2.charname; |
||
DELETE FROM postman USING del2 WHERE target = del2.charname; |
DELETE FROM postman USING postman, del2 WHERE target = del2.charname; |
||
DELETE FROM buddy USING del2 WHERE buddy.charname = del2.charname; |
DELETE FROM buddy USING buddy, del2 WHERE buddy.charname = del2.charname; |
||
DELETE FROM buddy USING del2 WHERE buddy.buddy = del2.charname; |
DELETE FROM buddy USING buddy, del2 WHERE buddy.buddy = del2.charname; |
||
DELETE FROM character_stats USING del2 WHERE name = 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, del2 SET halloffame.charname = concat('del.2012-05-06.', halloffame.charname) WHERE del2.charname=halloffame.charname; |
||
| Line 102: | 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 halloffame_archive, del2 SET halloffame_archive.charname = concat('del.2012-05-06.', halloffame_archive.charname) WHERE del2.charname=halloffame_archive.charname; |
||
UPDATE |
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> |
</source> |
||