Cryptyc / SC2LadderWebHost

8 stars 8 forks source link

Database versioning #20

Closed lladdy closed 3 years ago

lladdy commented 5 years ago

Don't deploy this to production until you've run the SQL at the bottom!

Feedback is appreciated. This PR is meant to allow for versioning of database changes so that semi-independent distributed development can take place.

What this PR changes:


Before deploying to production, the database version needs to be set:

CREATE TABLE `schema_variables`
(
  `schema_version`   VARCHAR(255) not null
);
INSERT INTO `schema_variables` (`schema_version`) values ('1.0');