2024_05_23_094611_alter_for_oracle_references_2.php
1 <?php 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 /** 9 * Run the migrations. 10 * 11 * @return void 12 */ 13 public function up() 14 { 15 Schema::table('toe_types', function (Blueprint $table) { 16 17 $table->integer('oracle_tpcode')->index()->nullable(); 18 }); 19 20 21 Schema::table('entities', function (Blueprint $table) { 22 //this code will reference many different tables in oracle and the column name won't match 23 $table->integer('oracle_code')->index()->nullable(); 24 }); 25 } 26 27 /** 28 * Reverse the migrations. 29 * 30 * @return void 31 */ 32 public function down() 33 { 34 // 35 } 36 };