ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / vaultchip.com / platform / plugins / payment / database / migrations

<?php

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

class CreatePaymentTables extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('payments', function (Blueprint $table) {
            $table->id();
            $table->string('currency', 120);
            $table->integer('user_id')->default(0)->unsigned();
            $table->string('charge_id', 60)->nullable();
            $table->string('payment_channel', 60)->nullable();
            $table->string('description', 255)->nullable();
            $table->decimal('amount', 15, 2)->unsigned();
            $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)->unsigned()->nullable();
            $table->string('refund_note', 255)->nullable();
            $table->timestamps();
        });
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('payments');
    }
}

[+] ..
[-] 2021_08_09_161302_add_metadata_column_to_payments_table.php [edit]
[-] 2021_05_24_034720_make_column_currency_nullable.php [edit]
[-] 2017_05_18_080441_create_payment_tables.php [edit]
[-] 2021_03_27_144913_add_customer_type_into_table_payments.php [edit]