setup_database.bat

@echo off
echo ============================================
echo Textbook Selling System - Database Setup
echo ============================================
echo.
echo This script will help you set up the MySQL database.
echo.
echo Prerequisites:
echo - MySQL Server must be installed and running
echo - You need to know your MySQL root password
echo.
pause

echo.
echo Setting up the database...
echo.

REM Get the current directory
set SCRIPT_DIR=%~dp0

REM Run MySQL command to create database and import schema
echo Please enter your MySQL root password when prompted.
echo.

mysql -u root -p < "%SCRIPT_DIR%database_setup.sql"

if %ERRORLEVEL% EQU 0 (
    echo.
    echo ============================================
    echo Database setup completed successfully!
    echo ============================================
    echo.
    echo Database Name: book_selling_system
    echo.
    echo Default Admin Credentials:
    echo   Username: Soumya
    echo   Password: 1234
    echo.
    echo Sample User Accounts:
    echo   1. Username: johndoe, Password: password123
    echo   2. Username: janesmith, Password: password456
    echo.
    echo You can now run the application!
    echo.
) else (
    echo.
    echo ============================================
    echo Error: Database setup failed!
    echo ============================================
    echo.
    echo Please check:
    echo 1. MySQL Server is running
    echo 2. You entered the correct password
    echo 3. You have permission to create databases
    echo.
    echo For manual setup, see DATABASE_SETUP_README.md
    echo.
)

pause