To set up authentication and user data, run the following SQL queries in your Supabase SQL editor. Execute them one after another:
Copy
create table profiles ( id uuid references auth.users on delete cascade not null primary key, updated_at timestamp with time zone, username text unique, full_name text, avatar_url text, website text, constraint username_length check (char_length(username) >= 3));create table todos ( id bigint generated by default as identity primary key, user_id uuid references auth.users not null, task text check (char_length(task) > 3), is_complete boolean default false, inserted_at timestamp with time zone default timezone('utc'::text, now()) not null);
In Site URL paste this url http://localhost:19006 and click “Save”.
Go to “Redirect URLs” section and click on “Add URL”.
Add this URL [app.json_scheme_variable]://**
To find out what value you need to use, head to your projects app.json file and look at "scheme": "..." value. For example it could be like this com.expoship://**.
Congrats - user authentication is now set up with Supabase and should be functional!