Advisory UUID

[carlosthe19916]

I couldn't test this PR as when I tried to upload an advisory I got the error:

Query Error: error returned from database: insert or update on table "cvss3" violates foreign key constraint "cvss3_vulnerability_id_fkey"

I will check it again tomorrow morning

[bobmcwhirter]

Tests seem to be failing so I'll look harder in the AM.

[bobmcwhirter]

@carlosthe19916 which advisory didja ingest to result in that message?

[bobmcwhirter]

I uploaded some CSAF, OSV and CVE

[carlosthe19916]

@carlosthe19916 which advisory didja ingest to result in that message?

I don't remember which one I Uploaded but this one should also generate the same error

RHBA-2024_1440.json

[carlosthe19916]

@carlosthe19916 which advisory didja ingest to result in that message?

I don't remember which one I Uploaded but this one should also generate the same error

RHBA-2024_1440.json

@bobmcwhirter my bad, the file I attached failed to be uploaded with the main branch but it worked perfectly fine with your branch/PR

[bobmcwhirter]

Works for me!

[bobmcwhirter]

I need to rebase and sort out my down migration, and then we'll merge it on in.