RPeraltaJr
3/6/2018 - 5:18 PM

Add columns to existing tables using migrations

DATE_add_is_admin_column_to_posts_table.php
content_copyfile_download
<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddIsAdminColumnToPostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('posts', function (Blueprint $table) {
            //
            $table->tinyInteger('is_admin')->default('0'); // added
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('posts', function (Blueprint $table) {
            //
            $table->dropColumn('is_admin'); // added
        });
    }
}
terminal.md
content_copyfile_download
  • Rendered
  • Source

Make Migration

  1. add_is_admin_column_to_posts_table is file description
  2. --table="posts" is referencing table name php artisan make:migration add_is_admin_column_to_posts_table --table="posts"

Migrate

php artisan migrate