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(); }