Remix tecno-brega-stack setup

tecno-brega-stack-setup.sql

-- Create a table for Public Profiles
create table profiles (
  id uuid references auth.users not null,
  updated_at timestamp with time zone,
  username text unique,
  avatar_url text,
  website text,

  primary key (id),
  unique(username),
  constraint username_length check (char_length(username) >= 3)
);

alter table profiles
  enable row level security;

create policy "Public profiles are viewable by everyone." on profiles
  for select using (true);

create policy "Users can insert their own profile." on profiles
  for insert with check (auth.uid() = id);

create policy "Users can update own profile." on profiles
  for update using (auth.uid() = id);

-- Set up Realtime!
begin;
  drop publication if exists supabase_realtime;
  create publication supabase_realtime;
commit;
alter publication supabase_realtime
  add table profiles;

-- Set up Storage!
insert into storage.buckets (id, name)
  values ('avatars', 'avatars');

create policy "Avatar images are publicly accessible." on storage.objects
  for select using (bucket_id = 'avatars');

create policy "Anyone can upload an avatar." on storage.objects
  for insert with check (bucket_id = 'avatars');

create policy "Anyone can update an avatar." on storage.objects
  for update with check (bucket_id = 'avatars');
  
  
-- Create a table for Notes
create table notes (
  id uuid default uuid_generate_v4() primary key,
  created_at timestamp default now(),
  content text,
  user_id uuid default uid(),
  
  primary key (id),
  constraint fk_user_id foreign key(user_id) references users(id)
);

create policy "Enable access only to notes owner"
on notes
for select using (uid() = user_id);

create policy "Enable insert for authenticated users only"
on notes
for insert with check (
  role() = 'authenticated'::text
);

create policy "Enable update for users based on user_id"
on notes
for update using (uid() = user_id) with check (uid() = user_id);

create policy "Enable delete for users based on user_id"
on notes
for delete using (
  auth.uid() = user_id
);