While working with a team using Git I can manage the files, Following image shows the working architecture which I created, Of course, I have to give thanks to my Previous company CTO: TOM,
With this architecture files, Testing and group work can be done without any problem, but the problem I faced in Database, Most of the times database newly created tables which created in between project may be missed or not moving properly to the live and stage servers in group work, As usual, I started to search of version control of database, there I found DVB Database version control
Installation Steps is very easy: you can download it from https://dbv.vizuina.com/
I have Downloaded and store
/var/www/htm/projectfolder/dbv
So I can access like
http://27.0.0.1//dbv
Make sure you added gitignore properly
Enter your database access information in the config.php
How to use
Following is a guide on how to use dbv.php during all four of the usage scenarios:
Scenario 1: You’ve created a new schema object (table, views, stored procedure, etc) and want to share it with your team.
Scenario 2: Someone in your team has created a new schema object, and you want to update your database to include the new object.
Scenario 3: You have made a generic change on the database (altered a table, dropped some records, pretty much anything) and want to share the changes with your team.
Scenario 4: Someone in your team has made a change to the database, and you want to apply the same change to the database on your machine.
They have good Documentation it explains how to push and alter or drop https://dbv.vizuina.com/documentation/#usage-schema-create
The One which I installed
