Vercel教程：免费部署你的网站项目

NEXT_PUBLIC_SUPABASE_URL=your-supabase-project-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=public-anon-key
SUPABASE_SERVICE_ROLE_KEY=service-role-key

pnpm install

-- Enable UUID generation utilities
create extension if not exists "pgcrypto";

-- Pricing plans master data
create table if not exists pricing_plans (
  id uuid primary key default gen_random_uuid(),
  slug text not null unique,
  name text not null,
  description text,
  monthly_price numeric(10,2) not null,
  annual_price numeric(10,2) not null,
  currency_code text not null default 'USD',
  features text[] not null default '{}'::text[],
  feature_heading text not null default 'Get started today:',
  cta_label text not null,
  cta_href text,
  highlight boolean not null default false,
  badge_label text,
  button_tone text not null default 'neutral',
  sort_order integer not null default 0,
  created_at timestamptz not null default now(),
  updated_at timestamptz not null default now()
);

create index if not exists pricing_plans_sort_order_idx on pricing_plans(sort_order);

create or replace function pricing_plans_set_updated_at()
returns trigger as $$
begin
  new.updated_at = now();
  return new;
end;
$$ language plpgsql;

drop trigger if exists pricing_plans_set_updated_at on pricing_plans;
create trigger pricing_plans_set_updated_at
before update on pricing_plans
for each row
execute function pricing_plans_set_updated_at();

insert into pricing_plans (
  slug,
  name,
  description,
  monthly_price,
  annual_price,
  currency_code,
  features,
  feature_heading,
  cta_label,
  cta_href,
  highlight,
  badge_label,
  button_tone,
  sort_order
) values
  (
    'free',
    'Free',
    'Perfect for individuals starting their journey.',
    0,
    0,
    'USD',
    ARRAY[
      'Real-time code suggestions',
      'Basic integration logos',
      'Single MCP server connection',
      'Up to 2 AI coding agents',
      'Vercel deployments with Pointer branding'
    ]::text[],
    'Get started today:',
    'Get Started',
    '/auth?view=signup',
    false,
    null,
    'neutral',
    1
  ),
  (
    'pro',
    'Pro',
    'Ideal for professionals.',
    20,
    16,
    'USD',
    ARRAY[
      'Enhanced real-time previews',
      'Unlimited integrations with custom logos',
      'Multiple MCP server connections',
      'Up to 10 concurrent AI coding agents',
      'Collaborative coding with team chat',
      'Advanced version control integrations',
      'Priority email and chat support'
    ]::text[],
    'Everything in Free +',
    'Join now',
    '/auth?view=signup',
    true,
    'Popular',
    'inverted',
    2
  ),
  (
    'ultra',
    'Ultra',
    'Tailored solutions for teams.',
    200,
    160,
    'USD',
    ARRAY[
      'Dedicated account support',
      'Unlimited MCP server clusters',
      'Unlimited AI coding agents',
      'Enterprise-grade security and compliance',
      'Priority deployments and SLA guarantees'
    ]::text[],
    'Everything in Pro +',
    'Talk to Sales',
    'mailto:sales@example.com',
    false,
    null,
    'secondary',
    3
  )
on conflict (slug) do update set
  name = excluded.name,
  description = excluded.description,
  monthly_price = excluded.monthly_price,
  annual_price = excluded.annual_price,
  currency_code = excluded.currency_code,
  features = excluded.features,
  feature_heading = excluded.feature_heading,
  cta_label = excluded.cta_label,
  cta_href = excluded.cta_href,
  highlight = excluded.highlight,
  badge_label = excluded.badge_label,
  button_tone = excluded.button_tone,
  sort_order = excluded.sort_order,
  updated_at = now();

NEXT_PUBLIC_SUPABASE_URL=your-supabase-project-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=public-anon-key
SUPABASE_SERVICE_ROLE_KEY=service-role-key

pnpm run dev