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( 'actions', function ( Blueprint $table )
            {
                $table->id();
                $table->foreignId( 'shop_id' )->nullable()->constrained()->cascadeOnUpdate()->nullOnDelete();
                $table->string( "headline" )->default( "" );
                $table->text( "text" )->default( "" );
                $table->unsignedTinyInteger( 'art' )->default( '1' );
                $table->unsignedTinyInteger( 'rang' )->default( '0' );
                $table->text( "config" )->default( "" );
                $table->string( "category" )->default( "" );
                $table->text( "notes" )->default( "" );
                $table->date( 'valid_from' );
                $table->date( 'valid_to' );
                $table->string( 'created_by' )->default( '' );
                $table->string( 'updated_by' )->default( '' );
                $table->timestamps();
            } );
        }

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