creazione seeder + ampliamento colonne tabelle

Filippo Bertilotti

5 days ago 06f7b6188fe152cd561e60ff1abf2bac56773347

 database/migrations/2023_05_02_170505_create_fakesso_products.php

@@ -10,16 +10,38 @@
        Schema::create('fakesso_products', function (Blueprint $table) {
            $table->increments('id')->comment('Identificatore univoco profilo');
            $table->string('productId', 255)->comment('identificatore del prodotto');
            //$table->integer('LinkedMSISDN')->unsigned()->comment('MSISDN di appartenenza');
            //$table->foreign('LinkedMSISDN')->references('id')->on('fakesso_msisdn');
            $table->string('tmProduct', 255)->nullable();
            $table->string('tmCode', 255)->nullable();
            $table->boolean('isService')->nullable();
            $table->string('activationDate', 255)->nullable();
            $table->string('changeStateDate', 255)->nullable();
            $table->string('inheritanceRule', 255)->nullable();
            $table->string('buyCost', 255)->nullable();
            $table->string('frequency', 255)->nullable();
            $table->string('infoRecurringFees', 255)->nullable();
            $table->string('invertStatus', 255)->nullable();
            $table->integer('maxNumOfTry')->nullable();
            $table->string('monopoliFlag', 255)->nullable();
            $table->string('longDescription', 255)->nullable();
            $table->string('longName', 255)->nullable();
            $table->integer('productPosition')->nullable();
            $table->integer('numberOfUsedTry')->nullable();
            $table->integer('numberOfTryAvailable')->nullable();
            $table->string('OMProductId', 255)->nullable();
            $table->string('OMSource', 255)->nullable();
            $table->string('Name', 255)->nullable();
            $table->string('Description', 255)->nullable();
            $table->string('activationDateTime', 255)->nullable();
            $table->string('productType', 255)->nullable();
            $table->string('shortDescription', 255)->nullable();
            $table->string('shortName', 255)->nullable();
            $table->string('productStateOnSim', 255)->nullable();
            $table->string('spyderId', 255)->nullable();
            $table->string('flagCommitment', 255)->nullable();
            $table->string('mm4MPromoId', 255)->nullable();
            $table->string('idJoin', 255)->nullable();
            $table->string('lastPaidFlag', 255)->nullable();
            $table->string('offerType', 255)->nullable();
            $table->string('lastChargeZeroReason', 255)->nullable();
            //tmProduct
            $table->string('tmCode', 255)->nullable();
            $table->string('tmDescription', 255)->nullable();
            $table->string('tmActivationDate', 255)->nullable();
            $table->string('____hashCodeCalc', 255)->nullable();
            $table->timestamps();
        });
    }