recreate migrations

devfake · Feb 26, 2016 · 22ac0c2 · 22ac0c2
1 parent 065e5b9
commit 22ac0c2
Show file tree

Hide file tree

Showing 3 changed files with 12 additions and 8 deletions.
diff --git a/backend/database/migrations/2015_07_09_071718_create_items_table.php b/backend/database/migrations/2015_07_09_071718_create_items_table.php
@@ -19,9 +19,8 @@ public function up()
             $table->index('title');
             $table->string('slug');
             $table->string('poster');
-            $table->integer('category_id')->nullable();
-            //$table->integer('category_id')->unsigned();
-            //$table->foreign('category_id')->references('id')->on('categories');
+            $table->integer('category_id')->unsigned();
+            $table->foreign('category_id')->references('id')->on('categories');
             $table->string('rating');
             $table->integer('released');
             $table->integer('seen');

diff --git a/backend/database/seeds/CategoryTableSeeder.php b/backend/database/seeds/CategoryTableSeeder.php
@@ -11,7 +11,12 @@ class CategoryTableSeeder extends Seeder
      */
     public function run()
     {
-       DB::table('categories')->insert([
+        DB::table('categories')->insert([
+          'name' => 'No Category',
+          'slug' => 'all'
+        ]);
+
+        DB::table('categories')->insert([
           'name' => 'Horror',
           'slug' => 'horror'
         ]);

diff --git a/backend/database/seeds/ItemTableSeeder.php b/backend/database/seeds/ItemTableSeeder.php
@@ -29,7 +29,7 @@ public function run()
         'title' => 'Jurassic World',
           'slug' => Str::slug('Jurassic World'),
           'poster' => '/uXZYawqUsChGSj54wcuBtEdUJbh.jpg',
-          'category_id' => null,
+          'category_id' => 1,
           'rating' => 4.5,
           'released' => '1429912800',
           'seen' => '1429912800',
@@ -53,7 +53,7 @@ public function run()
         'title' => 'The Babadook',
           'slug' => Str::slug('The Babadook'),
           'poster' => '/b3YzM03YxkOaJw2PglfKlcwr8bM.jpg',
-          'category_id' => null,
+          'category_id' => 1,
           'rating' => 4,
           'released' => '1429912800',
           'seen' => '1429912800',
@@ -127,7 +127,7 @@ public function run()
         'title' => 'Vikings',
           'slug' => Str::slug('Vikings'),
           'poster' => '/mBDlsOhNOV1MkNii81aT14EYQ4S.jpg',
-          'category_id' => null,
+          'category_id' => 1,
           'rating' => 5,
           'released' => '1429912800',
           'seen' => '1429912800',
@@ -199,7 +199,7 @@ public function run()
         'title' => 'Hunter x Hunter',
           'slug' => Str::slug('Hunter x Hunter'),
           'poster' => '/l5CLmiz0yPwusw3D10XaQDuSFTm.jpg',
-          'category_id' => null,
+          'category_id' => 1,
           'rating' => 5,
           'released' => '1429912800',
           'seen' => '1429912800',