include $FANNIE_ROOT . 'classlib2.0/FannieAPI.php';
}
/* HELP
This script dumps prodUpdate into an archive
table and truncates it. Keeping prodUpdate
small makes scanning it for interesting changes
a faster process.
This should be called *after* any other compress
scripts.
*/
set_time_limit(0);
ini_set('memory_limit', '256M');
$sql = new SQLManager($FANNIE_SERVER, $FANNIE_SERVER_DBMS, $FANNIE_OP_DB, $FANNIE_SERVER_USER, $FANNIE_SERVER_PW);
$matching = $sql->matchingColumns('prodUpdate', 'prodUpdateArchive');
$col_list = '';
foreach ($matching as $column) {
if ($column == 'prodUpdateID') {
continue;
}
$col_list .= $column . ',';
}
$col_list = substr($col_list, 0, strlen($col_list) - 1);
$worked = $sql->query("INSERT INTO prodUpdateArchive ({$col_list}) SELECT {$col_list} FROM prodUpdate");
if ($worked) {
$sql->query("TRUNCATE TABLE prodUpdate");
} else {
echo "There was an archiving error on prodUpdate\n";
flush();
}
