Support:Database Cleanup: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Hendrik Brummermann No edit summary |
||
Line 58:
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_08_17 WHERE charname=source);
DELETE FROM del2 WHERE EXISTS (SELECT null FROM itemlog WHERE charname = source);
DELETE FROM del2 WHERE EXISTS (SELECT null FROM kills WHERE kills.killed = charname AND killed_type='P');
DELETE FROM del2 WHERE EXISTS (SELECT null FROM kills WHERE kills.killer = charname AND killer_type='P');
</source>
=== Delete ===
<source lang="sql">
</source>
* reached_achievement
* postman.source
* postman.target
* halloffame.charname
* halloffame_archive.charname
* halloffame_archive_alltimes.charname
* halloffame_archive_recent.charname
* cid.charname
* characters.charname
* character_stats.name
* buddy.charname
* buddy.buddy
| |||