The root computer_name folder is the name of the computer hosting the SQL Server, so it depends on whether your database development model is shared (one SQL Server) or dedicated (everybody has their own local SQL Server).
If everybody connects to the same SQL Server, then whatever changes each person makes will be written to the same root folder, overwriting the file if it already exists. The repo will mirror the database.