We changed the Site Name from "BITLab-LCG" to "UKI-LT2-Brunel".

Thus had to update the APEL DBs here with new sitenames before re-publishing into R-GMA.
This has to be done separately for each CE.

First pass:

use accounts_database_for_GreenStripe;
UPDATE LcgRecords SET ExecutingSite='BITLabGS.UKI-LT2-Brunel' WHERE ExecutingSite='BITLabGS.BITLab-LCG';
UPDATE EventRecords SET ExecutingSite='BITLabGS.UKI-LT2-Brunel' WHERE ExecutingSite='BITLabGS.BITLab-LCG';

use accounts_database_for_Argo;
UPDATE LcgRecords SET ExecutingSite='BITLabArgo.UKI-LT2-Brunel' WHERE ExecutingSite='BITLabArgo.BITLab-LCG';
-- Cock-up:UPDATE EventRecords SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE ExecutingSite='BITLabArgo.BITLab-LCG';
UPDATE EventRecords SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE SiteName='BITLabArgo.BITLab-LCG';
UPDATE GkRecords SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE SiteName='BITLabArgo.BITLab-LCG';
UPDATE LcgProcessedFiles SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE SiteName='BITLabArgo.BITLab-LCG';
UPDATE MessageRecords SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE SiteName='BITLabArgo.BITLab-LCG';
UPDATE SpecRecords SET SiteName='BITLabArgo.UKI-LT2-Brunel' WHERE SiteName='BITLabArgo.BITLab-LCG';


This changes everything for Argo and works fine.
Publishing for GreenStripe throws an error in the MON log, even though it seems to work 
- data visible outside. Prior to submitting GGUS ticket 10816 clean up final glitches 
(note still some entries with original simple site name):

use accounts_database_for_GreenStripe;
UPDATE LcgRecords SET ExecutingSite='BITLabGS.UKI-LT2-Brunel' WHERE ExecutingSite='BITLab-LCG';
UPDATE LcgRecords SET ExecutingSite='BITLabGS.UKI-LT2-Brunel' WHERE ExecutingSite='BITLab-LCG';
UPDATE EventRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLab-LCG';
UPDATE EventRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLabGS.BITLab-LCG';
UPDATE GkRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLab-LCG';
UPDATE GkRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLabGS.BITLab-LCG';
UPDATE MessageRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLab-LCG';
UPDATE MessageRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLabGS.BITLab-LCG';
UPDATE SpecRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLabGS.BITLab-LCG';
UPDATE SpecRecords SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLab-LCG';


Don't do / leave:

UPDATE LcgProcessedFiles SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLabGS.BITLab-LCG';
(Fails as each file in twice since processor has been re-run)

UPDATE LcgProcessedFiles SET SiteName='BITLabGS.UKI-LT2-Brunel' WHERE SiteName='BITLab-LCG';
(No records so not needed)