然后接下来两个添加URL的部分都要填写，假设，我购买的域名是happyship.org

那第一个就填写https://happyship.org

第二个 填写：https://happyship.org/api/auth/callback/google

注：大家填写的时候，就直接复制我这个，然后把happyship.org替换成你的域名就好，这一步很重要，不要配置错了

AI导航站专用 SQL 配置：

-- 1. 创建用户表 (支持GitHub和Google登录)
CREATE TABLE IF NOT EXISTS public.users (
  id VARCHAR(255) PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  name VARCHAR(255),
  avatar_url TEXT,
  provider VARCHAR(20) NOT NULL, -- 'github' | 'google'
  provider_id VARCHAR(255) NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  total_submissions INTEGER DEFAULT 0
);

-- 2. 创建核心工具表 (包含所有必要字段)
CREATE TABLE IF NOT EXISTS public.web_navigation (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  title VARCHAR(255),
  url VARCHAR(500),
  content TEXT,
  detail TEXT,
  category_name VARCHAR(100),
  thumbnail_url TEXT,
  image_url TEXT,
  collection_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  star_rating INTEGER DEFAULT 0,
  tag_name TEXT,
  website_data JSONB DEFAULT '{}',
  
  -- 用户和支付相关字段
  user_id VARCHAR(255),
  payment_status VARCHAR(20) DEFAULT 'unpaid', -- 'unpaid' | 'basic' | 'pro'
  payment_id VARCHAR(255),
  payment_time TIMESTAMP WITH TIME ZONE,
  featured BOOLEAN DEFAULT FALSE,
  submit_status VARCHAR(20) DEFAULT 'draft' -- 'draft' | 'pending' | 'published' | 'rejected'
);

-- 3. 创建支付记录表 (专用于Stripe支付)
CREATE TABLE IF NOT EXISTS public.payments (
  id SERIAL PRIMARY KEY,
  tool_id INTEGER REFERENCES public.web_navigation(id),
  user_id VARCHAR(255) REFERENCES public.users(id),
  plan_type VARCHAR(20) NOT NULL, -- 'basic' | 'pro'
  amount DECIMAL(10, 2) NOT NULL,
  currency VARCHAR(3) DEFAULT 'USD',
  stripe_payment_intent_id VARCHAR(255) NOT NULL, -- Stripe PaymentIntent ID
  stripe_session_id VARCHAR(255), -- Stripe Checkout Session ID
  status VARCHAR(20) DEFAULT 'pending', -- 'pending' | 'completed' | 'failed' | 'refunded'
  created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  stripe_metadata JSONB DEFAULT '{}' -- 存储Stripe相关的额外信息
);

-- 4. 创建分类表 (保持现有结构)
CREATE TABLE IF NOT EXISTS public.navigation_category (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  title VARCHAR(255),
  sort INTEGER,
  create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  create_by INTEGER,
  del_flag INTEGER DEFAULT 0
);

-- 创建标签表
CREATE TABLE IF NOT EXISTS public.tags (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- 添加索引
CREATE INDEX IF NOT EXISTS idx_tags_name ON public.tags(name);

-- 插入现有的标签数据
INSERT INTO public.tags (name) VALUES
('Text Generation'),
('Image Generation'),
('Video Generation'),
('Audio Generation'),
('Music Creation'),
('Speech to Text'),
('Text to Speech'),
('Chatbot'),
('Virtual Assistant'),
('Copywriting'),
('Content Creation'),
('Social Media'),
('Cold Emails'),
('Marketing'),
('SEO'),
('Advertising'),
('Conversion'),
('CRM'),
('Communication'),
('Community'),
('Productivity'),
('Automation'),
('Low-Code'),
('No-Code'),
('Code Generation'),
('API Integration'),
('Data Analysis'),
('Data Visualization'),
('Machine Learning'),
('Summarization'),
('Translation'),
('Education'),
('E-Learning'),
('Healthcare'),
('Finance'),
('Legal'),
('HR'),
('Recruitment'),
('Customer Support'),
('E-commerce'),
('Gaming'),
('Design'),
('Graphic Design'),
('Video Editing'),
('Animation'),
('3D Modeling'),
('Security'),
('Cryptography'),
('Research'),
('Knowledge Base')
ON CONFLICT (name) DO NOTHING;

-- 添加更新时间触发器
CREATE TRIGGER update_tags_updated_at BEFORE UPDATE ON public.tags 
    FOR EACH ROW EXECUTE FUNCTION update_updated_at_column();

-- 添加索引以提升查询性能

-- web_navigation 表索引
CREATE INDEX IF NOT EXISTS idx_web_navigation_user_id ON public.web_navigation(user_id);
CREATE INDEX IF NOT EXISTS idx_web_navigation_payment_status ON public.web_navigation(payment_status);
CREATE INDEX IF NOT EXISTS idx_web_navigation_featured ON public.web_navigation(featured);
CREATE INDEX IF NOT EXISTS idx_web_navigation_submit_status ON public.web_navigation(submit_status);
CREATE INDEX IF NOT EXISTS idx_web_navigation_category_name ON public.web_navigation(category_name);
CREATE INDEX IF NOT EXISTS idx_web_navigation_collection_time ON public.web_navigation(collection_time);

-- users 表索引
CREATE INDEX IF NOT EXISTS idx_users_email ON public.users(email);
CREATE INDEX IF NOT EXISTS idx_users_provider ON public.users(provider);
CREATE INDEX IF NOT EXISTS idx_users_provider_id ON public.users(provider_id);

-- payments 表索引
CREATE INDEX IF NOT EXISTS idx_payments_user_id ON public.payments(user_id);
CREATE INDEX IF NOT EXISTS idx_payments_tool_id ON public.payments(tool_id);
CREATE INDEX IF NOT EXISTS idx_payments_status ON public.payments(status);
CREATE INDEX IF NOT EXISTS idx_payments_stripe_payment_intent_id ON public.payments(stripe_payment_intent_id);
CREATE INDEX IF NOT EXISTS idx_payments_created_at ON public.payments(created_at);

-- 添加更新时间触发器
CREATE OR REPLACE FUNCTION update_updated_at_column()
RETURNS TRIGGER AS $$
BEGIN
    NEW.updated_at = CURRENT_TIMESTAMP;
    RETURN NEW;
END;
$$ language 'plpgsql';

-- 为需要的表添加触发器
CREATE TRIGGER update_users_updated_at BEFORE UPDATE ON public.users 
    FOR EACH ROW EXECUTE FUNCTION update_updated_at_column();

CREATE TRIGGER update_payments_updated_at BEFORE UPDATE ON public.payments 
    FOR EACH ROW EXECUTE FUNCTION update_updated_at_column();

重要配置说明：

• • Cloudflare R2 Access Key ID对应的就是"访问密钥 ID"
• • Cloudflare R2 Secret Access Key对应的就是"机密访问密钥"
• • Cloudflare R2 Endpoint对应的就是"为 S3 客户端使用管辖权地特定的终结点"

直接复制到HappyShip对应位置就好

举个例子，我的域名是happyship.org，那这里就要填

大家实际做的时候，只需要把我这个复制，然后把域名替换就好，好了之后点击Create，就大功告成了