Increase finding.uid max lenght > 300 characters

[jfagoagas]

Steps to Reproduce

As discussed in this Prowler Community Slack 🧵 https://prowler-workspace.slack.com/archives/C045DAM2NE9/p1740529388847369

Tried to fix it in #7048 and #7498 but got issues with migrations since it requires to adquire an exclusive lock for the findings table. We need to try a different approach.

Expected behavior

We need to change the finding.uid field type from varchar to text and remove the 300 chars limit or increase the varchar size to more than 300 chars.

Actual Result with Screenshots or Logs

N/A

How did you install Prowler?

Cloning the repository from github.com (git clone)

Environment Resource

N/A

OS used

N/A

Prowler version

5.0

Pip version

N/A

Context

No response