User talk:Kymara: Difference between revisions

== cleanup postman table ==

;add indices on target and delivered (combined?)

;remove messages where the target does not correspond to an existing character name

:delete postman from postman left join characters on character.charname = postman.target where character.charname is null;

;remove messages where the target account.username is permanently banned (why do this first? it might get more?)

:delete postman from postman join account on account.username = postman.target where account.status='banned';

;remove messages where the target character has an account which is is permanently banned

:delete postman from postman join characters on character.charname = postman.target join account on account.id = characters.player_id where account.status='banned';

;remove any uncaught spam?

:delete from postman where source = 'Harold' and length(message)>1000;