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 supabase/migrations folder and then running the generate and migrate scripts... 😬 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 id column in Supabase if I don't go about deleting the table?
image.png
Was this page helpful?