Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/ts.corals.io/corals-api/Corals/core/Settings/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php



use Illuminate\Database\Schema\Blueprint;

$tablesNeedPropertiesColumn = [
    'settings', 'model_settings', 'countries', 'modules', 'custom_field_settings'
];

foreach ($tablesNeedPropertiesColumn as $tableName) {
    if (Schema::hasTable($tableName) && !Schema::hasColumn($tableName, 'properties')) {
        Schema::table($tableName, function (Blueprint $table) {
            $table->text('properties')->nullable();
        });
    }
}

if (Schema::hasTable('custom_field_settings')) {
    Schema::table('custom_field_settings', function (Blueprint $table) {
        $dropColumns = [
            'type', 'name', 'label', 'required', 'options', 'options_options',
            'custom_attributes', 'default_value', 'validation_rules', 'status'
        ];
        foreach ($dropColumns as $column) {
            $table->dropColumn($column);
        }

        $table->text('fields')->after('model');
    });
}


\DB::table('permissions')->insert([
    'name' => 'Administrations::admin.core',
    'guard_name' => config('auth.defaults.guard'),
    'created_at' => \Carbon\Carbon::now(),
    'updated_at' => \Carbon\Carbon::now(),
]);