Database migration tool

Nos78 / MrData

Discord Bot providing some simple scoring using postgres

GNU General Public License v3.0

3 stars 1 forks source link

Database migration tool #3

Open spicyclam opened 5 years ago

spicyclam commented 5 years ago

I noticed an upgrade subfolder in the sql folder? Is there a database migration tool in use? If yes, which?

Nos78 commented 5 years ago

No, I simply had an upgrade.sql script which I would run in pgAdmin on the live database (after backing it up). This made the column modifications to the old scores table. Then the new tables are created, the user discord id's added into users, guild discord id's added into guilds, and the data copied from old_scores into the new scores table.