#!/bin/sh
cd /www/wwwroot/faithfulness
sudo -u www /usr/bin/php artisan tinker --execute="
echo 'branches lat col: '.(Schema::hasColumn('branches','lat')?'OK':'MISSING').PHP_EOL;
echo 'migrations count: '.DB::table('migrations')->count().PHP_EOL;
echo 'last migration: '.DB::table('migrations')->orderByDesc('id')->value('migration').PHP_EOL;
echo 'migration file ran?: '.(DB::table('migrations')->where('migration','2026_08_26_160000_add_geo_and_location_route_caches')->exists()?'YES':'NO').PHP_EOL;
" 2>&1 | grep -E "branches|migrations|last|migration file"