dbrax / bill-me

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateOrderItemsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('order_items', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->string('order_id');

            $table->integer('amount');

            $table->integer('quantity')->default(1);

            $table->string("item");

            $table->date("date");

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('order_details');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreatePaymentMethodTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('payment_method', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->string('pmethod'); //required attribute

            $table->string('apikey')->nullable(); //required attribute

            $table->string('apisecret')->nullable(); //required attribute

            $table->string('applicationid')->nullable(); //required attribute

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('order_details');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreatePaymentsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('payments', function (Blueprint $table) {

            $table->bigIncrements('id');

            $table->string('invoiceid'); //required attribute

            $table->string('orderid'); //required attribute

            $table->integer('amount'); //required attribute

            $table->string('status')->default('pending'); //required attribute

            $table->string('trackingid'); //required attribute

            $table->date("date");

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('order_details');

    }

}