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
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
id
column in Supabase if I don't go about deleting the table?