TRUNCATE address CASCADE;

TRUNCATE aggregateoccurrence CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE commclass CASCADE;

TRUNCATE commconcept CASCADE;

TRUNCATE commcorrelation CASCADE;

TRUNCATE commdetermination CASCADE;

TRUNCATE commlineage CASCADE;

TRUNCATE commname CASCADE;

TRUNCATE commstatus CASCADE;

TRUNCATE commusage CASCADE;

TRUNCATE coverindex CASCADE;

TRUNCATE covermethod CASCADE;

TRUNCATE definedvalue CASCADE;

TRUNCATE disturbanceobs CASCADE;

TRUNCATE graphic CASCADE;

TRUNCATE location CASCADE;

TRUNCATE locationdetermination CASCADE;

TRUNCATE locationevent CASCADE;

TRUNCATE locationeventcontributor CASCADE;

TRUNCATE locationeventsynonym CASCADE;

TRUNCATE method CASCADE;

TRUNCATE methodtaxonclass CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE namedplace_ancestor CASCADE;

TRUNCATE namedplacecorrelation CASCADE;

TRUNCATE note CASCADE;

TRUNCATE notelink CASCADE;

TRUNCATE party CASCADE;

TRUNCATE partymember CASCADE;

TRUNCATE plant CASCADE;

TRUNCATE plantconcept CASCADE;

TRUNCATE plantcorrelation CASCADE;

TRUNCATE plantlineage CASCADE;

TRUNCATE plantname CASCADE;

TRUNCATE plantname_ancestor CASCADE;

TRUNCATE plantnamescope CASCADE;

TRUNCATE plantobservation CASCADE;

TRUNCATE plantstatus CASCADE;

TRUNCATE plantusage 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 specimen CASCADE;

TRUNCATE specimenreplicate CASCADE;

TRUNCATE stemobservation CASCADE;

TRUNCATE stemtag CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE taxondetermination CASCADE;

TRUNCATE taxonoccurrence CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE trait CASCADE;

TRUNCATE userdefined CASCADE;

TRUNCATE voucher CASCADE;

all = vegbien.sql vegbien_empty.sql vegbien.my.sql functions.sql\

py_functions.sql

##### VegBIEN DB

empty = $(SED) -n \

's/^CREATE TABLE ([0-9A-Za-z_]+) \($$/TRUNCATE \1 CASCADE;/p' <$< >$@

%_empty.sql: %.sql

	$(empty)