Changeset 4b7e2d3 for database/migrations

Timestamp:

10/23/21 04:03:46 (3 years ago)

Author:

beratkjufliju <kufliju@…>

Branches:

develop, master

Children:

b39afb5

Parents:

c6b84df

Message:

bug fixes, edited export, added fileSeeder for DB testing

Location:

database/migrations

Files:

• 2021_09_29_121244_create_departments_table.php (modified) (1 diff)
• 2021_10_06_103305_create_folders_table.php (modified) (1 diff)
• 2021_10_21_144552_create_file_types_table.php (modified) (1 diff)

database/migrations/2021_09_29_121244_create_departments_table.php

@@ -16 +16 @@
         Schema::create('departments', function (Blueprint $table) {
             $table->increments('id');
-            $table->integer("user_id")->unsigned();
             $table->string("name");
             $table->string("code");
+            $table->integer("user_id")->unsigned();
             $table->string("location");
+            $table->integer("no_of_folders")->default(0);
             $table->timestamps();
 

database/migrations/2021_10_06_103305_create_folders_table.php

@@ -20 +20 @@
             $table->text("note")->nullable();
             $table->string("location");
+            $table->integer("no_of_files")->default(0);
             $table->integer("user_id")->unsigned();
             $table->integer("department_id")->unsigned();

database/migrations/2021_10_21_144552_create_file_types_table.php

@@ -16 +16 @@
         Schema::create('file_types', function (Blueprint $table) {
             $table->increments('id');
-            $table->string("mimes")->default('mimes:');
+            $table->string("mimes")->default('jpg,jpeg,png,pdf,docx,xls,xlsx,txt,ppt,pptx');
             $table->integer("max_size");
             $table->integer("user_id")->unsigned();