09-24-2017, 02:53 PM
New SQL dump required.
This primarily focuses with updates.
What I've done is created a file called users/includes/migrations.php
Every time we do a db update, it will go inside that file. There is also a table called updates that lists which and when db updates were performed.
users/update.php will contain EVERY db update from 4.3.0 on
The great thing about this is that a user can use something like git (or even download an entirely fresh copy of userspice) and dump it on top of their existing one and all of the database changes will happen in order to get them right back up to speed.
In the event that someone downloads an update and doesn't run the database update, they will be notified in the admin dashboard.
I've also made the nags for recaptcha and default password only for live sites.
I think that's about it.
This primarily focuses with updates.
What I've done is created a file called users/includes/migrations.php
Every time we do a db update, it will go inside that file. There is also a table called updates that lists which and when db updates were performed.
users/update.php will contain EVERY db update from 4.3.0 on
The great thing about this is that a user can use something like git (or even download an entirely fresh copy of userspice) and dump it on top of their existing one and all of the database changes will happen in order to get them right back up to speed.
In the event that someone downloads an update and doesn't run the database update, they will be notified in the admin dashboard.
I've also made the nags for recaptcha and default password only for live sites.
I think that's about it.