解决Laravel外键约束失败：高效重置数据库的Artisan命令

php artisan make:command DeleteAllTables

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\Artisan; // 引入Artisan Facade

class DeleteAllTables extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'db:reset-all'; // 定义命令名称

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Deletes all tables in the database in a specific order and then re-runs migrations.';

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $this->info('Starting database reset...');

        // 禁用外键检查以确保删除顺利进行（可选，但推荐）
        // Schema::disableForeignKeyConstraints(); // 注意：此方法在某些数据库驱动中可能无效或不推荐

        // 按照从子表到父表的顺序删除表
        // 请根据您的实际数据库结构调整此列表和顺序
        $tablesToDrop = [
            'bloggers',
            'ticket_labels',
            'labels',
            'tickets',
            'service_admins',
            'services',
            'admins',
            'admin_roles',
            'priorities',
            'statuses',
            'users',
            'failed_jobs',
            'migrations', // 通常最后删除，因为它记录了迁移历史
            'password_resets',
            'personal_access_tokens',
        ];

        foreach ($tablesToDrop as $table) {
            if (Schema::hasTable($table)) {
                Schema::dropIfExists($table);
                $this->comment("Dropped table: {$table}");
            } else {
                $this->comment("Table '{$table}' does not exist, skipping.");
            }
        }

        // 重新启用外键检查（如果之前禁用了）
        // Schema::enableForeignKeyConstraints();

        $this->info('All specified tables have been dropped.');
        $this->info('Running migrations...');

        // 执行 migrate 命令，重建数据库结构
        // 推荐使用Artisan::call()代替exec()，因为它更Laravel原生且错误处理更优雅
        Artisan::call('migrate');
        $this->comment(Artisan::output()); // 输出migrate命令的执行结果

        $this->info('Database reset and migrations completed successfully!');

        return Command::SUCCESS;
    }
}

// app/Console/Kernel.php

protected $commands = [
    // ... 其他命令
    \App\Console\Commands\DeleteAllTables::class,
];

php artisan db:reset-all