SAFE RESOURCES LTD - SECURITY MANAGEMENT SYSTEM V4

For an EXISTING installation (recommended because you already have your 33 posts):
1. Back up the security_management database in phpMyAdmin.
2. Import database/update_v4.sql into the existing security_management database.
3. Copy/replace the application files with this V4 package.
4. Open:
   http://localhost/security_management_system/public/

Do NOT import database/security_management.sql into your existing database.

NEW WORKFLOW:
1. Clients -> register each client/company.
2. Posts -> create/link each post to the client who hired it and set:
   Total Required, Day Guards, Night Guards.
3. Guards -> ensure all guards and relievers are registered.
4. Deployments -> assign each guard to a contracted post and shift with effective dates.
5. Roster -> generate the weekly roster. The generator now reads active deployments.
6. Review coverage and correct any guard without a valid deployment.

IMPORTANT:
The client does not need a separate "number of posts" field. The system calculates
Posts Hired from the number of security posts linked to that client. This avoids
mismatches: every post belongs to one client, and every post has its own staffing
requirement.

Replacement/Reliever:
A deployment can record a reliever/replacement guard and the assignment remains in
history. Ending the assignment records its end date.

Database migration:
database/update_v4.sql
