 SET client_min_messages = warning;
 
 --
--- Name: binary_upgrade; Type: SCHEMA; Schema: -; Owner: -
---
-
-CREATE SCHEMA binary_upgrade;
-
-
---
 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
 --
 



SET search_path = public, pg_catalog;

--
-- Name: event_properties; Type: TYPE; Schema: public; Owner: -
--

CREATE TYPE event_properties AS (
	id integer,
	full_name json,
	taxonomy_name text,
	rank_name json,
	family_name json
);


--
-- Name: higher_taxa; Type: TYPE; Schema: public; Owner: -

    cites_ii boolean,
    cites_iii boolean,
    cites_listed boolean,
    cites_show boolean,
    cites_status_original boolean,
    cites_status text,
    cites_listing_original text,
    cites_listing text,
    cites_closest_listed_ancestor_id integer,
    cites_listing_updated_at timestamp without time zone,
    ann_symbol text,
    hash_ann_symbol text,
    hash_ann_parent_symbol text,
    eu_listed boolean,
    eu_show boolean,
    eu_status_original boolean,
    eu_status text,
    eu_listing_original text,
    eu_listing text,
    eu_closest_listed_ancestor_id integer,
    eu_listing_updated_at timestamp without time zone,
    species_listings_ids integer[],
    species_listings_ids_aggregated integer[],
    author_year character varying(255),
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    taxon_concept_id_com integer,
    english_names_ary character varying[],
    spanish_names_ary character varying[],
