/** * 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); } }