号码数据分析 · 走势 · 回测工具

1. 在 supabase.com 新建免费项目，等 1~2 分钟初始化完成。
2. 打开左侧 SQL Editor，粘贴下面 SQL 并 Run（可重复执行，不会报错）。
3. 到 Authentication → Sign In / Providers → Email，关闭 “Confirm email”，否则注册后要先去邮箱点确认。
4. 到 Project Settings → API，复制 Project URL 与 anon public key，填到上方并点「保存配置」。
5. 主账号：注册登录 → 点「创建共享群」→ 把生成的邀请码发给别人。
6. 成员：注册登录 → 填邀请码 → 点「加入」 → 同步。

-- 1) 个人数据表（未加入共享群时使用）
create table if not exists public.user_draws (
  user_id uuid primary key references auth.users(id) on delete cascade,
  payload jsonb not null default '{}'::jsonb,
  updated_at timestamptz not null default now()
);
alter table public.user_draws enable row level security;
drop policy if exists "own_select" on public.user_draws;
drop policy if exists "own_insert" on public.user_draws;
drop policy if exists "own_update" on public.user_draws;
create policy "own_select" on public.user_draws for select using (auth.uid() = user_id);
create policy "own_insert" on public.user_draws for insert with check (auth.uid() = user_id);
create policy "own_update" on public.user_draws for update using (auth.uid() = user_id) with check (auth.uid() = user_id);

-- 2) 共享群与成员表
create table if not exists public.shared_groups (
  id text primary key,
  owner_id uuid not null references auth.users(id) on delete cascade,
  payload jsonb not null default '{}'::jsonb,
  updated_at timestamptz not null default now()
);
alter table public.shared_groups enable row level security;

create table if not exists public.group_members (
  group_id text not null references public.shared_groups(id) on delete cascade,
  user_id uuid not null references auth.users(id) on delete cascade,
  role text not null default 'member',
  primary key (group_id, user_id)
);
alter table public.group_members enable row level security;

-- 3) 权限：主账号可写，成员只读
drop policy if exists "group_select" on public.shared_groups;
drop policy if exists "group_insert" on public.shared_groups;
drop policy if exists "group_update" on public.shared_groups;
create policy "group_select" on public.shared_groups for select
  using (owner_id = auth.uid() or exists (
    select 1 from public.group_members m
    where m.group_id = shared_groups.id and m.user_id = auth.uid()));
create policy "group_insert" on public.shared_groups for insert with check (owner_id = auth.uid());
create policy "group_update" on public.shared_groups for update using (owner_id = auth.uid()) with check (owner_id = auth.uid());

drop policy if exists "member_select" on public.group_members;
drop policy if exists "member_owner_all" on public.group_members;
create policy "member_select" on public.group_members for select
  using (user_id = auth.uid() or exists (
    select 1 from public.shared_groups g where g.id = group_id and g.owner_id = auth.uid()));
create policy "member_owner_all" on public.group_members for all
  using (exists (select 1 from public.shared_groups g where g.id = group_id and g.owner_id = auth.uid()))
  with check (exists (select 1 from public.shared_groups g where g.id = group_id and g.owner_id = auth.uid()));

-- 4) 成员凭邀请码加入
create or replace function public.join_shared_group(code text) returns text
language plpgsql security definer set search_path = public as $$
begin
  if not exists (select 1 from public.shared_groups where id = code) then
    raise exception 'GROUP_NOT_FOUND';
  end if;
  insert into public.group_members(group_id,user_id,role)
  values (code, auth.uid(), 'member')
  on conflict (group_id,user_id) do nothing;
  return code;
end $$;