andriangungon
12/2/2017 - 3:37 AM

re-ordering or re-organizing table columns

reorder.php
content_copyfile_download
<?php

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

class ReorganizeOrderOfColumnVideoUrl extends Migration
{

    public function up()
    {
      
        DB::statement("ALTER TABLE app_videos MODIFY COLUMN category_id VARCHAR(255) AFTER video_url");
      
    }
      
    public function down()
    {
      
        DB::statement("ALTER TABLE app_videos MODIFY COLUMN category_id VARCHAR(255) AFTER category_id");
      
    }
}