Apon SEC-OS

Run this SQL in your Neon SQL Editor to create the tables for your dynamic portfolio and leads:

-- 1. Table for Dynamic Portfolio Content & Themes
CREATE TABLE IF NOT EXISTS apon_portfolio_cms (
  id VARCHAR(64) PRIMARY KEY,
  content JSONB NOT NULL,
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- 2. Table for Client Inquiries & Recruiter Leads
CREATE TABLE IF NOT EXISTS apon_client_leads (
  id VARCHAR(64) PRIMARY KEY,
  client_name VARCHAR(255) NOT NULL,
  work_email VARCHAR(255) NOT NULL,
  phone VARCHAR(100),
  role_scope VARCHAR(255),
  budget VARCHAR(100),
  project_specs TEXT,
  lead_status VARCHAR(50) DEFAULT 'new',
  internal_notes TEXT,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

-- 3. Initial Indexing
CREATE INDEX IF NOT EXISTS idx_leads_created ON apon_client_leads(created_at DESC);

💾 Export Portfolio & Leads Backup

Download a complete snapshot of your projects, skills, profile, and customer inquiries as a JSON backup file.

📂 Import Backup File

Restore your portfolio and inquiries from a previously saved JSON file.

⚠️ Revert to CV Defaults

Reset all portfolio configurations back to Md Al Ashikul Bari (Apon)'s original resume baseline.