davide.cucurnia@vola.it
2024-02-05 2f9a34f716957451b80dc2421e1794a264dba9d4
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_msisdn', function (Blueprint $table) {
11             $table->increments('id')->comment('Identificatore univoco msisdn');
12             $table->bigInteger('VodafoneUser')->unsigned()->comment('Vodafone User di appartenenza');
13             $table->string('MSISDN', 255)->nullable();
14             $table->string('CardType', 255)->nullable();
15             $table->string('IdPiano', 255)->nullable();
16             $table->string('VodafoneOne', 255)->nullable();
17             $table->string('TopClub', 255)->nullable();
18             $table->string('SenioriryCluster', 255)->nullable();
19         });
20     }
21
22     public function down()
23     {
24         Schema::dropIfExists('fakesso_msisdn');
25     }
26 };