File Manager

X7ROOT File Manager

Current Path: /home/gfecatvj/sites/realesbar/platform/plugins/payment/database/migrations

home / gfecatvj / sites / realesbar / platform / plugins / payment / database / migrations /

📁 ..
📄 2017_05_18_080441_create_payment_tables.php(854 B)
📄 2020_02_03_144309_update_column_payment_channel.php(790 B)
📄 2020_02_11_133026_add_description_to_table_payments.php(675 B)
📄 2020_03_23_093053_update_payments_table.php(1.31 KB)

Editing: 2020_03_23_093053_update_payments_table.php

<?php

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

class UpdatePaymentsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('payments', function (Blueprint $table) {
            $table->decimal('amount', 15, 2)->unsigned()->change();
            $table->integer('order_id')->unsigned()->nullable();
            $table->string('status', 60)->default('pending')->nullable();
            $table->string('payment_type')->default('confirm')->nullable();
            $table->integer('customer_id')->unsigned()->nullable();
            $table->decimal('refunded_amount', 15, 2)->unsigned()->nullable();
            $table->string('refund_note', 255)->nullable();
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('payments', function (Blueprint $table) {
            $table->decimal('amount', 15, 2)->unsigned()->change();
            $table->dropColumn([
                'status',
                'order_id',
                'payment_type',
                'customer_id',
                'refunded_amount',
                'refund_note',
            ]);
        });
    }
}

X7ROOT File Manager

Editing: 2020_03_23_093053_update_payments_table.php

Upload File

Create Folder