{
    "status": "success",
    "message": "Login diagnostics complete",
    "database": "emaj4846_warungkite123@e-masjid-digital.cloud\/emaj4846_warungkite",
    "diagnostics": {
        "superadmin_tables": {
            "superadmin": "✅ EXISTS",
            "superadmins": "✅ EXISTS"
        },
        "superadmin_accounts": [
            {
                "id": "1",
                "username": "root_admin",
                "is_active": true,
                "password_format": "✅ BCRYPT HASH",
                "password_preview": "$2y$10$uxx\/yaq2..."
            }
        ],
        "users_table": {
            "total_rows": 14,
            "samples": [
                {
                    "id": "1",
                    "nama_lengkap": "User Demo Pertama",
                    "no_hp": "089988877701",
                    "pw_preview": "$2y$10$Z\/VzOvp4",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "2",
                    "nama_lengkap": "Ani Rahayu",
                    "no_hp": "089911110001",
                    "pw_preview": "$2y$10$MihtlZRu",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "3",
                    "nama_lengkap": "Budi Pratama",
                    "no_hp": "089911110002",
                    "pw_preview": "$2y$10$MihtlZRu",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "4",
                    "nama_lengkap": "Citra Dewi",
                    "no_hp": "089911110003",
                    "pw_preview": "$2y$10$MihtlZRu",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "5",
                    "nama_lengkap": "Doni Saputra",
                    "no_hp": "089911110004",
                    "pw_preview": "$2y$10$MihtlZRu",
                    "password_format": "✅ BCRYPT"
                }
            ]
        },
        "akun_warung_table": {
            "total_rows": 6,
            "samples": [
                {
                    "id": "1",
                    "nama_lengkap": "Siti Aminah",
                    "no_hp": "081234567890",
                    "pw_preview": "$2y$10$h5J.4iH6",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "2",
                    "nama_lengkap": "Budi Santoso",
                    "no_hp": "081234567891",
                    "pw_preview": "$2y$10$Z\/VzOvp4",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "3",
                    "nama_lengkap": "Dewi Lestari",
                    "no_hp": "081234567892",
                    "pw_preview": "$2y$10$Z\/VzOvp4",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "4",
                    "nama_lengkap": "Pak Joko Warung",
                    "no_hp": "081200001111",
                    "pw_preview": "$2y$10$h5J.4iH6",
                    "password_format": "✅ BCRYPT"
                },
                {
                    "id": "5",
                    "nama_lengkap": "Owner Warung Lentera",
                    "no_hp": "08123456789",
                    "pw_preview": "$2y$10$fdYA3PZ1",
                    "password_format": "✅ BCRYPT"
                }
            ]
        },
        "login_attempts_schema": [
            {
                "field": "id",
                "type": "int(11)",
                "null": "NO",
                "default": null
            },
            {
                "field": "ip_address",
                "type": "varchar(45)",
                "null": "NO",
                "default": null
            },
            {
                "field": "phone",
                "type": "varchar(20)",
                "null": "NO",
                "default": "unknown"
            },
            {
                "field": "attempted_at",
                "type": "timestamp",
                "null": "NO",
                "default": "current_timestamp()"
            }
        ],
        "login_attempts_count": 0,
        "backend_env_exists": "✅ YES",
        "all_tables": [
            "akun_warung",
            "broadcasts",
            "cart_items",
            "chat_messages",
            "chat_rooms",
            "images",
            "jwt_blacklist",
            "kategori",
            "login_attempts",
            "notifications",
            "order_disputes",
            "order_items",
            "orders",
            "owner_notifications",
            "payment_logs",
            "product_reviews",
            "product_variants",
            "products",
            "reviews",
            "security_threat_logs",
            "superadmin",
            "superadmins",
            "support_tickets",
            "system_audit_log",
            "system_banners",
            "system_settings",
            "ticket_messages",
            "user_addresses",
            "user_favorites",
            "users",
            "voucher_batches",
            "vouchers",
            "warung",
            "warung_promotions",
            "warung_verifications"
        ]
    },
    "fixes_applied": "No fixes needed"
}