diff options
Diffstat (limited to 'db/migrations/Reference.php')
-rw-r--r-- | db/migrations/Reference.php | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/db/migrations/Reference.php b/db/migrations/Reference.php index 4c35b59b..cc4e4fc9 100644 --- a/db/migrations/Reference.php +++ b/db/migrations/Reference.php @@ -3,16 +3,18 @@ namespace Engelsystem\Migrations; use Illuminate\Database\Schema\Blueprint; +use Illuminate\Database\Schema\ColumnDefinition; trait Reference { /** * @param Blueprint $table * @param bool $setPrimary + * @return ColumnDefinition */ - protected function referencesUser(Blueprint $table, $setPrimary = true) + protected function referencesUser(Blueprint $table, $setPrimary = false) { - $this->references($table, 'users', 'user_id', $setPrimary); + return $this->references($table, 'users', 'user_id', $setPrimary); } /** @@ -20,10 +22,11 @@ trait Reference * @param string $targetTable * @param string $fromColumn * @param bool $setPrimary + * @return ColumnDefinition */ protected function references(Blueprint $table, $targetTable, $fromColumn, $setPrimary = false) { - $table->unsignedInteger($fromColumn); + $definition = $table->unsignedInteger($fromColumn); if ($setPrimary) { $table->primary($fromColumn); @@ -31,6 +34,9 @@ trait Reference $table->foreign($fromColumn) ->references('id')->on($targetTable) + ->onUpdate('cascade') ->onDelete('cascade'); + + return $definition; } } |