SupabaseS
Supabase•2y ago
Hoobie

Auth table columns missing from schema load

I've encountered an issue while trying to pull the remote database and data to use for seeds. It appeared that some needed columns in the auth schema were not created.

After pulling the remote database (supabase db pull) and then dumping the DB records into a SQL file (supabase db dump --data-only -f ./supabase/seed.sql), I encountered an error while trying to reset and seed the database. This error showed that some columns in two auth tables were missing. The auth.sessions table was missing the tag (text) column, and the auth.identities table was missing the provider_id (text) column.

I was able to remedy this by adding these two columns in my first migration. This migration file I used was from running supabase db pull.
ALTER TABLE auth.sessions
ADD "tag" "text";

ALTER TABLE auth.identities
ADD "provider_id" "text";


After running, supabase db reset these columns are added, and the dumped seed file worked. Is this intended or should these columns be added to the auth schema somewhere?
Was this page helpful?