source: database/migrations/2021_09_29_121244_create_departments_table.php@ a8346eb

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

minor bug fixes

  • Property mode set to 100644
File size: 941 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->string("name");
19 $table->integer("code");
20 $table->integer("user_id")->unsigned();
21 $table->string("location");
22 $table->integer("no_of_folders")->default(0);
23 $table->timestamps();
24
25 $table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
26 });
27 }
28
29 /**
30 * Reverse the migrations.
31 *
32 * @return void
33 */
34 public function down()
35 {
36 Schema::dropIfExists('departments');
37 }
38}
Note: See TracBrowser for help on using the repository browser.