inconsistent metadata_type among products

[benjimin]

Should audit product definitions for consistency in metadata_type, and datasets for consistency with products.

Currently in prod db,

SELECT count(*), array_agg(distinct m.name) as dataset_metadata, pm.name as product_metadata, p.name as product
FROM agdc.dataset d 
JOIN agdc.metadata_type m on d.metadata_type_ref = m.id 
JOIN agdc.dataset_type p on p.id = d.dataset_type_ref 
JOIN agdc.metadata_type pm on pm.id = p.metadata_type_ref 
GROUP BY p.name, pm.name order by p.name;

 count  |  dataset_metadata  | product_metadata |           product            
--------+--------------------+------------------+------------------------------
 227432 | {landsat_scene}    | landsat_l1_scene | ls5_level1_scene
 128797 | {landsat_scene}    | landsat_scene    | ls5_nbar_scene
    328 | {landsat_l1_scene} | landsat_l1_scene | ls8_level1_oli_scene
  59353 | {landsat_l1_scene} | landsat_l1_scene | ls8_level1_scene
    108 | {eo}               | eo               | ls8_nbar_oli_scene
  47867 | {landsat_scene}    | landsat_scene    | ls8_nbar_scene

Requires updates to product definition yamls (multiple repos?) plus database fixes. e.g.

update agdc.dataset d set metadata_type_ref = p.metadata_type_ref from agdc.dataset_type p where p.id = d.dataset_type_ref ;