| 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'); |
| b55a38 | 13 | //$table->integer('LinkedMSISDN')->unsigned()->comment('MSISDN di appartenenza'); |
| D | 14 | //$table->foreign('LinkedMSISDN')->references('id')->on('fakesso_msisdn'); |
| 74853e | 15 | $table->string('tmProduct', 255)->nullable(); |
| 2f9a34 | 16 | $table->string('tmCode', 255)->nullable(); |
| 74853e | 17 | $table->boolean('isService')->nullable(); |
| 2f9a34 | 18 | $table->string('OMProductId', 255)->nullable(); |
| 74853e | 19 | $table->string('OMSource', 255)->nullable(); |
| 2f9a34 | 20 | $table->string('Name', 255)->nullable(); |
| D | 21 | $table->string('Description', 255)->nullable(); |
| 74853e | 22 | $table->string('activationDateTime', 255)->nullable(); |
| 7e64cc | 23 | $table->timestamps(); |
| 2f9a34 | 24 | }); |
| D | 25 | } |
| 26 | ||
| 27 | public function down() | |
| 28 | { | |
| 29 | Schema::dropIfExists('fakesso_products'); | |
| 30 | } | |
| 31 | }; | |
