#!/bin/bash
# ordering is essential due to foreign key constraints
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/__reset.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/users.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/foodTypes.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/manufacturers.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/photoGalleryGroups.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/plants.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/speciesCategories.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/speciesSubCategories.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/tankGroups.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/airPumps.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/airPumpGroups.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/tankGroupStorage.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/thermometers.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/lights.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/tankSizes.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/lightTankSizes.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/filters.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/heaters.sql

mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/species/_all.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/tanks/_all.sql
mysql --login-path=local --database=fish < /var/www/html/fish.jba3.com/database/content/photo-galleries/_all.sql