resync database migrations

[sphericle]

alright so the ../migrations are dumb and stupid and broken rn because i didn't know how databases worked and added things at will without using migrations lmao! so we need to figure out how to reset these migrations and have them be able to run from cli and through deployments with no problem. but we can't actually re run them, because if we try to make a new table, for example, the table will already exist and it will fail. obviously we can't remove the table because yeah.

[sphericle]

maybe we could replace all that with one single CREATE script from pgadmin (not sure what that does and also it might still be broken....) which would in theory build the database schema the way we want it to. and when we run a command to create the db we can use IF NOT EXISTS, which will skip creating the database if we already have one, but won't fail either.

[sphericle]

this is probably what i'm looking for

[sphericle]

uh nvm

[sphericle]

pray

[sphericle]

https://github.com/stadust/pointercrate-migration/blob/master/2023-01-07-160559_sqlx/up.sql

[sphericle]

alr here's how this should go:

• [ ] run migrations normally
• [ ] pg backup the sqlx migrations table
• [ ] drop table and re run commented migrations (to mimic how the db is now)
• [ ] insert all data from the backed up migrations table into the new table
• [ ] replace migration files with the old working ones
• [x] pray
• [ ] wahoo!

[sphericle]

wtf .......