/**
* get difference between tables in databases
*/
protected function compareTables()
{
$currentTables = $this->_currentDb->getTables();
$lastPublishedTables = $this->_publishedDb->getTables();
$this->_createTables = array_diff_key($currentTables, $lastPublishedTables);
$this->_dropTables = array_diff_key($lastPublishedTables, $currentTables);
$this->_commonTables = array_intersect_key($currentTables, $lastPublishedTables);
foreach ($this->_createTables as $tblName => $table) {
$this->addCreateTable($tblName);
}
foreach ($this->_dropTables as $tblName => $table) {
$this->addDropTable($tblName);
}
}
