source: database/migrations/2021_09_29_121244_create_departments_table.php@ 194a359

develop
Last change on this file since 194a359 was 194a359, checked in by beratkjufliju <kufliju@…>, 3 years ago

added departments, edited users and added user settings

  • Property mode set to 100644
File size: 843 bytes
Line 
1<?php
2
3use Illuminate\Database\Migrations\Migration;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Support\Facades\Schema;
6
7class CreateDepartmentsTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('departments', function (Blueprint $table) {
17 $table->increments('id');
18 $table->integer("user_id")->unsigned();
19 $table->string("name");
20 $table->string("code");
21 $table->timestamps();
22
23 $table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
24
25 });
26 }
27
28 /**
29 * Reverse the migrations.
30 *
31 * @return void
32 */
33 public function down()
34 {
35 Schema::dropIfExists('departments');
36 }
37}
Note: See TracBrowser for help on using the repository browser.