How to add a new column to an existing table
Right now I have just been testing locally with Drizzle, Supabase, and Next.js... I created a schema for a table called "ballots" (see image). However, I realized that I am missing a column
which is the one that is commented out in the image. Now what I have been doing is deleting the tables in Supabase along with the
I feel like that is a bad thing (maybe not?)... Since I am just testing and none of this has gone to production, is that ok? Also, any idea on how to "reset" the
supabase/migrations folder and then running the generate and migrate scripts... id column in Supabase if I don't go about deleting the table?