database.php 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. <?php
  2. return [
  3. 'default' => env('DB_CONNECTION', 'mysql'),
  4. 'connections' => [
  5. 'sqlite' => [
  6. 'driver' => 'sqlite',
  7. 'url' => env('DATABASE_URL'),
  8. 'database' => env('DB_DATABASE', databasePath('database.sqlite')),
  9. 'prefix' => '',
  10. 'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
  11. ],
  12. 'mysql' => [
  13. 'driver' => 'mysql',
  14. 'url' => env('DATABASE_URL'),
  15. 'host' => env('DB_HOST', '127.0.0.1'),
  16. 'port' => env('DB_PORT', '3306'),
  17. 'database' => env('DB_DATABASE', 'forge'),
  18. 'username' => env('DB_USERNAME', 'forge'),
  19. 'password' => env('DB_PASSWORD', ''),
  20. 'unix_socket' => env('DB_SOCKET', ''),
  21. 'charset' => 'utf8mb4',
  22. 'collation' => 'utf8mb4_unicode_ci',
  23. 'prefix' => '',
  24. 'prefix_indexes' => true,
  25. 'strict' => true,
  26. 'engine' => null,
  27. 'options' => extension_loaded('pdo_mysql') ? array_filter([
  28. PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
  29. ]) : [],
  30. ],
  31. 'pgsql' => [
  32. 'driver' => 'pgsql',
  33. 'url' => env('DATABASE_URL'),
  34. 'host' => env('DB_HOST', '127.0.0.1'),
  35. 'port' => env('DB_PORT', '5432'),
  36. 'database' => env('DB_DATABASE', 'forge'),
  37. 'username' => env('DB_USERNAME', 'forge'),
  38. 'password' => env('DB_PASSWORD', ''),
  39. 'charset' => 'utf8',
  40. 'prefix' => '',
  41. 'prefix_indexes' => true,
  42. 'search_path' => 'public',
  43. 'sslmode' => 'prefer',
  44. ],
  45. 'sqlsrv' => [
  46. 'driver' => 'sqlsrv',
  47. 'url' => env('DATABASE_URL'),
  48. 'host' => env('DB_HOST', 'localhost'),
  49. 'port' => env('DB_PORT', '1433'),
  50. 'database' => env('DB_DATABASE', 'forge'),
  51. 'username' => env('DB_USERNAME', 'forge'),
  52. 'password' => env('DB_PASSWORD', ''),
  53. 'charset' => 'utf8',
  54. 'prefix' => '',
  55. 'prefix_indexes' => true,
  56. // 'encrypt' => env('DB_ENCRYPT', 'yes'),
  57. // 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'),
  58. ],
  59. ]
  60. ];