You can create a new migration and change just one column type: public function up() { Schema::table(‘sometable’, function (Blueprint $table) { $table->text(‘text’)->change(); }); } You need to install doctrine/dbal to make this work composer require doctrine/dbal Works with Laravel 5.0+. It does not work with Laravel 4.2.
If you want to set null on delete: $table->…->onDelete(‘set null’); First make sure you set the foreign key field as nullable: $table->integer(‘foreign_id’)->unsigned()->nullable();
In the model, write the below code; public $timestamps = false; This would work. Explanation : By default laravel will expect created_at & updated_at column in your table. By making it to false it will override the default setting.
Laravel 5 now supports changing a column; here’s an example from the offical documentation: Schema::table(‘users’, function($table) { $table->string(‘name’, 50)->nullable()->change(); }); Source: http://laravel.com/docs/5.0/schema#changing-columns Laravel 4 does not support modifying columns, so you’ll need use another technique such as writing a raw SQL command. For example: // getting Laravel App Instance $app = app(); // getting laravel … Read more
To create a migration, you may use the migrate:make command on the Artisan CLI. Use a specific name to avoid clashing with existing models for Laravel 5+: php artisan make:migration add_paid_to_users_table –table=users for Laravel 3: php artisan migrate:make add_paid_to_users You then need to use the Schema::table() method (as you’re accessing an existing table, not creating … Read more