<?php
|
|
use Illuminate\Database\Migrations\Migration;
|
use Illuminate\Database\Schema\Blueprint;
|
use Illuminate\Support\Facades\Schema;
|
|
return new class extends Migration {
|
public function up()
|
{
|
Schema::create('fakesso_products', function (Blueprint $table) {
|
$table->increments('id')->comment('Identificatore univoco profilo');
|
$table->string('productId', 255)->comment('identificatore del prodotto');
|
$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('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();
|
});
|
}
|
|
public function down()
|
{
|
Schema::dropIfExists('fakesso_products');
|
}
|
};
|
