servers:
  docker:
    host: localhost
    description: Docker mariaDb
    mysql:
      port: 3306
      username: root
      password: mysql660

  localhost:
    host: localhost
    description: Local Mysql
    mysql:
      port: 3305
      username: root
      password: mysql660

  preprod:
    host: preprod.2iopenservice.com
    description: Preprod
    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

  prod-back:
    host: prod-back.2iopenservice.com
    description: Prod-Back
    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

  prod-front:
    host: prod-front.2iopenservice.com
    description: Prod-Front

    mysql:
      port: 3306
      username: dbcloner
      password: wWZ4hYcrmHLW2mUK
    ssh:
      key_file: ~/.ssh/id_rsa_exploitation
      port: 22
      user: exploitation

operations:
  crm:
    dbname: crm
    from_server: preprod
    to_server: docker
    is_default: True
    ignore_tables: []
    ignore_views: []
    structure_only: []
    compress: True
#    filter_tables: []

  adminassos:
    dbname: adminassos
    from_server: preprod
    to_server: docker

  openassos:
    dbname: openassos
    from_server: preprod
    to_server: docker
    is_default: True
    ignore_tables: ['Access', 'matomo.*', 'user_piwik.*', 'zzz_.*', 'tt_content_save', 'tt_content_v59']
    structure_only: ['cf_cache_.*', 'sys_log']

  opentalent:
    dbname: opentalent
    from_server: preprod
    to_server: docker
    structure_only: []
    ignore_tables: ['Audit_.*']
    ignore_views: ['view_audit']

  metabase:
    dbname: metabase
    from_server: preprod
    to_server: docker