Region: Choose closest to your users (e.g., South America - São Paulo)
Click Create new project (takes ~2 minutes)
2
Run Database Migration
Go to SQL Editor in Supabase and run this schema:
supabase-setup.sql
-- Create user profiles tableCREATE TABLE IF NOT EXISTS user_profiles ( id UUID REFERENCES auth.users(id) PRIMARY KEY, email TEXT, full_name TEXT, avatar_url TEXT, provider TEXT, onboarding_completed BOOLEAN DEFAULT false, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW());-- Create user preferences table (tourism onboarding)CREATE TABLE IF NOT EXISTS user_preferences ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE, experiencia TEXT[], duracion TEXT, dificultad TEXT, grupo TEXT, intereses TEXT[], created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW());-- Create user routes tableCREATE TABLE IF NOT EXISTS user_routes ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE, user_name TEXT, route_name TEXT, atractivos TEXT[], ticket_url TEXT, share_code TEXT UNIQUE, badges TEXT[], created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW());-- Create user badges tableCREATE TABLE IF NOT EXISTS user_badges ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE, badge_type TEXT NOT NULL, unlocked_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), UNIQUE(user_id, badge_type));-- Create user favorites tableCREATE TABLE IF NOT EXISTS user_favorites ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE, atractivo_slug TEXT NOT NULL, created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), UNIQUE(user_id, atractivo_slug));-- Enable Row Level SecurityALTER TABLE user_profiles ENABLE ROW LEVEL SECURITY;ALTER TABLE user_preferences ENABLE ROW LEVEL SECURITY;ALTER TABLE user_routes ENABLE ROW LEVEL SECURITY;ALTER TABLE user_badges ENABLE ROW LEVEL SECURITY;ALTER TABLE user_favorites ENABLE ROW LEVEL SECURITY;-- RLS Policies for user_profilesCREATE POLICY "Users can view own profile" ON user_profiles FOR SELECT USING (auth.uid() = id);CREATE POLICY "Users can update own profile" ON user_profiles FOR UPDATE USING (auth.uid() = id);CREATE POLICY "Users can insert own profile" ON user_profiles FOR INSERT WITH CHECK (auth.uid() = id);-- RLS Policies for user_preferencesCREATE POLICY "Users can view own preferences" ON user_preferences FOR SELECT USING (auth.uid() = user_id);CREATE POLICY "Users can insert own preferences" ON user_preferences FOR INSERT WITH CHECK (auth.uid() = user_id);CREATE POLICY "Users can update own preferences" ON user_preferences FOR UPDATE USING (auth.uid() = user_id);-- RLS Policies for user_routesCREATE POLICY "Anyone can view routes" ON user_routes FOR SELECT USING (true);CREATE POLICY "Users can insert own routes" ON user_routes FOR INSERT WITH CHECK (auth.uid() = user_id);CREATE POLICY "Users can update own routes" ON user_routes FOR UPDATE USING (auth.uid() = user_id);-- RLS Policies for user_badgesCREATE POLICY "Users can view own badges" ON user_badges FOR SELECT USING (auth.uid() = user_id);CREATE POLICY "Users can insert own badges" ON user_badges FOR INSERT WITH CHECK (auth.uid() = user_id);-- RLS Policies for user_favoritesCREATE POLICY "Users can view own favorites" ON user_favorites FOR SELECT USING (auth.uid() = user_id);CREATE POLICY "Users can insert own favorites" ON user_favorites FOR INSERT WITH CHECK (auth.uid() = user_id);CREATE POLICY "Users can delete own favorites" ON user_favorites FOR DELETE USING (auth.uid() = user_id);-- Create storage bucket for tickets (if not exists)INSERT INTO storage.buckets (id, name, public)VALUES ('tickets', 'tickets', true)ON CONFLICT (id) DO NOTHING;-- Storage policy for ticketsCREATE POLICY "Anyone can view tickets" ON storage.objects FOR SELECT USING (bucket_id = 'tickets');CREATE POLICY "Authenticated users can upload tickets" ON storage.objects FOR INSERT WITH CHECK ( bucket_id = 'tickets' AND auth.role() = 'authenticated' );
Click Run to execute the migration.
3
Configure Storage Bucket
The SQL script creates a tickets bucket. Verify it:
Go to Storage in Supabase
Confirm tickets bucket exists
Ensure it’s set to Public
This bucket stores generated route ticket images
4
Enable Email Authentication
Go to Authentication > Providers
Find Email provider
Toggle Enable Email provider to ON
For development, disable “Confirm email” (optional)
