Laravel migration index

Laravel drop column

// To drop a column, use the dropColumn method on the schema builder.
// Before dropping columns from a SQLite database, you will need to add
// the doctrine/dbal dependency to your composer.json file and run the
// composer update command in your terminal to install the library:

Schema::table('users', function (Blueprint $table) {
    $table->dropColumn('votes');
});

Source: laravel.com

Laravel migration add unique column

Schema::table('tableName', function($table)
{
    $table->string('column-name')->unique(); //notice the parenthesis I added
});

Laravel migration index

$table->index(['account_id', 'created_at']);

Source: laravel.com

Similar codes

0 vote242 views1 answer
Php-oop
PHP
6 votes161 views4 answers
Laravel create project command
PHP
0 vote194 views1 answer
Increase the 'post_max_size'
PHP
2 votes172 views2 answers
Php reporting wrong time
PHP
0 vote193 views2 answers
Using the PHPExcel library to read an Excel file and transfer the data into a database
PHP
0 vote207 views1 answer
Display picture in pdf generated with laravel
PHP
0 vote169 views1 answer
Check current pages is a child page wordpress
PHP
0 vote158 views1 answer
Check php and wordpress version before activation
PHP
0 vote215 views1 answer
Php check if extension is installed
PHP
0 vote287 views1 answer
Drupal 9 loop term objects to retrieve term data (id, name, uuid)
PHP Drupal