DB Changes
The SQLs which are required to execute on the server during system deployement are stored in the folder named __DB_CHANGES\
.
- The raw SQL contains the create and insert queries which are necessary for first set-up (
__DB_CHANGES\[20241111_1440]milaravel10app_db-RAW.sql
) - SQLs for creating/altering tables are being added as per requirement.
- The naming of SQL file should be like this
currentdate_currenttime-tablename_yourname.sql
. For Ex:20241115_1059-[INSERT][TABLE]model_has_roles.sql
.