summaryrefslogtreecommitdiff
path: root/db/migrations/Reference.php
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrations/Reference.php')
-rw-r--r--db/migrations/Reference.php12
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;
}
}