| Server IP : 78.140.185.180 / Your IP : 18.222.183.102 Web Server : LiteSpeed System : Linux cpanel13.v.fozzy.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : builderbox ( 1072) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/builderbox/www/common/Database/migrations/ |
Upload File : |
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class RenamePermissionsColumns extends Migration
{
public function up()
{
$tables = ['users', 'roles', 'billing_plans'];
foreach ($tables as $tableName) {
// rename permissions column
if (Schema::hasColumn($tableName, 'permissions')) {
Schema::table($tableName, function (Blueprint $table) {
$table->renameColumn('permissions', 'legacy_permissions');
});
}
// drop permissions index, if exists
Schema::table($tableName, function (Blueprint $table) use($tableName) {
$sm = Schema::getConnection()->getDoctrineSchemaManager();
$indexesFound = $sm->listTableIndexes($tableName);
if (array_key_exists('legacy_permissions', $indexesFound)) {
$table->dropIndex('legacy_permissions');
}
if (array_key_exists('permissions', $indexesFound)) {
$table->dropIndex('permissions');
}
});
}
}
public function down()
{
//
}
}