XoopsModules25x / smallworld

    $msgTable = 'smallworld_messages';

    $column   = 'message';

    if ($successA = $tables->useTable($msgTable)) { // if this returns false, there is no table

        $attributes = $tables->getColumnAttributes($msgTable, $column);

        if (false === mb_strpos($attributes, ' TEXT')) { // assumes it's already been updated if TEXT found

            $successA = $tables->alterColumn($msgTable, $column, ' TEXT ');

        }

    }

    $comTable = 'smallworld_comments';

    $column   = 'comment';

    $comTable = 'smallworld_comments';

    $column   = 'comment';

    if ($successB = $tables->useTable($comTable)) { // if this returns false, there is no table

        $attributes = $tables->getColumnAttributes($comTable, $column);

        if (false === mb_strpos($attributes, ' TEXT')) { // assumes it's already been updated if 'TEXT' not found

            $successB = $tables->alterColumn($comTable, $column, ' TEXT ');

        }

    }

    // now create smallworld_settings table if it doesn't exist

    $sTable = 'smallworld_settings';