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_vodafoneusers', function (Blueprint $table) {
11             $table->increments('id')->comment('Identificatore univoco profilo');
12             $table->string('Name', 255)->nullable();
13             $table->string('Surname', 255)->nullable();
14             $table->string('EmailAddress', 255)->nullable();
15             $table->string('ProfileIdentifier', 255)->nullable();
16             $table->string('FiscalCode', 255)->nullable();
17             $table->string('Type_ID', 255)->nullable();
18             $table->string('Custcode', 255)->nullable();
19             $table->string('EmailCSA', 255)->nullable();
20             $table->string('PIN_CSA', 255)->nullable();
21             $table->string('ID_CSA', 255)->nullable();
22             $table->string('Sex', 255)->nullable();
23             $table->string('BirthProvinceName', 255)->nullable();
24             $table->string('BirthPlace', 255)->nullable();
25             $table->string('HomeProvinceName', 255)->nullable();
26             $table->string('MicroBusiness', 255)->nullable();
27             $table->string('HomePhone', 255)->nullable();
28             $table->string('Address', 255)->nullable();
29         });
30     }
31
32     public function down()
33     {
34         Schema::dropIfExists('fakesso_vodafoneusers');
35     }
36 };