CREATE TABLE public.profiles (
  id uuid NOT NULL PRIMARY KEY, -- Khóa chính, trùng với auth.users.id
  email text,
  created_at timestamptz DEFAULT now(),
  updated_at timestamptz DEFAULT now()
);

ALTER TABLE public.profiles
  ADD CONSTRAINT fk_auth_users FOREIGN KEY (id) REFERENCES auth.users(id) ON DELETE CASCADE;

ALTER TABLE public.profiles ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Allow authenticated users insert own profile"
ON public.profiles
FOR INSERT
TO authenticated
WITH CHECK (auth.uid() = id);

CREATE POLICY "Allow authenticated users update own profile"
ON public.profiles
FOR UPDATE
TO authenticated
USING (auth.uid() = id)
WITH CHECK (auth.uid() = id);

import { createClient } from '@supabase/supabase-js';

const supabaseUrl = 'YOUR_SUPABASE_URL';
const supabaseKey = 'YOUR_SUPABASE_KEY';
const supabase = createClient(supabaseUrl, supabaseKey);

async function insertProfile(profile) {
  const { data, error } = await supabase
    .from('profiles')
    .insert(profile)
    .select();

  if (error) {
    console.error('Error inserting profile:', error);
    return null;
  }
  return data;
}

// Ví dụ sử dụng
const newProfile = {
  id: 'user-456',
  username: 'janedoe',
  full_name: 'Jane Doe',
  avatar_url: 'https://example.com/jane-avatar.png',
};

insertProfile(newProfile);