summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/migrations/2020_06_18_155337_create_match_team_table.php36
-rw-r--r--database/migrations/2020_06_18_155337_create_match_tournament_table.php35
-rw-r--r--database/migrations/2020_06_18_155337_create_matches_table.php38
-rw-r--r--database/migrations/2020_06_18_155355_create_teams_table.php34
-rw-r--r--database/migrations/2020_06_18_155355_create_tournaments_table.php34
-rw-r--r--database/migrations/2020_06_18_155412_create_venues_table.php35
-rw-r--r--database/seeds/DatabaseSeeder.php5
-rw-r--r--database/seeds/MatchSeeder.php58
-rw-r--r--database/seeds/TeamSeeder.php51
-rw-r--r--database/seeds/TournamentSeeder.php21
-rw-r--r--database/seeds/VenueSeeder.php51
11 files changed, 397 insertions, 1 deletions
diff --git a/database/migrations/2020_06_18_155337_create_match_team_table.php b/database/migrations/2020_06_18_155337_create_match_team_table.php
new file mode 100644
index 0000000..a1e7d0e
--- /dev/null
+++ b/database/migrations/2020_06_18_155337_create_match_team_table.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateMatchTeamTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create(
+ 'match_team', function (Blueprint $table) {
+ $table->id();
+ $table->unsignedInteger('match_id');
+ $table->unsignedInteger('team_id');
+ $table->boolean('is_home');
+ $table->timestamps();
+ }
+ );
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('match_team');
+ }
+}
diff --git a/database/migrations/2020_06_18_155337_create_match_tournament_table.php b/database/migrations/2020_06_18_155337_create_match_tournament_table.php
new file mode 100644
index 0000000..02f0e91
--- /dev/null
+++ b/database/migrations/2020_06_18_155337_create_match_tournament_table.php
@@ -0,0 +1,35 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateMatchTournamentTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create(
+ 'match_tournament', function (Blueprint $table) {
+ $table->id();
+ $table->unsignedInteger('match_id');
+ $table->unsignedInteger('tournament_id');
+ $table->timestamps();
+ }
+ );
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('match_tournament');
+ }
+}
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');
+ }
+}
diff --git a/database/migrations/2020_06_18_155355_create_teams_table.php b/database/migrations/2020_06_18_155355_create_teams_table.php
new file mode 100644
index 0000000..3e0d58f
--- /dev/null
+++ b/database/migrations/2020_06_18_155355_create_teams_table.php
@@ -0,0 +1,34 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateTeamsTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create(
+ 'teams', function (Blueprint $table) {
+ $table->id();
+ $table->string('name');
+ $table->timestamps();
+ }
+ );
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('teams');
+ }
+}
diff --git a/database/migrations/2020_06_18_155355_create_tournaments_table.php b/database/migrations/2020_06_18_155355_create_tournaments_table.php
new file mode 100644
index 0000000..8dc267a
--- /dev/null
+++ b/database/migrations/2020_06_18_155355_create_tournaments_table.php
@@ -0,0 +1,34 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateTournamentsTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create(
+ 'tournaments', function (Blueprint $table) {
+ $table->id();
+ $table->string('name');
+ $table->timestamps();
+ }
+ );
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('tournaments');
+ }
+}
diff --git a/database/migrations/2020_06_18_155412_create_venues_table.php b/database/migrations/2020_06_18_155412_create_venues_table.php
new file mode 100644
index 0000000..e2c84b2
--- /dev/null
+++ b/database/migrations/2020_06_18_155412_create_venues_table.php
@@ -0,0 +1,35 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateVenuesTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create(
+ 'venues', function (Blueprint $table) {
+ $table->id();
+ $table->string('name');
+ $table->string('city')->nullable();
+ $table->timestamps();
+ }
+ );
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('venues');
+ }
+}
diff --git a/database/seeds/DatabaseSeeder.php b/database/seeds/DatabaseSeeder.php
index 237dfc5..21ec948 100644
--- a/database/seeds/DatabaseSeeder.php
+++ b/database/seeds/DatabaseSeeder.php
@@ -11,6 +11,9 @@ class DatabaseSeeder extends Seeder
*/
public function run()
{
- // $this->call(UserSeeder::class);
+ $this->call(VenueSeeder::class);
+ $this->call(TeamSeeder::class);
+ $this->call(TournamentSeeder::class);
+ $this->call(MatchSeeder::class);
}
}
diff --git a/database/seeds/MatchSeeder.php b/database/seeds/MatchSeeder.php
new file mode 100644
index 0000000..f0d95f6
--- /dev/null
+++ b/database/seeds/MatchSeeder.php
@@ -0,0 +1,58 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Rugby\Model;
+
+class MatchSeeder extends Seeder
+{
+ /**
+ * Run the database seeds.
+ *
+ * @return void
+ */
+ public function run()
+ {
+ $match1 = Model\Match::create(
+ [
+ 'venue_id' => 1,
+ ]
+ );
+
+ $match1->teams()->sync(
+ [
+ 1 => ['is_home' => true],
+ 4 => ['is_home' => false]
+ ]
+ );
+
+ $match2 = Model\Match::create(
+ [
+ 'venue_id' => 2,
+ ]
+ );
+
+ $match2->teams()->sync(
+ [
+ 2 => ['is_home' => true],
+ 5 => ['is_home' => false]
+ ]
+ );
+
+ $match3 = Model\Match::create(
+ [
+ 'venue_id' => 3,
+ ]
+ );
+
+ $match3->teams()->sync(
+ [
+ 3 => ['is_home' => true],
+ 6 => ['is_home' => false]
+ ]
+ );
+
+ $match1->tournaments()->sync(1);
+ $match2->tournaments()->sync(1);
+ $match3->tournaments()->sync(1);
+ }
+}
diff --git a/database/seeds/TeamSeeder.php b/database/seeds/TeamSeeder.php
new file mode 100644
index 0000000..250ce94
--- /dev/null
+++ b/database/seeds/TeamSeeder.php
@@ -0,0 +1,51 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Rugby\Model;
+
+class TeamSeeder extends Seeder
+{
+ /**
+ * Run the database seeds.
+ *
+ * @return void
+ */
+ public function run()
+ {
+ Model\Team::create(
+ [
+ 'name' => 'England'
+ ]
+ );
+
+ Model\Team::create(
+ [
+ 'name' => 'France'
+ ]
+ );
+
+ Model\Team::create(
+ [
+ 'name' => 'Italy'
+ ]
+ );
+
+ Model\Team::create(
+ [
+ 'name' => 'Wales'
+ ]
+ );
+
+ Model\Team::create(
+ [
+ 'name' => 'Scotland'
+ ]
+ );
+
+ Model\Team::create(
+ [
+ 'name' => 'Ireland'
+ ]
+ );
+ }
+}
diff --git a/database/seeds/TournamentSeeder.php b/database/seeds/TournamentSeeder.php
new file mode 100644
index 0000000..070e0fb
--- /dev/null
+++ b/database/seeds/TournamentSeeder.php
@@ -0,0 +1,21 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Rugby;
+
+class TournamentSeeder extends Seeder
+{
+ /**
+ * Run the database seeds.
+ *
+ * @return void
+ */
+ public function run()
+ {
+ Rugby\Tournament::create(
+ [
+ 'name' => 'RBS Six Nations'
+ ]
+ );
+ }
+}
diff --git a/database/seeds/VenueSeeder.php b/database/seeds/VenueSeeder.php
new file mode 100644
index 0000000..f95e4ef
--- /dev/null
+++ b/database/seeds/VenueSeeder.php
@@ -0,0 +1,51 @@
+<?php
+
+use Illuminate\Database\Seeder;
+use App\Rugby\Model;
+
+class VenueSeeder extends Seeder
+{
+ /**
+ * Run the database seeds.
+ *
+ * @return void
+ */
+ public function run()
+ {
+ Model\Venue::create(
+ [
+ 'name' => 'Twickenham'
+ ]
+ );
+
+ Model\Venue::create(
+ [
+ 'name' => 'Stade de France'
+ ]
+ );
+
+ Model\Venue::create(
+ [
+ 'name' => 'Stadio Olimpico'
+ ]
+ );
+
+ Model\Venue::create(
+ [
+ 'name' => 'Millennium Stadium'
+ ]
+ );
+
+ Model\Venue::create(
+ [
+ 'name' => 'Murrayfield Stadium'
+ ]
+ );
+
+ Model\Venue::create(
+ [
+ 'name' => 'Aviva Stadium'
+ ]
+ );
+ }
+}
generated by cgit v1.2.3 (git 2.25.1) at 2024-09-19 23:59:52 +0000