#! /usr/bin/php
  <?php
  include '../lib/common.php';
  include '../lib/db.php';
  
  // retrieve list of tables
  $table\_result\; =\; mysql\_query(\text{'}SHOW\; TABLES\text{'},$GLOBALS['DB']);
  while ($table\_row\; =\; mysql\_fetch\_array($table_result))
  {
      // retrieve list of column names in table 
      $column\_result\; =\; mysql\_query(\text{'}SHOW\; COLUMNS\; FROM\; \text{'}\; .$table_row[0],
          $GLOBALS[\text{'}DB\text{'}]);\; while\; ($column_row = mysql_fetch_assoc($column\_result))\; \{$// if the table has an IS_DELETED field then delete old records
          if (column_row['Field'] == 'IS_DELETED')
          {
              mysql_query('DELETE FROM ' . $table\_row[0]\; .\; \text{'}\; WHERE\; \text{'}\; .\; \text{'}IS\_DELETED\; =\; 1\text{'},$GLOBALS['DB']);
  
              // break out to process next table
              mysql_free_result($column\_result);\; break;\; \}\; \}\; mysql\_free\_result($column_result);
  }
  mysql_free_result($table\_result);\; mysql\_close($GLOBALS['DB']);
  ?>