SET FOREIGN_KEY_CHECKS = 0;

truncate table airPumpGroups;
truncate table airPumpGroupTanks;
truncate table airPumps;
truncate table filters;
truncate table foodTypes;
truncate table heaters;
truncate table lights;
truncate table lightTankSizes;
truncate table manufacturers;
truncate table photoGalleries;
truncate table photoGalleryGroups;
truncate table photoGalleryPhotos;
truncate table plants;
truncate table species;
truncate table speciesAlternateNames;
truncate table speciesFeeding;
truncate table speciesSources;
truncate table speciesCategories;
truncate table speciesSubCategories;
truncate table speciesPatterns;
truncate table tankFilters;
truncate table tankGroups;
truncate table tankGroupStorage;
truncate table tankLights;
truncate table tankPlants;
truncate table tanks;
truncate table tankSizes;
truncate table tankStocking;
truncate table thermometers;
truncate table users;

SET FOREIGN_KEY_CHECKS = 1;
