Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara |
imported>Hendrik Brummermann No edit summary |
||
| Line 58: | 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 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 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> |
</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 |
|||