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

        {

            if ( !Schema::hasTable( 'shops' ) )

            {

                Schema::create( 'shops', function ( Blueprint $table )

                {

                    $table->id();

                    $table->string( 'name' )->default( '' );

                    $table->string( "short", 4 )->default( '' );

                    $table->string( "re_short", 4 )->default( '' );

                    $table->unsignedTinyInteger( 'preisindex_ek' )->default( '1' );

                    $table->string( 'importtool' )->default( '' );

                    $table->unsignedTinyInteger( 'ebay' )->default( '0' );

                    $table->unsignedTinyInteger( 'klonziel' )->default( '0' );

                    $table->string( 'konroot' )->default( '' );

                    $table->unsignedTinyInteger( 'home' )->default( '0' );

                    $table->unsignedTinyInteger( 'erfassung' )->default( '0' );

                    $table->string( 'database' )->default( '' );

                    $table->string( 'order_db' )->default( '' );

                    $table->string( 'mail_server' )->default( '' );

                    $table->string( 'mail_user' )->default( '' );

                    $table->string( 'mail_password' )->default( '' );

                    $table->string( 'domain' )->default( '' );

                    $table->unsignedTinyInteger( 'status' )->default( '0' );

                    $table->unsignedInteger( 'rank' )->default( '0' );

                    $table->text( 'such_algo' )->default( '' );

                    $table->boolean( "uses_dump" )->default( '1' );

                    $table->boolean( "plesk" )->default( '1' );

                    $table->string( 'user' )->default( '' );

                    $table->string( 'server' )->default( '' );

                    $table->string( 'plesk_key' )->default( '' );

                    $table->timestamps();

                } );

            }

        }

        /**

         * Reverse the migrations.

         *

         * @return void

         */

        public function down(): void

        {

            Schema::dropIfExists( 'shops' );

        }

    };