README-products-contracts

Apply new DB migrations for products, contracts and invoice items

From the project root, run (adjust container name if different):

# start DB if needed (from database folder)
cd database
docker compose up -d
 
# wait for postgres to be ready (optional)
docker exec -i rmm_postgres bash -c "until pg_isready -U rmm_user -d rmm_psa; do sleep 1; done; echo ready"
 
# apply products & contracts migration
docker exec -i rmm_postgres psql -U rmm_user -d rmm_psa < database/2025_10_add_products_contracts.sql
 
# apply invoice items migration
docker exec -i rmm_postgres psql -U rmm_user -d rmm_psa < database/2025_10_add_invoice_items.sql

Notes

• If your docker service name is different, use docker ps -a or docker compose ps to find the correct container name.
• If you need sudo to run docker commands, prefix commands with sudo (you'll be prompted for your system password).
• After applying migrations restart the backend server to pick up new DB schema.