-- downgrade the NHM mollusc lists which have now been superceded

UPDATE Taxon_list SET Taxon_list.ITEM_NAME = 'Natural History Museum Checklist of Non-Marine Gastropoda', Taxon_list.PREFERRED = 0
WHERE (((Taxon_list.TAXON_LIST_KEY)='NHMSYS0000315917'));

UPDATE Taxon_list SET Taxon_list.ITEM_NAME = 'Natural History Museum Checklist of Freshwater Bivalves', Taxon_list.PREFERRED = 0
WHERE (((Taxon_list.TAXON_LIST_KEY)='NHMSYS0000317227'));

-- update the title of the BOU list
UPDATE Taxon_list SET Taxon_list.ITEM_NAME = ' BIRDS British Ornithologists'' Union British List (Categories A, B, C)'
WHERE (((Taxon_list.TAXON_LIST_KEY)='NHMSYS0000528629'));

-- down grade the old COLLEMBOLA list

UPDATE Taxon_list SET Taxon_list.ITEM_NAME = 'Preliminary Checklist of British and Irish Collembola', Taxon_list.PREFERRED = 0
WHERE (((Taxon_list.TAXON_LIST_KEY)='NBNSYS0100000001'));

-- upgrade the TRICHOPTERA list

UPDATE Taxon_list SET Taxon_list.ITEM_NAME = ' TRICHOPTERA A review of the Trichoptera of Great Britain', Taxon_list.PREFERRED = -1
WHERE (((Taxon_list.TAXON_LIST_KEY)='NBNSYS0000000088'));