| 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(); | |
| 06f7b6 | 27 | $table->string('Birthdate', 255)->nullable(); |
| 2f9a34 | 28 | $table->string('BirthPlace', 255)->nullable(); |
| D | 29 | $table->string('HomeProvinceName', 255)->nullable(); |
| 30 | $table->string('MicroBusiness', 255)->nullable(); | |
| 31 | $table->string('HomePhone', 255)->nullable(); | |
| 32 | $table->string('Address', 255)->nullable(); | |
| 7e64cc | 33 | $table->timestamps(); |
| 2f9a34 | 34 | }); |
| D | 35 | } |
| 36 | ||
| 37 | public function down() | |
| 38 | { | |
| 39 | Schema::dropIfExists('fakesso_vodafoneusers'); | |
| 40 | } | |
| 41 | }; | |
