for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
use Illuminate\Database\Schema\Blueprint;
class ModifyRolesAndPermissionsTableOptimizeIndexes extends BaseMigration
{
public function up()
$this->optimizeIndexes($this->user_roles, 'user_id', 'role_id');
$this->optimizeIndexes($this->role_permissions, 'role_id', 'permission_id');
}
public function down()
$this->revertIndexes($this->user_roles, 'user_id', 'role_id');
$this->revertIndexes($this->role_permissions, 'role_id', 'permission_id');
protected function optimizeIndexes(string $table, string $first_key, string $second_key)
$this->table($table, function (Blueprint $table) use ($first_key, $second_key) {
$table->dropPrimary([$first_key, $second_key]);
$table->index($first_key);
});
protected function revertIndexes(string $table, string $first_key, string $second_key)
$table->dropIndex($first_key);
$table->primary([$first_key, $second_key]);
andrey-helldar /
laravel-roles
