agency-zhilfond

1
<?php
2

3
use Illuminate\Support\Str;
4

5
return [
6

7
    /*
8
    |--------------------------------------------------------------------------
9
    | Default Database Connection Name
10
    |--------------------------------------------------------------------------
11
    |
12
    | Here you may specify which of the database connections below you wish
13
    | to use as your default connection for database operations. This is
14
    | the connection which will be utilized unless another connection
15
    | is explicitly specified when you execute a query / statement.
16
    |
17
    */
18

19
    'default' => env('DB_CONNECTION', 'sqlite'),
20

21
    /*
22
    |--------------------------------------------------------------------------
23
    | Database Connections
24
    |--------------------------------------------------------------------------
25
    |
26
    | Below are all of the database connections defined for your application.
27
    | An example configuration is provided for each database system which
28
    | is supported by Laravel. You're free to add / remove connections.
29
    |
30
    */
31

32
    'connections' => [
33

34
        'sqlite' => [
35
            'driver' => 'sqlite',
36
            'url' => env('DB_URL'),
37
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
38
            'prefix' => '',
39
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
40
            'busy_timeout' => null,
41
            'journal_mode' => null,
42
            'synchronous' => null,
43
        ],
44

45
        'mysql' => [
46
            'driver' => 'mysql',
47
            'url' => env('DB_URL'),
48
            'host' => env('DB_HOST', '127.0.0.1'),
49
            'port' => env('DB_PORT', '3306'),
50
            'database' => env('DB_DATABASE', 'laravel'),
51
            'username' => env('DB_USERNAME', 'root'),
52
            'password' => env('DB_PASSWORD', ''),
53
            'unix_socket' => env('DB_SOCKET', ''),
54
            'charset' => env('DB_CHARSET', 'utf8mb4'),
55
            'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
56
            'prefix' => '',
57
            'prefix_indexes' => true,
58
            'strict' => true,
59
            'engine' => null,
60
            'options' => extension_loaded('pdo_mysql') ? array_filter([
61
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
62
            ]) : [],
63
        ],
64

65
        'mariadb' => [
66
            'driver' => 'mariadb',
67
            'url' => env('DB_URL'),
68
            'host' => env('DB_HOST', '127.0.0.1'),
69
            'port' => env('DB_PORT', '3306'),
70
            'database' => env('DB_DATABASE', 'laravel'),
71
            'username' => env('DB_USERNAME', 'root'),
72
            'password' => env('DB_PASSWORD', ''),
73
            'unix_socket' => env('DB_SOCKET', ''),
74
            'charset' => env('DB_CHARSET', 'utf8mb4'),
75
            'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
76
            'prefix' => '',
77
            'prefix_indexes' => true,
78
            'strict' => true,
79
            'engine' => null,
80
            'options' => extension_loaded('pdo_mysql') ? array_filter([
81
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
82
            ]) : [],
83
        ],
84

85
        'pgsql' => [
86
            'driver' => 'pgsql',
87
            'url' => env('DB_URL'),
88
            'host' => env('DB_HOST', '127.0.0.1'),
89
            'port' => env('DB_PORT', '5432'),
90
            'database' => env('DB_DATABASE', 'laravel'),
91
            'username' => env('DB_USERNAME', 'root'),
92
            'password' => env('DB_PASSWORD', ''),
93
            'charset' => env('DB_CHARSET', 'utf8'),
94
            'prefix' => '',
95
            'prefix_indexes' => true,
96
            'search_path' => 'public',
97
            'sslmode' => 'prefer',
98
        ],
99

100
        'sqlsrv' => [
101
            'driver' => 'sqlsrv',
102
            'url' => env('DB_URL'),
103
            'host' => env('DB_HOST', 'localhost'),
104
            'port' => env('DB_PORT', '1433'),
105
            'database' => env('DB_DATABASE', 'laravel'),
106
            'username' => env('DB_USERNAME', 'root'),
107
            'password' => env('DB_PASSWORD', ''),
108
            'charset' => env('DB_CHARSET', 'utf8'),
109
            'prefix' => '',
110
            'prefix_indexes' => true,
111
            // 'encrypt' => env('DB_ENCRYPT', 'yes'),
112
            // 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'),
113
        ],
114

115
    ],
116

117
    /*
118
    |--------------------------------------------------------------------------
119
    | Migration Repository Table
120
    |--------------------------------------------------------------------------
121
    |
122
    | This table keeps track of all the migrations that have already run for
123
    | your application. Using this information, we can determine which of
124
    | the migrations on disk haven't actually been run on the database.
125
    |
126
    */
127

128
    'migrations' => [
129
        'table' => 'migrations',
130
        'update_date_on_publish' => true,
131
    ],
132

133
    /*
134
    |--------------------------------------------------------------------------
135
    | Redis Databases
136
    |--------------------------------------------------------------------------
137
    |
138
    | Redis is an open source, fast, and advanced key-value store that also
139
    | provides a richer body of commands than a typical key-value system
140
    | such as Memcached. You may define your connection settings here.
141
    |
142
    */
143

144
    'redis' => [
145

146
        'client' => env('REDIS_CLIENT', 'phpredis'),
147

148
        'options' => [
149
            'cluster' => env('REDIS_CLUSTER', 'redis'),
150
            'prefix' => env('REDIS_PREFIX', Str::slug(env('APP_NAME', 'laravel'), '_').'_database_'),
151
        ],
152

153
        'default' => [
154
            'url' => env('REDIS_URL'),
155
            'host' => env('REDIS_HOST', '127.0.0.1'),
156
            'username' => env('REDIS_USERNAME'),
157
            'password' => env('REDIS_PASSWORD'),
158
            'port' => env('REDIS_PORT', '6379'),
159
            'database' => env('REDIS_DB', '0'),
160
        ],
161

162
        'cache' => [
163
            'url' => env('REDIS_URL'),
164
            'host' => env('REDIS_HOST', '127.0.0.1'),
165
            'username' => env('REDIS_USERNAME'),
166
            'password' => env('REDIS_PASSWORD'),
167
            'port' => env('REDIS_PORT', '6379'),
168
            'database' => env('REDIS_CACHE_DB', '1'),
169
        ],
170

171
    ],
172

173
];
174