diff options
Diffstat (limited to 'database/migrations/2020_06_18_155337_create_matches_table.php')
-rw-r--r-- | database/migrations/2020_06_18_155337_create_matches_table.php | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/database/migrations/2020_06_18_155337_create_matches_table.php b/database/migrations/2020_06_18_155337_create_matches_table.php new file mode 100644 index 0000000..a443371 --- /dev/null +++ b/database/migrations/2020_06_18_155337_create_matches_table.php @@ -0,0 +1,38 @@ +<?php + +use Illuminate\Database\Migrations\Migration; +use Illuminate\Database\Schema\Blueprint; +use Illuminate\Support\Facades\Schema; + +class CreateMatchesTable extends Migration +{ + /** + * Run the migrations. + * + * @return void + */ + public function up() + { + Schema::create( + 'matches', function (Blueprint $table) { + $table->id(); + $table->unsignedInteger('venue_id')->nullable(); + $table->string('referee')->nullable(); + $table->string('score')->nullable(); + $table->string('half_score')->nullable(); + $table->dateTime('date')->nullable(); + $table->timestamps(); + } + ); + } + + /** + * Reverse the migrations. + * + * @return void + */ + public function down() + { + Schema::dropIfExists('matches'); + } +} |