| 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'); | |
| b55a38 | 12 | $table->integer('LinkedUser')->unsigned()->comment('vodafoneuser di appartenenza'); |
| D | 13 | $table->foreign('LinkedUser')->references('id')->on('fakesso_vodafoneusers'); |
| 2f9a34 | 14 | $table->string('MSISDN', 255)->nullable(); |
| D | 15 | $table->string('CardType', 255)->nullable(); |
| 16 | $table->string('IdPiano', 255)->nullable(); | |
| 17 | $table->string('VodafoneOne', 255)->nullable(); | |
| 18 | $table->string('TopClub', 255)->nullable(); | |
| 06f7b6 | 19 | $table->string('SeniorityCluster', 255)->nullable(); |
| FB | 20 | $table->string('SimSeniorityDate', 255)->nullable(); |
| 7e64cc | 21 | $table->timestamps(); |
| 2f9a34 | 22 | }); |
| D | 23 | } |
| 24 | ||
| 25 | public function down() | |
| 26 | { | |
| 27 | Schema::dropIfExists('fakesso_msisdn'); | |
| 28 | } | |
| 29 | }; | |
