Posts

Showing posts with the label Laravel Migrations

Available Actions For OnUpdate / OnDelete In Laravel 5.x

Answer : You can do all the options mentioned in phpmyadmin this way: $table->...->onDelete('CASCADE'); $table->...->onDelete('SET NULL'); $table->...->onDelete('RESTRICT'); // do not call the onDelete() method if you want the RESTRICT option. You have to make sure you set the foreign key field as nullable: $table->...->unsigned()->nullable(); Referring to the source code: `vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php` in the function compileForeign() It just appends whatever you pass in to the table query. if (! is_null($command->onDelete)) { $sql .= " on delete {$command->onDelete}"; } if (! is_null($command->onUpdate)) { $sql .= " on update {$command->onUpdate}"; } So, make sure you pass one of the following: "cascade", "no action", "restrict", or "set null" NOTE: Do NOT use...