Changeset c6b84df for database/migrations

Timestamp:

10/21/21 23:45:59 (3 years ago)

Author:

beratkjufliju <kufliju@…>

Branches:

develop, master

Children:

4b7e2d3

Parents:

6b95845

Message:

added fileTypes controller, notifications, excel export, edited views

Location:

database/migrations

Files:

• 2021_09_27_171107_create_users_table.php (modified) (2 diffs)
• 2021_10_06_103305_create_folders_table.php (moved) (moved from database/migrations/2021_10_06_103305_create_documents_table.php ) (3 diffs)
• 2021_10_10_103309_create_files_table.php (modified) (1 diff)
• 2021_10_21_091521_create_notifications_table.php (added)
• 2021_10_21_144552_create_file_types_table.php (added)

database/migrations/2021_09_27_171107_create_users_table.php

@@ -20 +20 @@
             $table->string('surname');
             $table->string('username')->unique();
-            $table->string('password');
             $table->string('email')->unique();
             $table->string('phone_number')->unique();
@@ -30 +29 @@
             $table->boolean('is_confirmed')->default(false);
             $table->boolean('is_forgot_password')->default(false);
+            $table->integer("created_by")->unsigned();
             $table->integer('security_code')->nullable();
             $table->string('verify_token')->nullable();
-            $table->integer("created_by")->unsigned();
+            $table->string('password');
             $table->rememberToken();
             $table->timestamps();

database/migrations/2021_10_06_103305_create_folders_table.php

@@ -5 +5 @@
 use Illuminate\Support\Facades\Schema;
 
-class CreateDocumentsTable extends Migration
+class CreateFoldersTable extends Migration
 {
     /**
@@ -14 +14 @@
     public function up()
     {
-        Schema::create('documents', function (Blueprint $table) {
+        Schema::create('folders', function (Blueprint $table) {
             $table->bigIncrements('id');
             $table->string("arch_id")->unique();
             $table->string("name");
-            $table->text("description");
+            $table->text("note")->nullable();
+            $table->string("location");
             $table->integer("user_id")->unsigned();
             $table->integer("department_id")->unsigned();
-            $table->boolean("is_important")->default(true);
+            $table->boolean("is_important")->default(false);
             $table->timestamps();
 
@@ -36 +37 @@
     public function down()
     {
-        Schema::dropIfExists('documents');
+        Schema::dropIfExists('folders');
     }
 }

database/migrations/2021_10_10_103309_create_files_table.php

@@ -16 +16 @@
         Schema::create('files', function (Blueprint $table) {
             $table->bigIncrements('id');
-            $table->bigInteger('document_id')->unsigned();
+            $table->bigInteger('folder_id')->unsigned();
             $table->string("name");
             $table->string("location");
-            $table->foreign("document_id")->references("id")->on("documents");
+            $table->foreign("folder_id")->references("id")->on("folders");
             $table->timestamps();
         });