@echo off
REM Create settings table for system settings
echo Creating settings table...
echo.

cd /d "c:\xampp\htdocs\invcount"

"c:\xampp\mysql\bin\mysql.exe" -h127.0.0.1 --port=3306 -u root invcount_db < create_settings_table.sql

if %ERRORLEVEL% EQU 0 (
    echo.
    echo [SUCCESS] Settings table created!
    echo You can now access Admin ^> Settings
) else (
    echo [ERROR] Failed to create settings table. Check XAMPP/MySQL service.
)

echo.
pause
