laravel migration add column to existing table
php artisan make:migration add_paid_to_users_table --table=users
public function up()
{
Schema::table('users', function($table) {
$table->integer('paid');
});
}
public function down()
{
Schema::table('users', function($table) {
$table->dropColumn('paid');
});
}
php artisan migrateadd a new column to existing table in a migration
// for Laravel 5+
php artisan make:migration add_email_to_users_table --table=users
public function up()
{
Schema::table('users', function($table) {
$table->integer('email');
});
}
public function down()
{
Schema::table('users', function($table) {
$table->dropColumn('email');
});
}
php artisan migratelaravel migration add column after
Schema::table('users', function ($table) {
$table->string('email')->after('id')->nullable();
});add column to migration laravel
php artisan make:migration add_profile_to_usersadd column to migration laravel
class AddProfileToUsers extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->string('profile')->nullable();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('shop_users', function (Blueprint $table) {
$table->dropColumn(['profile']);
});
}
}add new column in laravel migration
Schema::table('table_name', function (Blueprint $table) {
$table->string('column_name', 255)->nullable()->after('previous_column_name');
});Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
