Laravel advanced migration examples

index.php

<?php

Schema::create('visits', function (Blueprint $table) {
    $table->increments('id');
    $table->string('url');
    $table->json('data');
    
    // non-nullable timestamps
    $table->timestamp('created_at')->default(\DB::raw('CURRENT_TIMESTAMP'));
    $table->timestamp('updated_at')->default(\DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
    
    // generated virtual column from json with proper null casting
    $table->string('meta_country')->virtualAs("CASE WHEN data->>'$.country' = 'null' THEN NULL ELSE data->>'$.country' END");
    $table->index('meta_country');
});