/ database / migrations / 2024_05_23_094611_alter_for_oracle_references_2.php
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  };