Subversion-Projekte lars-tiefland.laravel_shop

<?php

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

    return new class extends Migration
    {
        /**
         * Run the migrations.
         *
         * @return void
         */
        public function up(): void
        {
            Schema::create( 'sales_portals', function ( Blueprint $table )
            {
                $table->id();
                $table->string( 'name' )->default( '' );
                $table->string( 'template' )->default( '' );
                $table->foreignId('sales_portal_type_id')->nullable()->references('id')->on('content_management.sales_portal_types')->cascadeOnUpdate()->nullOnDelete();
                $table->string( "sku_prefix" )->default( '' );
                $table->unsignedTinyInteger( 'price_number' )->default( '1' );
                $table->unsignedTinyInteger( 'base_price' )->default( '1' );
                $table->float( 'min_price' )->default( '0' );
                $table->float( 'max_price' )->default( '0' );
                $table->unsignedTinyInteger( 'digits' )->default( '2' );
                $table->unsignedTinyInteger( 'standard_amount' )->default( '0' );
                $table->string( 'item_url' )->default( '' );
                $table->string( 'currency', 3 )->default( 'EUR' );
                $table->text( 'shipping_state' )->default( '' );
                $table->string( 'delivery' )->default( 'DE_Paket' );
                $table->float( 'shipping_cost' )->default( '0' );
                $table->unsignedTinyInteger( 'afterbuy' )->default( '0' );
                $table->unsignedTinyInteger( 'salutation' )->default( '1' );
                $table->text( 'commit_fields' )->default( '' );
                $table->string( 'zip' )->default( '' );
                $table->string( 'location' )->default( '' );
                $table->string( 'created_by' )->default( '' );
                $table->string( 'updated_by' )->default( '' );
                $table->timestamps();
            } );
        }

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