Q:

Laravel Migrations are migrating successfully but they are not creating foreign key relationship in tables

My Laravel App is creating all tables in migrations successfully but it's failing to create a foreign keys relationships in the table or even enforce cascade when I delete the primary record.
Here is the migration.
    Schema::create('articles', function (Blueprint $table) {
        $table->id('id');
        $table->unsignedBigInteger('user_id');
        $table->string('title');
        $table->text('excerpt');
        $table->text('body');
        $table->timestamps();

        $table->foreign('user_id')
            ->references('id')
            ->on('users')
            ->onDelete('cascade');

    });

When I run  php artisan migrate it's migrating successfully.
λ php artisan migrate

Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.11 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.1 seconds)
Migrating: 2019_08_19_000000_create_failed_jobs_table
Migrated:  2019_08_19_000000_create_failed_jobs_table (0.07 seconds)
Migrating: 2020_08_26_122846_create_articles_table
Migrated:  2020_08_26_122846_create_articles_table (0.14 seconds)

But, when I check the database, the relationship is not getting created, just and index for foreign key.
Check the Articles Table image in this link. I have marked the necessary parts
Check the Users Table image here. I have highlighted the primary key.
I have added some factory data relating the user and article and when I delete the user, the articles are being left as orphans.
What could be wrong?

PHP Version: 7.3.21
MySql Version: 5.7.31
MariaDB Version: 10.4.13
Laravel Framework Version: 7.25.0

Thank-you in advance.

A:

The question has been answered in the comment by @ShakilAhmmed here
All I did was go to config folder then database.php and change mysql database engine from null to innoDB
i.e.
From:
//...
'engine' => null,
//...

To:
//...
'engine' => 'InnoDB',
//...

