How to update Confluence Application Links via database?

[John Yeuk Hon Wong]

Hi I have not found any tutorial that shows me how to update the app link in Confluence via database.

https://confluence.atlassian.com/display/JIRAKB/How+to+update+the+url+for+Application+link only shows the version with JIRA which I am able to do so.

UPDATE propertystring SET propertyvalue='https://confluence-staging.example.com' WHERE id in (SELECT PS.id FROM propertystring AS PS INNER JOIN propertyentry AS PE ON PS.id = PE.id WHERE PE.property_key LIKE '%app%' AND PS.propertyvalue LIKE '%confluence.%');

How do I do that with Confluence? I see trustedapp table but I have just one row!

confluence=# select * from trustedapp;
 trustedappid |     name     | timeout | public_key_id
--------------+--------------+---------+---------------
     44597254 | jira:9972319 |   10000 |      44630022
(1 row)

Is that normal!? Thanks

[John Yeuk Hon Wong · Accepted solution]

Okay I finally found it.

UPDATE bandana SET bandanavalue='<string>https://jira-staging.example.com</string>' WHERE bandanaid in (SELECT bandanaid FROM bandana  WHERE bandanakey LIKE '%applink%' AND bandanavalue LIKE '%jira.example.com%')