dwyl / mvp

📲 simplest version of the @dwyl app
https://mvp.fly.dev
GNU General Public License v2.0
87 stars 2 forks source link

Remove `people` table from database on Fly.io #285

Closed SimonLab closed 1 year ago

SimonLab commented 1 year ago

281 has been fixed by removing the foreign key items_people_id.

However the people table still exists on the database.

SimonLab commented 1 year ago

The tags table still has a foreign key index to the people table: image

Running: alter table tags drop constraint tags_person_id_fkey; to remove the index. We should now be able to drop the people table with drop table people;

Listing the tables: image

@nelsonic @LuchoTurtle let me know if you have any issues with the mvp but I think now the database reflect the migrations files we have on the project.

nelsonic commented 1 year ago

@SimonLab go for it. thanks. 👍

SimonLab commented 1 year ago

No errors reported closing for now