evolution-cms / evolution

            $changed = false;

            $indexColumns = [];

            foreach ($index->getColumns() as $columnName) {

                $normalizedColumnName = strtolower($columnName);

                if ( ! isset($columnNames[$normalizedColumnName])) {

                    unset($indexes[$key]);

                    continue 2;

                } else {

                    $indexColumns[] = $columnNames[$normalizedColumnName];

                    if ($columnName !== $columnNames[$normalizedColumnName]) {

                        $changed = true;

                    }

                }

            }

            if ($changed) {

                $indexes[$key] = new Index($index->getName(), $indexColumns, $index->isUnique(), $index->isPrimary(), $index->getFlags());

        foreach ($foreignKeys as $key => $constraint) {

            $changed = false;

            $localColumns = [];

            foreach ($constraint->getLocalColumns() as $columnName) {

                $normalizedColumnName = strtolower($columnName);

                if ( ! isset($columnNames[$normalizedColumnName])) {

                    unset($foreignKeys[$key]);

                    continue 2;

                } else {

                    $localColumns[] = $columnNames[$normalizedColumnName];

                    if ($columnName !== $columnNames[$normalizedColumnName]) {

                        $changed = true;

                    }

                }

            }

            if ($changed) {

                $foreignKeys[$key] = new ForeignKeyConstraint($localColumns, $constraint->getForeignTableName(), $constraint->getForeignColumns(), $constraint->getName(), $constraint->getOptions());