# create all the tables
create table vernacularName like syn_delta.vernacularName;
create table higherTaxon 		like syn_delta.higherTaxon;
create table taxon 					like syn_delta.taxon;
create table imageRecord 		like syn_delta.imageRecord;
create table resource 			like syn_delta.resource;
create table collection 		like syn_delta.collection;
create table isoCountry 		like syn_delta.isoCountry;
create table bioRecord 			like syn_delta.bioRecord;

# disable keys (only done when a new cache is created from the scratch!!)
alter table vernacularName    disable keys;
alter table taxon 			      disable keys;
alter table higherTaxon		    disable keys;
alter table collection		    disable keys;
alter table bioRecord		      disable keys;