# HG changeset patch
# User Ivo Smits <Ivo@UCIS.nl>
# Date 1302566011 -7200
# Node ID dc5a8e316e21461c3c8730456523fc02f434a536
# Parent  0dcdb73cbcbf7b8ddc874f5d9e33db8425d8db79
Add database cleanup script

diff -r 0dcdb73cbcbf -r dc5a8e316e21 dbcleanup.php
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/dbcleanup.php	Tue Apr 12 01:53:31 2011 +0200
@@ -0,0 +1,17 @@
+#!/usr/bin/php
+<?php
+chdir(__DIR__);
+require_once './common.php';
+
+docleanup('Orphaned peergroups', 'DELETE FROM `peergroups` WHERE `group` NOT IN (SELECT `id` FROM `groups`)');
+docleanup('Orphaned peergroups', 'DELETE FROM `peergroups` WHERE `peer` NOT IN (SELECT `id` FROM `peers`)');
+docleanup('Orphaned groupmessages', 'DELETE FROM `groupmessages` WHERE `group` NOT IN (SELECT `id` FROM `groups`)');
+docleanup('Orphaned messages', 'DELETE FROM `messages` WHERE `id` NOT IN (SELECT `message` FROM `groupmessages`)');
+docleanup('Orphaned groupmessages', 'DELETE FROM `groupmessages` WHERE `message` NOT IN (SELECT `id` FROM `messages`)');
+docleanup('Optimize', 'OPTIMIZE TABLE `groupmessages`, `groups`, `messages`, `peergroups`, `peer`');
+
+function docleanup($comment, $query) {
+	global $db;
+	$count = $db->update($query);
+	print($comment.': '.$count."\n");
+}