#####

db: _not_file

	$(psqlAsBien) <mappings/schemas/vegbien.sql

# ignore errors if database exists

rm_db: _not_file

	echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin)

TRUNCATE address CASCADE;

TRUNCATE aux_role CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE commclass CASCADE;

TRUNCATE commconcept CASCADE;

TRUNCATE commcorrelation CASCADE;

TRUNCATE disturbanceobs CASCADE;

TRUNCATE embargo CASCADE;

TRUNCATE graphic CASCADE;

TRUNCATE keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE soilobs CASCADE;

TRUNCATE soiltaxon CASCADE;

TRUNCATE stemcount CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE stratummethod CASCADE;

TRUNCATE stratumtype CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE taxondetermination CASCADE;

TRUNCATE taxonoccurrence CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE userrecordowner CASCADE;

TRUNCATE userregionalexp CASCADE;

TRUNCATE usr CASCADE;

CREATE SEQUENCE address_address_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE aux_role_role_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE classcontributor_classcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

--

-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE SEQUENCE commclass_commclass_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commconcept_commconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commcorrelation_commcorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE comminterpretation_comminterpretation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commlineage_commlineage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commname_commname_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commstatus_commstatus_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE commusage_commusage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE coverindex_coverindex_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE covermethod_covermethod_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_cookie_cookie_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_datacache_dba_datacache_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_dbstatstime_stat_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_onerow_dba_onerow_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE definedvalue_definedvalue_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE embargo_embargo_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE graphic_graphic_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

--

-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE SEQUENCE namedplace_namedplace_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE note_note_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE notelink_notelink_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE observation_observation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE observationcontributor_observationcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE observationsynonym_observationsynonym_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE party_party_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE partymember_partymember_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE place_plotplace_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantconcept_plantconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantcorrelation_plantcorrelation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantlineage_plantlineage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantname_plantname_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantstatus_plantstatus_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plantusage_plantusage_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE plot_plot_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE project_project_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE projectcontributor_projectcontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE reference_reference_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE referencealtident_referencealtident_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE referencecontributor_referencecontributor_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE referencejournal_referencejournal_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE referenceparty_referenceparty_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE revision_revision_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE soilobs_soilobs_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE soiltaxon_soiltaxon_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE stemcount_stemcount_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

--

-- Name: stemlocation_stemlocation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE stemlocation_stemlocation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE stratum_stratum_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE stratummethod_stratummethod_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE stratumtype_stratumtype_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE taxonalt_taxonalt_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

--

--

    stratum_id integer,

);

--

-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: taxoninterpretation_taxoninterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

CREATE SEQUENCE taxoninterpretation_taxoninterpretation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE taxonobservation_taxonobservation_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE telephone_telephone_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE temptbl_std_commnames_commconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE temptbl_std_plantnames_plantconcept_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE usercertification_usercertification_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userdataset_userdataset_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userdatasetitem_userdatasetitem_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userdefined_userdefined_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE usernotify_usernotify_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userpermission_userpermission_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userpreference_userpreference_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userquery_userquery_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userrecordowner_userrecordowner_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE userregionalexp_userregionalexp_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

CREATE SEQUENCE usr_usr_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MAXVALUE

    CACHE 1;

--

-- Name: commclass_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: namedplace_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: observationcontributor_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: project_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: stratum_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: -

--

-- PostgreSQL database dump complete

--

	$(bin)/cat_csv <$+ >$@

.PRECIOUS: VegBank-VegBIEN.%.csv

schemas/vegbien_empty.sql: schemas/vegbien.sql

	$(empty)