Predict which products
will blow up next

-- Prodiqt Database Schema create table if not exists public.profiles (id uuid references auth.users on delete cascade primary key, full_name text, plan text default 'starter', alert_threshold int default 80, created_at timestamptz default now()); create table if not exists public.watchlist (id bigserial primary key, user_id uuid references auth.users on delete cascade not null, product_id int not null, product_name text, product_emoji text, viral_score int, created_at timestamptz default now(), unique(user_id, product_id)); create table if not exists public.alerts (id bigserial primary key, user_id uuid references auth.users on delete cascade not null, title text not null, body text, icon text default '🔔', read boolean default false, created_at timestamptz default now()); create table if not exists public.products (id bigserial primary key, name text not null, category text, emoji text default '📦', viral_score int default 0, weekly_growth text, video_count text, source_cost text, sell_price text, margin int default 0, alibaba_url text, ai_summary text, trend_direction text default 'stable', confidence text default 'medium', score_breakdown jsonb, data_source text default 'multi-source', last_updated timestamptz default now(), unique(name, category)); create or replace function public.handle_new_user() returns trigger language plpgsql security definer as $$ begin insert into public.profiles (id, full_name) values (new.id, coalesce(new.raw_user_meta_data->>'full_name', split_part(new.email,'@',1))) on conflict (id) do nothing; return new; end; $$; drop trigger if exists on_auth_user_created on auth.users; create trigger on_auth_user_created after insert on auth.users for each row execute procedure public.handle_new_user(); alter table public.profiles enable row level security; alter table public.watchlist enable row level security; alter table public.alerts enable row level security; alter table public.products enable row level security; create policy "own_profile" on public.profiles for all using (auth.uid()=id) with check (auth.uid()=id); create policy "own_watchlist" on public.watchlist for all using (auth.uid()=user_id) with check (auth.uid()=user_id); create policy "own_alerts" on public.alerts for all using (auth.uid()=user_id) with check (auth.uid()=user_id); create policy "read_products" on public.products for select using (true); create policy "write_products" on public.products for all using (true) with check (true);