laravel migration nullable code example
Example 1: laravel migration make column nullable
Schema::table('users', function($table)
{
$table->string('name', 50)->nullable()->change();
});
This is the correct syntax to revert the migration:
$table->integer('user_id')->unsigned()->nullable(false)->change();
Example 2: 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');
});
Example 3: laravel create migration
php artisan make:migration add_votes_to_users_table --table=users
php artisan make:migration create_users_table --create=users
Example 4: migrations required field laravel
$table->string('foo')->nullable(false)->change();
Example 5: laravel make migration
php artisan make:migration CreateUsersTable
Example 6: datetime-local laravel migration data type
public function getDateStartAttribute($value)
{
return Carbon::parse($value)->format('Y-m-d\TH:i');
}
public function getDateEndAttribute($value)
{
return Carbon::parse($value)->format('Y-m-d\TH:i');
}