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'); |
b55a38
|
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(); |
74853e
|
18 |
$table->string('Username', 255)->nullable(); |
2f9a34
|
19 |
$table->string('FiscalCode', 255)->nullable(); |
D |
20 |
$table->string('Type_ID', 255)->nullable(); |
|
21 |
$table->string('Custcode', 255)->nullable(); |
|
22 |
$table->string('EmailCSA', 255)->nullable(); |
|
23 |
$table->string('PIN_CSA', 255)->nullable(); |
|
24 |
$table->string('ID_CSA', 255)->nullable(); |
|
25 |
$table->string('Sex', 255)->nullable(); |
|
26 |
$table->string('BirthProvinceName', 255)->nullable(); |
|
27 |
$table->string('BirthPlace', 255)->nullable(); |
|
28 |
$table->string('HomeProvinceName', 255)->nullable(); |
|
29 |
$table->string('MicroBusiness', 255)->nullable(); |
|
30 |
$table->string('HomePhone', 255)->nullable(); |
|
31 |
$table->string('Address', 255)->nullable(); |
|
32 |
}); |
|
33 |
} |
|
34 |
|
|
35 |
public function down() |
|
36 |
{ |
|
37 |
Schema::dropIfExists('fakesso_vodafoneusers'); |
|
38 |
} |
|
39 |
}; |