source: database/migrations/2021_10_06_103305_create_documents_table.php@ b9c4a92

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

added pagination, is_important

  • 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 CreateDocumentsTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('documents', function (Blueprint $table) {
17 $table->bigIncrements('id');
18 $table->string("arch_id")->unique();
19 $table->string("name");
20 $table->text("description");
21 $table->integer("user_id")->unsigned();
22 $table->integer("department_id")->unsigned();
23 $table->boolean("is_important")->default(true);
24 $table->timestamps();
25
26 $table->foreign("user_id")->references("id")->on("users")->onDelete("cascade")->onUpdate("cascade");
27 $table->foreign("department_id")->references("id")->on("departments")->onDelete("cascade")->onUpdate("cascade");
28 });
29 }
30
31 /**
32 * Reverse the migrations.
33 *
34 * @return void
35 */
36 public function down()
37 {
38 Schema::dropIfExists('documents');
39 }
40}
Note: See TracBrowser for help on using the repository browser.