[9.1] Add DiracX support into the database.

[Robin-Van-de-Merghel]

• [ ] Needs https://github.com/DIRACGrid/diracx/pull/421
• [ ] Federico add to update notes

BEGINRELEASENOTES

*WMS FIX: Add future DiracX Pilots DB (support for secrets)

ENDRELEASENOTES

[Robin-Van-de-Merghel]

Adapted from https://github.com/DIRACGrid/diracx/blob/f17e4db81670aac0def7ceb283e6a85fc64fdd67/diracx-db/src/diracx/db/sql/pilot_agents/schema.py#L69-L90

[Robin-Van-de-Merghel]

Is this PR useful? It only adds a key for pilot stamps

I mean, as we move the secret table into DiracX auth, normally the database is automatically created without the need to implement it in DIRAC?

POC: https://github.com/DIRACGrid/DIRAC/actions/runs/16797372818/job/47570725488?pr=8279 working without adding the DB in DIRAC.

[fstagni]

I also doubt it is needed.

[Robin-Van-de-Merghel]

Maybe just keep the Key for performance improvment ?