source: database/migrations/2021_09_29_121244_create_departments_table.php

Last change on this file was 5e56e8a, checked in by beratkjufliju <kufliju@…>, 3 years ago

edited faker

  • Property mode set to 100644
File size: 959 bytes
RevLine 
[194a359]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) {
[5e56e8a]17 $table->increments('id')->startingValue(1);
[194a359]18 $table->string("name");
[b39afb5]19 $table->integer("code");
[4b7e2d3]20 $table->integer("user_id")->unsigned();
[24a616f]21 $table->string("location");
[4b7e2d3]22 $table->integer("no_of_folders")->default(0);
[194a359]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.