source: database/migrations/2021_10_06_103305_create_folders_table.php@ 195c3cf

develop
Last change on this file since 195c3cf was 4b7e2d3, checked in by beratkjufliju <kufliju@…>, 3 years ago

bug fixes, edited export, added fileSeeder for DB testing

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