PaymentMethodTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	29
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up()
    {
        Schema::create('payment_method', function (Blueprint $table) {
            $table->increments('id');
            $table->boolean('active')->default(false);
            $table->integer('shop_id')->unsigned();
            $table->foreign('shop_id')->references('id')->on('shop')->onDelete('cascade');
            $table->string('title');
            $table->boolean('percent_of_total')->default(false);
            $table->decimal('price', 12, 4)->nullable();
            $table->decimal('cost_price', 12, 4)->nullable();
            $table->decimal('no_price_from', 12, 4)->nullable();
            $table->integer('tax_rate_id')->unsigned()->nullable();
            $table->foreign('tax_rate_id')->references('id')->on('tax_rate')->onDelete('set null');
            $table->boolean('payment_external')->default(false);
            $table->enum('mollie_external_payment_way', array('ideal', 'paysafecard', 'creditcard', 'mistercash', 'sofort', 'banktransfer', 'paypal', 'bitcoin', 'belfius'))->nullable();
            $table->string('mollie_api_key')->nullable();

            $table->enum('total_price_discount_type', array('amount', 'percent'))->nullable();
            $table->decimal('total_price_discount_value', 12, 4)->nullable();
            $table->date('total_price_discount_start_date')->nullable();
            $table->date('total_price_discount_end_date')->nullable();
            
            
            $table->integer('modified_by_user_id')->unsigned()->nullable();
            $table->foreign('modified_by_user_id')->references('id')->on('user')->onDelete('set null');
            $table->timestamps();

            $table->unique(array('title','shop_id'), 'unique_payment_method_title');
        });