| commit | author | age | ||
| 2f9a34 | 1 | <?php |
| D | 2 | |
| 3 | use Illuminate\Database\Migrations\Migration; | |
| 4 | use Illuminate\Database\Schema\Blueprint; | |
| 5 | use Illuminate\Support\Facades\Schema; | |
| 6 | ||
| 7 | return new class extends Migration { | |
| 8 | public function up() | |
| 9 | { | |
| 10 | Schema::create('fakesso_products', function (Blueprint $table) { | |
| 11 | $table->increments('id')->comment('Identificatore univoco profilo'); | |
| 74853e | 12 | $table->string('productId', 255)->comment('identificatore del prodotto'); |
| 06f7b6 | 13 | $table->string('activationDate', 255)->nullable(); |
| FB | 14 | $table->string('changeStateDate', 255)->nullable(); |
| 15 | $table->string('inheritanceRule', 255)->nullable(); | |
| 16 | $table->string('buyCost', 255)->nullable(); | |
| 17 | $table->string('frequency', 255)->nullable(); | |
| 18 | $table->string('infoRecurringFees', 255)->nullable(); | |
| 19 | $table->string('invertStatus', 255)->nullable(); | |
| 20 | $table->integer('maxNumOfTry')->nullable(); | |
| 21 | $table->string('monopoliFlag', 255)->nullable(); | |
| 22 | $table->string('longDescription', 255)->nullable(); | |
| 23 | $table->string('longName', 255)->nullable(); | |
| 24 | $table->integer('productPosition')->nullable(); | |
| 25 | $table->integer('numberOfUsedTry')->nullable(); | |
| 26 | $table->integer('numberOfTryAvailable')->nullable(); | |
| 2f9a34 | 27 | $table->string('OMProductId', 255)->nullable(); |
| 74853e | 28 | $table->string('OMSource', 255)->nullable(); |
| 06f7b6 | 29 | $table->string('productType', 255)->nullable(); |
| FB | 30 | $table->string('shortDescription', 255)->nullable(); |
| 31 | $table->string('shortName', 255)->nullable(); | |
| 32 | $table->string('productStateOnSim', 255)->nullable(); | |
| 33 | $table->string('spyderId', 255)->nullable(); | |
| 34 | $table->string('flagCommitment', 255)->nullable(); | |
| 35 | $table->string('mm4MPromoId', 255)->nullable(); | |
| 36 | $table->string('idJoin', 255)->nullable(); | |
| 37 | $table->string('lastPaidFlag', 255)->nullable(); | |
| 38 | $table->string('offerType', 255)->nullable(); | |
| 39 | $table->string('lastChargeZeroReason', 255)->nullable(); | |
| 40 | //tmProduct | |
| 41 | $table->string('tmCode', 255)->nullable(); | |
| 42 | $table->string('tmDescription', 255)->nullable(); | |
| 43 | $table->string('tmActivationDate', 255)->nullable(); | |
| 44 | $table->string('____hashCodeCalc', 255)->nullable(); | |
| 7e64cc | 45 | $table->timestamps(); |
| 2f9a34 | 46 | }); |
| D | 47 | } |
| 48 | ||
| 49 | public function down() | |
| 50 | { | |
| 51 | Schema::dropIfExists('fakesso_products'); | |
| 52 | } | |
| 53 | }; | |
