Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/dceprojects.corals.io/Corals/modules/Survey/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

Schema::table('surv_responses', function (Blueprint $table) {
    $table->unsignedBigInteger('survey_id')->nullable();

    $table->foreign('survey_id')
        ->references('id')
        ->on('surv_surveys')
        ->onDelete('cascade')
        ->onUpdate('cascade');
});

$surveyMenu = \Corals\Menu\Models\Menu::query()->where('key', 'survey')->first();

\DB::table('menus')->insert([
    'parent_id' => $surveyMenu->id,
    'key' => null,
    'url' => config('survey.models.response.resource_url'),
    'active_menu_url' => config('survey.models.response.resource_url') . '*',
    'name' => 'Responses',
    'description' => 'Responses List Menu Item',
    'icon' => 'fa fa-check',
    'target' => null,
    'roles' => '["1"]',
    'order' => 0
]);