develop
Last change
on this file since 4b7e2d3 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 |
|
---|
3 | use Illuminate\Database\Migrations\Migration;
|
---|
4 | use Illuminate\Database\Schema\Blueprint;
|
---|
5 | use Illuminate\Support\Facades\Schema;
|
---|
6 |
|
---|
7 | class 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.