DmitryDulepov\Realurl\ext_update::checkAndRenameTables PHP Method

    protected function checkAndRenameTables()
    {
        $tableMap = array('tx_realurl_pathcache' => 'tx_realurl_pathdata', 'tx_realurl_urlcache' => 'tx_realurl_urldata');
        $tables = $this->databaseConnection->admin_get_tables();
        foreach ($tableMap as $oldTableName => $newTableName) {
            if (isset($tables[$oldTableName])) {
                if (!isset($tables[$newTableName])) {
                    $this->databaseConnection->sql_query('ALTER TABLE ' . $oldTableName . ' RENAME TO ' . $newTableName);
                } else {
                    if ((int) $tables[$newTableName]['Rows'] === 0) {
                        $this->databaseConnection->sql_query('DROP TABLE ' . $newTableName);
                        $this->databaseConnection->sql_query('CREATE TABLE ' . $newTableName . ' LIKE ' . $oldTableName);
                        $this->databaseConnection->sql_query('INSERT INTO ' . $newTableName . ' SELECT * FROM ' . $oldTableName);
                    }
                    $this->databaseConnection->sql_query('DROP TABLE ' . $oldTableName);
                }
            }
        }
    }