We want to prevent that space administrators permanently change the color scheme of their space.
Is it enough in the bandana table to set the values for the fields to the global value, eg
UPDATE bandana set bandanavalue = (select bandanavalue from bandana where bandanakey = 'atlassian.confluence.colour.scheme' and bandanacontext like '%GLOBAL%') WHERE bandanakey = 'atlassian.confluence.colour.scheme' and bandanacontext <> '%GLOBAL% ';
Thanks