Example #1
0
 /**
  * @param Database $base
  * @param Database $target
  * @param bool $dropFields
  * @param bool $checkFKs
  * @return array
  */
 public function compareTables(Database $base, Database $target, $dropFields = false, $checkFKs = false)
 {
     $changeQueries = [];
     /** @var Table $table */
     foreach ($base->getTables() as $name => $table) {
         if ($target->hasTable($name)) {
             $query = $table->getChangeToQuery($target->getTableByName($name), $dropFields, $checkFKs);
             if ($query) {
                 $changeQueries[$name] = $query;
             }
         }
     }
     return $changeQueries;
 }