@echo off
echo Adding inventory_reports table (no password - default XAMPP root)...
cd /d "C:\xampp\mysql\bin"
mysql -u root invcount_db ^< "c:/xampp/htdocs/invcount/database/add_inventory_reports.sql"
if %ERRORLEVEL% EQU 0 (
    echo SUCCESS: inventory_reports table ^& views created!
    echo Verify: mysql -u root invcount_db -e "DESCRIBE inventory_reports; SHOW TABLES LIKE 'variance%';"
) else (
    echo FAILED. Try manually: cd /d "C:\xampp\mysql\bin" && mysql -u root invcount_db ^< "c:/xampp/htdocs/invcount/database/add_inventory_reports.sql"
)
pause
