Added foreign keys

5 files changed, 25 insertions, 3 deletions

diff --git a/database/migrations/2014_10_12_100000_create_password_resets_table.php b/database/migrations/2014_10_12_100000_create_password_resets_table.php
index 00057f9..a7dbd73 100644
--- a/database/migrations/2014_10_12_100000_create_password_resets_table.php
+++ b/database/migrations/2014_10_12_100000_create_password_resets_table.php
@@ -16,6 +16,10 @@ class CreatePasswordResetsTable extends Migration
             $table->string('email')->index();
             $table->string('token')->index();
             $table->timestamp('created_at');
+
+            $table->foreign('email')
+            ->references('email')
+            ->on('users');
         });
     }
 
diff --git a/database/migrations/2018_08_24_102348_create_post_types_table.php b/database/migrations/2018_08_21_102348_create_post_types_table.php
index 76f0370..0b804de 100644
--- a/database/migrations/2018_08_24_102348_create_post_types_table.php
+++ b/database/migrations/2018_08_21_102348_create_post_types_table.php
@@ -14,7 +14,7 @@ class CreatePostTypesTable extends Migration
     public function up()
     {
         Schema::create('post_types', function (Blueprint $table) {
-            $table->increments('id');
+            $table->increments('id')->unique();
             $table->string('type');
         });
     }
diff --git a/database/migrations/2018_08_24_102141_create_posts_table.php b/database/migrations/2018_08_22_102141_create_posts_table.php
index 644ad81..6154ca8 100644
--- a/database/migrations/2018_08_24_102141_create_posts_table.php
+++ b/database/migrations/2018_08_22_102141_create_posts_table.php
@@ -15,9 +15,17 @@ class CreatePostsTable extends Migration
     {
         Schema::create('posts', function (Blueprint $table) {
             $table->increments('id');
-            $table->integer('post_types_id');
-            $table->integer('user_id');
+            $table->integer('post_types_id')->unsigned();
+            $table->integer('user_id')->unsigned();
             $table->timestamps();
+
+            $table->foreign('user_id')
+                ->references('id')
+                ->on('users');
+
+            $table->foreign('post_types_id')
+                ->references('id')
+                ->on('post_types');
         });
     }
 
diff --git a/database/migrations/2018_08_23_231531_create_text_posts_table.php b/database/migrations/2018_08_23_231531_create_text_posts_table.php
index 702368e..82c2693 100644
--- a/database/migrations/2018_08_23_231531_create_text_posts_table.php
+++ b/database/migrations/2018_08_23_231531_create_text_posts_table.php
@@ -15,7 +15,12 @@ class CreateTextPostsTable extends Migration
     {
         Schema::create('text_posts', function (Blueprint $table) {
             $table->increments('id');
+            $table->integer('post_id')->unsigned()->unique();
             $table->string('text', 8192);
+
+            $table->foreign('post_id')
+                ->references('id')
+                ->on('posts');
         });
     }
 
diff --git a/database/migrations/2018_08_23_232015_create_media_posts_table.php b/database/migrations/2018_08_23_232015_create_media_posts_table.php
index f96c716..6a7e0e2 100644
--- a/database/migrations/2018_08_23_232015_create_media_posts_table.php
+++ b/database/migrations/2018_08_23_232015_create_media_posts_table.php
@@ -15,8 +15,13 @@ class CreateMediaPostsTable extends Migration
     {
         Schema::create('media_posts', function (Blueprint $table) {
             $table->increments('id');
+            $table->integer('post_id')->unsigned()->unique();
             $table->string('description');
             $table->string('media_path');
+
+            $table->foreign('post_id')
+                ->references('id')
+                ->on('posts');
         });
     }