<?php

return [
    'class' => \yii\db\Connection::class,
    'driverName' => 'sqlsrv',
    'dsn' => 'sqlsrv:server=db;database=${PROJECT_NAME};encrypt=false',
    'username' => '${DB_USER}',
    'password' => '${DB_PASS}',
    'charset' => 'utf8',
    'attributes' => [
        \PDO::SQLSRV_ATTR_ENCODING => \PDO::SQLSRV_ENCODING_SYSTEM
    ]

    // Schema cache options (for production environment)
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 60,
    //'schemaCache' => 'cache',
];