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 each developer works on their own local SQL Server, then each developer’s work will be committed to a different root folder (user1_pc_name, user2_pc_name, etc).
If everybody works against the same SQL Server, then whenever anyone commits it will be written to the same root folder, overwriting the file if it already exists. In essence, the repo will mirror the database.