diff options
4 files changed, 126 insertions, 0 deletions
diff --git a/database/migrations/2020_04_24_182936_create_airing_status.php b/database/migrations/2020_04_24_182936_create_airing_status.php new file mode 100644 index 0000000..79c99a1 --- /dev/null +++ b/database/migrations/2020_04_24_182936_create_airing_status.php @@ -0,0 +1,31 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class CreateAiringStatus extends Migration +{ + /** + * Run the migrations. + * + * @return void + */ + public function up() + { + Schema::create('airing_status', function (Blueprint $table) { + $table->bigIncrements('id'); + $table->string('status')->unique(); + }); + } + + /** + * Reverse the migrations. + * + * @return void + */ + public function down() + { + Schema::dropIfExists('airing_status'); + } +} diff --git a/database/migrations/2020_04_24_183157_fix_bug_with_airing_column.php b/database/migrations/2020_04_24_183157_fix_bug_with_airing_column.php new file mode 100644 index 0000000..683878a --- /dev/null +++ b/database/migrations/2020_04_24_183157_fix_bug_with_airing_column.php @@ -0,0 +1,32 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class FixBugWithAiringColumn extends Migration +{ + /** + * Run the migrations. + * + * @return void + */ + public function up() + { + Schema::table('anime', function (Blueprint $table) { + $table->unsignedBigInteger('airing_status')->default(4); + }); + } + + /** + * Reverse the migrations. + * + * @return void + */ + public function down() + { + Schema::table('anime', function (Blueprint $table) { + $table->dropColumn('airing_status'); + }); + } +} diff --git a/database/migrations/2020_04_24_185058_add_fk_airing_status.php b/database/migrations/2020_04_24_185058_add_fk_airing_status.php new file mode 100644 index 0000000..84c5f8b --- /dev/null +++ b/database/migrations/2020_04_24_185058_add_fk_airing_status.php @@ -0,0 +1,32 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class AddFkAiringStatus extends Migration +{ + /** + * Run the migrations. + * + * @return void + */ + public function up() + { + Schema::table('anime', function (Blueprint $table) { + $table->foreign('airing_status')->references('id')->on('airing_status'); + }); + } + + /** + * Reverse the migrations. + * + * @return void + */ + public function down() + { + Schema::table('anime', function (Blueprint $table) { + // + }); + } +} diff --git a/database/seeds/AiringStatusSeeder.php b/database/seeds/AiringStatusSeeder.php new file mode 100644 index 0000000..7017842 --- /dev/null +++ b/database/seeds/AiringStatusSeeder.php @@ -0,0 +1,31 @@ +<?php + +use Illuminate\Database\Seeder; + +class AiringStatusSeeder extends Seeder +{ + /** + * Run the database seeds. + * + * @return void + */ + public function run() + { + DB::table('airing_status')->insert([ + 'id' => 1, + 'status' => 'Currently Airing' + ]); + DB::table('airing_status')->insert([ + 'id' => 2, + 'status' => 'Finished Airing' + ]); + DB::table('airing_status')->insert([ + 'id' => 3, + 'status' => 'Not Yet Aired' + ]); + DB::table('airing_status')->insert([ + 'id' => 4, + 'status' => 'Unknown' + ]); + } +} |