laravellaravel-5migration

How to create unique indexes in Laravel?

I create table with migration in laravel 5.6.

I need create a unique indexes with migration.

My code is:

$table->index([
            'system',
            'code',
            'city',
            'seat',
            'type'
        ], 'PrimaryPayment');

But after run migrate . in phpmyadmin -> table -> table_name -> indexes show unique: No

How to create unique indexes?

Solution

  • You can use unique() method on migration:

    $table->string('email')->unique();

    Or like this for compound unique index:

    $table->unique([
        'system',
        'code',
        'city',
        'seat',
        'type'
    ], 'PrimaryPayment');