Subversion-Projekte lars-tiefland.webanos.marine-sales.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( 'price_agencies', function ( Blueprint $table )
            {
                $table->id();
                $table->foreignId( "shop_id" )->constrained()->cascadeOnUpdate()->cascadeOnDelete();
                $table->string( 'name' )->default( '' );
                $table->unsignedBigInteger( 'records' )->default( '0' );
                $table->string( "logo_url" )->default( '' );
                $table->string( 'home_url' )->default( '' );
                $table->string( "csv_url" )->default( '' );
                $table->string( 'trigger_url' )->default( '' );
                $table->string( 'voting_url' )->default( '' );
                $table->string( 'access_url' )->default( '' );
                $table->string( 'access_user' )->default( '' );
                $table->string( 'access_password' )->default( '' );
                $table->text( 'comment' )->default( '' );
                $table->json( 'locked_manufacturers' )->default( '[]' );
                $table->string( 'config' )->default( '' );
                $table->unsignedTinyInteger( 'status' )->default( "0" );
                $table->unsignedTinyInteger( 'only_deliverable' )->default( "1" );
                $table->float( 'min_price' )->default( '0.0' );
                $table->dateTime( 'last_updated_at' )->nullable();
                $table->dateTime( 'last_access_at' )->nullable();
                $table->string( 'last_access_by' )->default( '' );
                $table->string( 'created_by' )->default( '' );
                $table->string( 'updated_by' )->default( '' );
                $table->timestamps();
            } );
        }

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