Get Panalo.ai live in under 2 hours

Browser / Frontend HTML files
         │
         ▼
  Express API (Railway)          ← Your backend
         │
    ┌────┴────────────────────┐
    │                         │
Supabase DB            Anthropic API
(PostgreSQL)         (Claude Sonnet 4.6)
    │                         │
    └────────┐   ┌────────────┘
             │   │
          Bull Queue (Redis)    ← Async task processing
             │
        Email (Resend)  ←  Notifications
             │
         Stripe          ←  Billing webhooks

# Navigate to the backend folder
cd panalo-backend

# Initialize git
git init
git add .
git commit -m "Initial Panalo.ai backend"

# Create a new repo on github.com, then:
git remote add origin https://github.com/YOUR_USERNAME/panalo-backend.git
git branch -M main
git push -u origin main

cd panalo-backend
npm install

cp .env.example .env

npm run dev

# You should see:
# 🚀 Panalo.ai backend running { port: 3001, env: 'development' }

-- Enable UUID extension
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

-- USERS
CREATE TABLE IF NOT EXISTS users (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  email TEXT UNIQUE NOT NULL, password_hash TEXT NOT NULL,
  first_name TEXT NOT NULL, last_name TEXT NOT NULL,
  company TEXT, role TEXT NOT NULL DEFAULT 'client',
  plan TEXT NOT NULL DEFAULT 'starter',
  subscription_status TEXT DEFAULT 'trialing',
  stripe_customer_id TEXT UNIQUE, stripe_subscription_id TEXT UNIQUE,
  subscription_renews_at TIMESTAMPTZ, task_count INTEGER DEFAULT 0,
  token_version INTEGER DEFAULT 0, last_login TIMESTAMPTZ,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- AGENTS
CREATE TABLE IF NOT EXISTS agents (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  user_id UUID REFERENCES users(id) ON DELETE SET NULL,
  name TEXT NOT NULL, email TEXT UNIQUE NOT NULL,
  location TEXT DEFAULT 'Manila, PH', avatar_url TEXT,
  role TEXT DEFAULT 'agent', status TEXT DEFAULT 'offline',
  current_tasks INTEGER DEFAULT 0, completed_today INTEGER DEFAULT 0,
  avg_handle_time_minutes INTEGER DEFAULT 8, csat_score NUMERIC(3,2) DEFAULT 5.0,
  shift_start TIME, shift_end TIME,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- TASKS
CREATE TABLE IF NOT EXISTS tasks (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
  agent_id UUID REFERENCES agents(id) ON DELETE SET NULL,
  title TEXT NOT NULL, description TEXT,
  type TEXT DEFAULT 'other', complexity TEXT, priority TEXT DEFAULT 'normal',
  status TEXT DEFAULT 'pending', handler TEXT, tags TEXT[] DEFAULT '{}',
  due_date TIMESTAMPTZ, estimated_minutes INTEGER, ai_note TEXT,
  completed_at TIMESTAMPTZ,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX IF NOT EXISTS idx_tasks_user_id ON tasks(user_id);
CREATE INDEX IF NOT EXISTS idx_tasks_status ON tasks(status);
CREATE INDEX IF NOT EXISTS idx_tasks_created_at ON tasks(created_at DESC);

-- TASK RESULTS
CREATE TABLE IF NOT EXISTS task_results (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  task_id UUID NOT NULL REFERENCES tasks(id) ON DELETE CASCADE,
  output TEXT NOT NULL, confidence INTEGER, steps_taken TEXT[],
  handler TEXT, agent_id UUID REFERENCES agents(id) ON DELETE SET NULL,
  rated INTEGER, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- MESSAGES
CREATE TABLE IF NOT EXISTS messages (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  task_id UUID NOT NULL REFERENCES tasks(id) ON DELETE CASCADE,
  sender_id UUID REFERENCES users(id) ON DELETE SET NULL,
  sender_type TEXT NOT NULL, sender_name TEXT, body TEXT NOT NULL,
  read_at TIMESTAMPTZ, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX IF NOT EXISTS idx_messages_task_id ON messages(task_id);

-- INVOICES
CREATE TABLE IF NOT EXISTS invoices (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
  stripe_id TEXT UNIQUE, amount NUMERIC(10,2), currency TEXT DEFAULT 'usd',
  status TEXT DEFAULT 'paid', pdf_url TEXT,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- PASSWORD RESET TOKENS
CREATE TABLE IF NOT EXISTS password_reset_tokens (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
  token TEXT UNIQUE NOT NULL, expires_at TIMESTAMPTZ NOT NULL,
  used BOOLEAN DEFAULT FALSE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

-- HELPER FUNCTIONS
CREATE OR REPLACE FUNCTION increment_agent_tasks(agent_id UUID)
RETURNS void LANGUAGE sql AS $$
  UPDATE agents SET current_tasks = current_tasks + 1, updated_at = NOW() WHERE id = agent_id;
$$;

CREATE OR REPLACE FUNCTION decrement_agent_tasks(agent_id UUID)
RETURNS void LANGUAGE sql AS $$
  UPDATE agents
  SET current_tasks = GREATEST(0, current_tasks - 1),
      completed_today = completed_today + 1, updated_at = NOW()
  WHERE id = agent_id;
$$;

npm run seed

# Output:
# ✅ Admin user: admin@panalo.ai / admin123!
# ✅ Test client: sarah@buildco.com / client123!
# ✅ 5 agents seeded
# ✅ 4 sample tasks seeded

// At the top of your <script> block in each HTML file:
const API_BASE = 'https://YOUR-RAILWAY-URL.up.railway.app/api';

// Replace all direct data with real API calls. Example:
async function loadTasks() {
  const token = localStorage.getItem('panalo_token');
  const res = await fetch(`${API_BASE}/tasks`, {
    headers: { 'Authorization': `Bearer ${token}` }
  });
  const { tasks } = await res.json();
  renderTaskList(tasks);
}

// Auth example:
async function doLogin(email, password) {
  const res = await fetch(`${API_BASE}/auth/login`, {
    method: 'POST',
    headers: { 'Content-Type': 'application/json' },
    body: JSON.stringify({ email, password })
  });
  const { accessToken, refreshToken, user } = await res.json();
  localStorage.setItem('panalo_token', accessToken);
  localStorage.setItem('panalo_refresh', refreshToken);
  return user;
}

curl -X POST https://YOUR-URL.up.railway.app/api/auth/register \
  -H "Content-Type: application/json" \
  -d '{
    "email": "test@yourcompany.com",
    "password": "TestPass123!",
    "first_name": "Test",
    "last_name": "User",
    "plan": "pro"
  }'

curl -X POST https://YOUR-URL.up.railway.app/api/tasks \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  -d '{
    "title": "Research top 3 CRM tools for a 20-person sales team",
    "description": "Need pricing, key features, and pros/cons for HubSpot, Salesforce, and Pipedrive",
    "priority": "normal"
  }'

curl https://YOUR-URL.up.railway.app/api/tasks/TASK_ID \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN"

# Install Railway CLI
npm install -g @railway/cli

# Login and view logs
railway login
railway logs