Advertisement
Guest User

Untitled

a guest
Sep 14th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.27 KB | None | 0 0
  1. 'connections' => [
  2.  
  3. 'sqlite' => [
  4. 'driver' => 'sqlite',
  5. 'database' => storage_path('database.sqlite'),
  6. 'prefix' => '',
  7. ],
  8.  
  9. 'mysql' => [
  10. 'driver' => 'mysql',
  11. 'host' => env('DB_HOST', 'localhost'),
  12. 'database' => env('DB_DATABASE', 'news'),
  13. 'username' => env('DB_USERNAME', 'root'),
  14. 'password' => env('DB_PASSWORD', ''),
  15. 'charset' => 'utf8',
  16. 'collation' => 'utf8_unicode_ci',
  17. 'prefix' => '',
  18. 'strict' => false,
  19. ],
  20.  
  21. 'pgsql' => [
  22. 'driver' => 'pgsql',
  23. 'host' => env('DB_HOST', 'localhost'),
  24. 'database' => env('DB_DATABASE', 'forge'),
  25. 'username' => env('DB_USERNAME', 'forge'),
  26. 'password' => env('DB_PASSWORD', ''),
  27. 'charset' => 'utf8',
  28. 'prefix' => '',
  29. 'schema' => 'public',
  30. ],
  31.  
  32. 'sqlsrv' => [
  33. 'driver' => 'sqlsrv',
  34. 'host' => env('DB_HOST', 'localhost'),
  35. 'database' => env('DB_DATABASE', 'forge'),
  36. 'username' => env('DB_USERNAME', 'forge'),
  37. 'password' => env('DB_PASSWORD', ''),
  38. 'charset' => 'utf8',
  39. 'prefix' => '',
  40. ],
  41.  
  42. ],
  43.  
  44. php artisan migrate:install
  45.  
  46. php artisan make:migration create_users_table
  47.  
  48. <?php
  49.  
  50. use IlluminateDatabaseSchemaBlueprint;
  51. use IlluminateDatabaseMigrationsMigration;
  52.  
  53. class CreateFlightsTable extends Migration
  54. {
  55. /**
  56. * Run the migrations.
  57. *
  58. * @return void
  59. */
  60. public function up()
  61. {
  62. Schema::create('flights', function (Blueprint $table) {
  63. $table->increments('id');
  64. $table->string('name');
  65. $table->string('airline');
  66. $table->timestamps();
  67. });
  68. }
  69.  
  70. /**
  71. * Reverse the migrations.
  72. *
  73. * @return void
  74. */
  75. public function down()
  76. {
  77. Schema::drop('flights');
  78. }
  79. }
  80.  
  81. php artisan
  82.  
  83. php artisan make:model ModelName
  84.  
  85. DB_CONNECTION=mysql
  86. DB_HOST=127.0.0.1
  87. DB_PORT=3306
  88. DB_DATABASE=dbname
  89. DB_USERNAME=root
  90. DB_PASSWORD=password
  91.  
  92. php artisan migrate:install
  93. php artisan make:migration users // for creating new table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement