-- Run this SQL in your Supabase SQL Editor: create table public.profiles ( id uuid references auth.users on delete cascade primary key, display_name text not null default 'MySpace User', tagline text default 'Chillin on MySpace ✌️', about_me text default 'Hey there! I''m on MySpace!', mood text default 'happy', song_title text default 'My Chemical Romance - Welcome to the Black Parade', interests text default 'music, friends, hanging out', location_city text default '', age integer, relationship_status text default 'Single', here_for text default 'Friends, Dating, Networking', profile_views integer default 0, avatar_emoji text default '😎', bg_color text default '#fffef0', created_at timestamp with time zone default timezone(''utc''::text, now()) ); create table public.comments ( id uuid default gen_random_uuid() primary key, profile_id uuid references public.profiles(id) on delete cascade, author_id uuid references public.profiles(id) on delete cascade, content text not null, created_at timestamp with time zone default timezone(''utc''::text, now()) ); create table public.friends ( id uuid default gen_random_uuid() primary key, user_id uuid references public.profiles(id) on delete cascade, friend_id uuid references public.profiles(id) on delete cascade, status text default 'pending', created_at timestamp with time zone default timezone(''utc''::text, now()), unique(user_id, friend_id) ); create table public.blog_posts ( id uuid default gen_random_uuid() primary key, author_id uuid references public.profiles(id) on delete cascade, title text not null, content text not null, created_at timestamp with time zone default timezone(''utc''::text, now()) ); -- Enable RLS alter table public.profiles enable row level security; alter table public.comments enable row level security; alter table public.friends enable row level security; alter table public.blog_posts enable row level security; -- RLS Policies create policy "Public profiles are viewable by everyone" on public.profiles for select using (true); create policy "Users can insert their own profile" on public.profiles for insert with check (auth.uid() = id); create policy "Users can update their own profile" on public.profiles for update using (auth.uid() = id); create policy "Comments are viewable by everyone" on public.comments for select using (true); create policy "Auth users can insert comments" on public.comments for insert with check (auth.uid() = author_id); create policy "Users can delete their own comments" on public.comments for delete using (auth.uid() = author_id); create policy "Friends are viewable by everyone" on public.friends for select using (true); create policy "Auth users can manage friendships" on public.friends for insert with check (auth.uid() = user_id); create policy "Auth users can update friendships" on public.friends for update using (auth.uid() = user_id or auth.uid() = friend_id); create policy "Blog posts viewable by everyone" on public.blog_posts for select using (true); create policy "Auth users can write posts" on public.blog_posts for insert with check (auth.uid() = author_id); create policy "Users can delete own posts" on public.blog_posts for delete using (auth.uid() = author_id);

⚙️ Configure Supabase

Welcome, Guest! | Home | Browse | Search | ⭐ NEW: Tom added you as a friend!

Sign In | Sign Up! My Profile | Edit Profile | Sign Out

MySpace a place for friends

Search