shankar
8630a3e2c5
Updated SQL script to correct procedure and column sizes. Moved SQL scripts to the project root folder (outside React frontend). Resolved backend container dependency issue to ensure MySQL is up before starting React backend. Moved common values to .env file in the project root. Updated React backend and MySQL ports to use default values. Added code to get last study received, containers status and updated into DB.
1. Go to router-dashboard directory 2. Run below command to build the docker images, create sql schema, insert data and start containers docker-compose up --build -d 3. When code changes done, then just run above command mentioned in point 2, it will udpate the changes and restart containers for which code changed 4. Open below URL in web browser to verify UI http://localhost:5173 5. Open mysql workbench/any tool to view schema details database:ve_router_db host: localhost port:3306 user/password: ve_router_user/ve_router_password 6. Run below command to stop and remove containers docker-compose down 7. Run below command to stop, remove and delete all the volumes Caution : if mysql has volumes then all the existing data will be erasesd docker-compose down -v