upd-compositae.sql

-- point compositae children to asteraceae
UPDATE name_usage set parent_fk=3065 where dataset_key=nubKey() and parent_fk=6070956;
-- point compositae descendants to asteraceae
UPDATE name_usage set family_fk=3065 where dataset_key=nubKey() and family_fk=6070956;
-- update asteraceae usage
UPDATE name_usage set num_descendants=num_descendants+1936 where id=3065;
UPDATE name_usage_metrics set count_children=count_children+573, count_g=count_g+573, count_s=count_s+1351 where id=3065;
-- update compositae usage
UPDATE name_usage set parent_fk=3065, is_synonym=true, status='SYNONYM', family_fk=3065, num_descendants=0 where id=6070956;
UPDATE name_usage_metrics set count_children=0, count_synonyms=0, count_p=0, count_c=0, count_o=0, count_f=0, count_g=0, count_sg=0, count_s=0 where id=6070956;