static function maint()
{
$db = DevblocksPlatform::getDatabaseService();
$logger = DevblocksPlatform::getConsoleLog();
$sql = "DELETE QUICK message FROM message LEFT JOIN ticket ON message.ticket_id = ticket.id WHERE ticket.id IS NULL";
$db->Execute($sql);
$logger->info('[Maint] Purged ' . $db->Affected_Rows() . ' message records.');
$sql = "DELETE QUICK message_header FROM message_header LEFT JOIN message ON message_header.message_id = message.id WHERE message.id IS NULL";
$db->Execute($sql);
$logger->info('[Maint] Purged ' . $db->Affected_Rows() . ' message_header records.');
$sql = "DELETE QUICK message_content FROM message_content LEFT JOIN message ON message_content.message_id = message.id WHERE message.id IS NULL";
$db->Execute($sql);
$logger->info('[Maint] Purged ' . $db->Affected_Rows() . ' message_content records.');
$sql = "DELETE QUICK message_note FROM message_note LEFT JOIN message ON message_note.message_id = message.id WHERE message.id IS NULL";
$db->Execute($sql);
$logger->info('[Maint] Purged ' . $db->Affected_Rows() . ' message_note records.');
DAO_Attachment::maint();
}
