#
# Persistence configuration for the Flow Framework
#

Neos:
  Flow:
    persistence:
      # Options for the default Doctrine persistence
      backendOptions:
        driver: 'pdo_mysql'
        host: NULL
        dbname: NULL
        user: NULL
        password: NULL
        charset: 'utf8mb4'
        collate: 'utf8mb4_unicode_ci'
        defaultTableOptions:
          charset: 'utf8mb4'
          collate: 'utf8mb4_unicode_ci'
      cacheAllQueryResults: FALSE

      doctrine:
        # By default Doctrine proxy compilation is done in the Flow bootstrap
        enable: TRUE
        sqlLogger: NULL
        filters:
          Flow_Security_Entity_Filter: 'Neos\Flow\Security\Authorization\Privilege\Entity\Doctrine\SqlFilter'

        # DBAL custom mapping types can be registered here
        dbal:
          mappingTypes:
            'flow_json_array':
              dbType: 'json_array'
              className: 'Neos\Flow\Persistence\Doctrine\DataTypes\JsonArrayType'
            'objectarray':
              dbType: 'array'
              className: 'Neos\Flow\Persistence\Doctrine\DataTypes\ObjectArray'

        # Doctrine ORM Lifecycle events and their subscribers and listeners.
        # See Flow manual, chapter "Persistence" for further information on how to subscribe to Doctrine events.
        eventSubscribers: []
        eventListeners: []

        secondLevelCache: []

        # List of regular expressions table names are matched against in the doctrine service
        # to prevent them from creating corresponding migrations.
        #
        # Example:
        # '^autogenerated_.*': TRUE
        # '^acme_package_.*: TRUE
        # (would skip tables starting with "autogenerated_" or "acme_package_" when calling doctrine:migrationgenerate)
        migrations:
          ignoredTables: []

#
# Persistence configuration for the Flow Framework
#

Neos:
  Flow:
    persistence:
      # Options for the default Doctrine persistence
      backendOptions:
        driver: 'pdo_mysql'
        host: NULL
        dbname: NULL
        user: NULL
        password: NULL
        charset: 'utf8mb4'
        defaultTableOptions:
          charset: 'utf8mb4'
      cacheAllQueryResults: FALSE

      doctrine:
        # By default Doctrine proxy compilation is done in the Flow bootstrap
        enable: TRUE
        sqlLogger: NULL
        filters:
          Flow_Security_Entity_Filter: 'Neos\Flow\Security\Authorization\Privilege\Entity\Doctrine\SqlFilter'

        # DBAL custom mapping types can be registered here
        dbal:
          mappingTypes:
            'flow_json_array':
              dbType: 'json_array'
              className: 'Neos\Flow\Persistence\Doctrine\DataTypes\JsonArrayType'
            'objectarray':
              dbType: 'array'
              className: 'Neos\Flow\Persistence\Doctrine\DataTypes\ObjectArray'

        # Doctrine ORM Lifecycle events and their subscribers and listeners.
        # See Flow manual, chapter "Persistence" for further information on how to subscribe to Doctrine events.
        eventSubscribers: []
        eventListeners: []

        secondLevelCache: []

        # List of regular expressions table names are matched against in the doctrine service
        # to prevent them from creating corresponding migrations.
        #
        # Example:
        # '^autogenerated_.*': TRUE
        # '^acme_package_.*: TRUE
        # (would skip tables starting with "autogenerated_" or "acme_package_" when calling doctrine:migrationgenerate)
        migrations:
          ignoredTables: []

Remove collate from default persistence settings
TASK: Remove collate from default persistence settings

This is set based on the charset to a sane default by Doczrine, so not
needed in the Flow settings.
