source: database/migrations/2021_10_06_103305_create_folders_table.php@ c6b84df

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

added fileTypes controller, notifications, excel export, edited views

  • Property mode set to 100644
File size: 1.1 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("user_id")->unsigned();
23 $table->integer("department_id")->unsigned();
24 $table->boolean("is_important")->default(false);
25 $table->timestamps();
26
27 $table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
28 $table->foreign("department_id")->references("id")->on("departments")->onDelete("cascade")->onUpdate("cascade");
29 });
30 }
31
32 /**
33 * Reverse the migrations.
34 *
35 * @return void
36 */
37 public function down()
38 {
39 Schema::dropIfExists('folders');
40 }
41}
Note: See TracBrowser for help on using the repository browser.