TRUNCATE address CASCADE;

TRUNCATE aux_role CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE commclass CASCADE;

TRUNCATE commconcept CASCADE;

TRUNCATE commcorrelation CASCADE;

TRUNCATE comminterpretation CASCADE;

TRUNCATE commlineage CASCADE;

TRUNCATE commname CASCADE;

TRUNCATE commstatus CASCADE;

TRUNCATE commusage CASCADE;

TRUNCATE coverindex CASCADE;

TRUNCATE covermethod CASCADE;

TRUNCATE dba_confidentialitystatus CASCADE;

TRUNCATE dba_cookie CASCADE;

TRUNCATE dba_cookielabels CASCADE;

TRUNCATE dba_datacache CASCADE;

TRUNCATE dba_datamodelversion CASCADE;

TRUNCATE dba_dbstatstime CASCADE;

TRUNCATE dba_fielddescription CASCADE;

TRUNCATE dba_fieldlist CASCADE;

TRUNCATE dba_onerow CASCADE;

TRUNCATE dba_preassignacccode CASCADE;

TRUNCATE dba_tabledescription CASCADE;

TRUNCATE dba_xmlcache CASCADE;

TRUNCATE definedvalue CASCADE;

TRUNCATE disturbanceobs CASCADE;

TRUNCATE embargo CASCADE;

TRUNCATE graphic CASCADE;

TRUNCATE keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE namedplacecorrelation CASCADE;

TRUNCATE note CASCADE;

TRUNCATE notelink CASCADE;

TRUNCATE plotevent CASCADE;

TRUNCATE observationcontributor CASCADE;

TRUNCATE observationsynonym CASCADE;

TRUNCATE party CASCADE;

TRUNCATE partymember CASCADE;

TRUNCATE place CASCADE;

TRUNCATE plantconcept CASCADE;

TRUNCATE plantcorrelation CASCADE;

TRUNCATE plantlineage CASCADE;

TRUNCATE plantname CASCADE;

TRUNCATE plantstatus CASCADE;

TRUNCATE plantusage CASCADE;

TRUNCATE plot CASCADE;

TRUNCATE project CASCADE;

TRUNCATE projectcontributor CASCADE;

TRUNCATE reference CASCADE;

TRUNCATE referencealtident CASCADE;

TRUNCATE referencecontributor CASCADE;

TRUNCATE referencejournal CASCADE;

TRUNCATE referenceparty CASCADE;

TRUNCATE revision CASCADE;

TRUNCATE soilobs CASCADE;

TRUNCATE soiltaxon CASCADE;

TRUNCATE stemcount CASCADE;

TRUNCATE individual CASCADE;

TRUNCATE taxonbin CASCADE;

TRUNCATE stratummethod CASCADE;

TRUNCATE stratumtype CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE collectiveobs CASCADE;

TRUNCATE taxondetermination CASCADE;

TRUNCATE taxonoccurrence CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE temptbl_std_commnames CASCADE;

TRUNCATE temptbl_std_plantnames CASCADE;

TRUNCATE usercertification CASCADE;

TRUNCATE userdataset CASCADE;

TRUNCATE userdatasetitem CASCADE;

TRUNCATE userdefined CASCADE;

TRUNCATE usernotify CASCADE;

TRUNCATE userpermission CASCADE;

TRUNCATE userpreference CASCADE;

TRUNCATE userquery CASCADE;

TRUNCATE userrecordowner CASCADE;

TRUNCATE userregionalexp CASCADE;

TRUNCATE usr CASCADE;

misc = schemas/vegbien.sql schemas/vegbien_empty.sql VegX-VegBIEN.organisms.csv

all: FORCE $(misc)

.PRECIOUS: $(misc)

.SUFFIXES:

.PHONY: FORCE

VegX-*.plots.csv $(misc)

repl = ../scripts/util/repl

empty = sed -nE 's/^CREATE TABLE ([0-9A-Za-z_]+) \($$/TRUNCATE \1 CASCADE;/p' \

<$< >$@

schemas/vegbien_empty.sql: schemas/vegbien.sql

	$(empty)

plots: FORCE $(subst .organisms.,.plots.,$(wildcard VegX-*.organisms.csv))