000000_change_column_in_users_table.php

<?php


use App\Helpers\Traits\SQLServerServices;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class ChangeColumnInUsersTable extends Migration
{
    use SQLServerServices;

    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        if ($this->dropConstraints('sqlsrv', 'users', ['tanggal_daftar'])) {
            DB::statement("ALTER TABLE users ALTER COLUMN tanggal_daftar nvarchar(191)");
        }
    }
    
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        if ($this->dropConstraints('sqlsrv', 'users', ['tanggal_daftar'])) {
            DB::statement("ALTER TABLE users ALTER COLUMN tanggal_daftar datetime");
        }
    }
}