 
   WHERE sub_group_type != 'country'
 );
-
-
 
 CREATE SEQUENCE public.collectors_abcd_id_seq;
 

    c.people_type = 'collector'
    AND exists (select 1 from darwin2.people p where p.id = c.people_ref and is_physical = true)
);


CREATE SEQUENCE public.collectors_institution_abcd_id_seq;


ALTER TABLE darwin2.catalogue_levels SET SCHEMA public; 
ALTER TABLE darwin2.darwin_flat SET SCHEMA public; 
ALTER TABLE darwin2.mineralogy SET SCHEMA public; 
ALTER TABLE darwin2.template_classifications SET SCHEMA public;


ALTER TABLE public.darwin_flat 
  DROP COLUMN building,
