Hero Section

Edit the main headline and subtitle text (bilingual).

Ticker Bar

Edit the scrolling ticker bar messages.

Homepage Stats

These numbers appear in the hero section and the stats banner.

Supabase Connection

Enter your Supabase project URL and anon key from your project dashboard at supabase.com.

Required Database Tables

Your Supabase project needs these tables. Copy and run this SQL in your Supabase SQL editor:

-- Members table
CREATE TABLE members (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  company_name TEXT NOT NULL,
  contact_email TEXT,
  tier TEXT CHECK (tier IN ('startup','scaleup','investor','enthusiast')),
  status TEXT DEFAULT 'pending',
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Events table
CREATE TABLE events (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  title_mn TEXT NOT NULL,
  title_en TEXT NOT NULL,
  description_mn TEXT,
  description_en TEXT,
  event_date DATE,
  location TEXT,
  event_type TEXT,
  status TEXT DEFAULT 'active',
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Blog posts table
CREATE TABLE posts (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  title_mn TEXT NOT NULL,
  title_en TEXT NOT NULL,
  body_mn TEXT,
  body_en TEXT,
  category TEXT,
  tags TEXT[],
  status TEXT DEFAULT 'draft',
  published_at TIMESTAMPTZ,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Partners table
CREATE TABLE partners (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  name TEXT NOT NULL,
  category TEXT,
  website TEXT,
  logo_url TEXT,
  status TEXT DEFAULT 'active'
);

-- Testimonials table
CREATE TABLE testimonials (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  author_name TEXT NOT NULL,
  author_role TEXT,
  company TEXT,
  quote_mn TEXT,
  quote_en TEXT,
  status TEXT DEFAULT 'active'
);

-- Newsletter subscribers
CREATE TABLE newsletter_subscribers (
  id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  source TEXT DEFAULT 'website',
  subscribed_at TIMESTAMPTZ DEFAULT NOW(),
  active BOOLEAN DEFAULT true
);

-- Site settings (key-value)
CREATE TABLE site_settings (
  key TEXT PRIMARY KEY,
  value_mn TEXT,
  value_en TEXT,
  updated_at TIMESTAMPTZ DEFAULT NOW()
);

Cloudflare Deployment

For deploying to Cloudflare Pages, set these environment variables in your Pages project dashboard:

VITE_SUPABASE_URL=https://your-project.supabase.co
VITE_SUPABASE_ANON_KEY=your-anon-key-here

Deploy by connecting your GitHub repo to Cloudflare Pages. The admin panel uses Supabase Auth — set up an admin user in your Supabase Auth dashboard.