Subversion-Projekte lars-tiefland.webanos.faltradxxs.de

<?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_portal_items', function ( Blueprint $table )
            {
                $table->id();
                $table->foreignId( 'sales_portal_id' )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
                $table->foreignId( 'item_id' )->nullable()->references( 'id' )->on( 'items' )->cascadeOnUpdate()->nullOnDelete();
                $table->foreignId( 'sales_portal_template_id' )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
                $table->string( 'sku' )->default( '' );
                $table->longText( 'additions' )->nullable()->default( '' );
                $table->string( 'foreign_item_id' )->default( '' );
                $table->string( 'name' )->default( '' );
                $table->boolean( 'autochange_name' )->default( '1' );
                $table->boolean( 'name_bold' )->default( '0' );
                $table->boolean( 'highlight' )->default( '0' );
                $table->string( 'sub_name' )->default( '' );
                $table->string( 'manufacturer' )->default( '' );
                $table->boolean( 'autochange_manufacturer' )->default( '1' );
                $table->string( 'ean' )->default( '' );
                $table->boolean( 'autochange_ean' )->default( '1' );
                $table->string( 'mpn' )->default( '' );
                $table->boolean( 'autochange_mpn' )->default( '1' );
                $table->text( 'description' )->default( '' );
                $table->boolean( 'autochange_description' )->default( '1' );
                $table->text( 'description_addition' )->default( '' );
                $table->boolean( 'autochange_description_addition' )->default( '1' );
                $table->float( 'price' )->default( '0' );
                $table->boolean( 'autochange_price' )->default( '1' );
                $table->char( 'currency', 3 )->default( 'EUR' );
                $table->unsignedTinyInteger( 'tax' )->default( '0' );
                $table->string( 'price_type' )->default( '' );
                $table->float( 'amount' )->default( '1' );
                $table->string( 'carrier' )->default( '' );
                $table->float( 'carrier_cost' )->default( '0' );
                $table->dateTime( 'start' )->nullable();
                $table->string( 'duration' )->default( '' );
                $table->string( 'category_1' )->default( '' );
                $table->string( 'category_2' )->default( '' );
                $table->string( 'category_3' )->default( '' );
                $table->text( 'bp1' )->default( '' );
                $table->text( 'bp2' )->default( '' );
                $table->text( 'bp3' )->default( '' );
                $table->text( 'bp4' )->default( '' );
                $table->text( 'bp5' )->default( '' );
                $table->text( 'platin_search_1' )->default( '' );
                $table->text( 'platin_search_2' )->default( '' );
                $table->text( 'platin_search_3' )->default( '' );
                $table->text( 'platin_search_4' )->default( '' );
                $table->text( 'platin_search_5' )->default( '' );
                $table->string( 'search_1' )->default( '' );
                $table->string( 'search_2' )->default( '' );
                $table->string( 'search_3' )->default( '' );
                $table->string( 'search_4' )->default( '' );
                $table->string( 'search_5' )->default( '' );
                $table->string( 'status' )->default( '' );
                $table->string( 'online_status' )->default( '' );
                $table->unsignedTinyInteger( 'delivery_time' )->default( '1' );
                $table->boolean( 'pickup' )->default( '0' );
                $table->text('last_feedback')->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_portal_items' );
        }
    };