davide.cucurnia@vola.it
2024-06-27 72e18376d42d0313f6fb72c6940cd2095bc2d352
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_vodafoneusers', function (Blueprint $table) {
11             $table->increments('id')->comment('Identificatore univoco profilo');
16f0dd 12             $table->integer('LinkedMSISDN')->unsigned()->comment('identificatore MSISDN');
D 13             $table->foreign('LinkedMSISDN')->references('id')->on('fakesso_msisdn');
2f9a34 14             $table->string('Name', 255)->nullable();
D 15             $table->string('Surname', 255)->nullable();
16             $table->string('EmailAddress', 255)->nullable();
17             $table->string('ProfileIdentifier', 255)->nullable();
18             $table->string('FiscalCode', 255)->nullable();
19             $table->string('Type_ID', 255)->nullable();
20             $table->string('Custcode', 255)->nullable();
21             $table->string('EmailCSA', 255)->nullable();
22             $table->string('PIN_CSA', 255)->nullable();
23             $table->string('ID_CSA', 255)->nullable();
24             $table->string('Sex', 255)->nullable();
25             $table->string('BirthProvinceName', 255)->nullable();
26             $table->string('BirthPlace', 255)->nullable();
27             $table->string('HomeProvinceName', 255)->nullable();
28             $table->string('MicroBusiness', 255)->nullable();
29             $table->string('HomePhone', 255)->nullable();
30             $table->string('Address', 255)->nullable();
31         });
32     }
33
34     public function down()
35     {
36         Schema::dropIfExists('fakesso_vodafoneusers');
37     }
38 };