================================================================================
  OKHES FULL SITE — cPanel Upload Package
  Site:    okhes.averycaregroupltd.com
  Folder:  public_html/okhes/
  Database: bgmxghks_okhes  (NEW — separate from bgmxghks_averycrm)
================================================================================

THIS ZIP CONTAINS THE COMPLETE APPLICATION
------------------------------------------
  okhes/config/     app.php, db.php, db.local.php.example, store.php
  okhes/src/        All PHP business logic (15 files)
  okhes/public/     Full web app — login, dashboard, manufacturing, sales, etc.
  okhes/database/   schema_cpanel.sql, seeds, migrations

Unlike the smaller "Manufacturing-v2" patch ZIP, this package has EVERYTHING
needed for a brand-new Okhes install.


STEP 1 — CREATE NEW DATABASE (does not touch old CRM database)
--------------------------------------------------------------
cPanel → MySQL® Databases:
  1. Create database: okhes  →  bgmxghks_okhes
  2. Create user: okhesroot  →  bgmxghks_okhesroot (or reuse a user)
  3. Add user to bgmxghks_okhes with ALL PRIVILEGES


STEP 2 — UPLOAD & EXTRACT
-------------------------
1. File Manager → public_html/
2. Upload this ZIP → Extract
3. Result: public_html/okhes/config/, okhes/public/, okhes/src/, okhes/database/


STEP 3 — CONFIGURE DATABASE CONNECTION
--------------------------------------
1. okhes/config/ → copy db.local.php.example → db.local.php
2. Edit db.local.php:
     DB_NAME = bgmxghks_okhes
     DB_USER = bgmxghks_okhesroot
     DB_PASS = your cPanel MySQL password
3. app.php is already set to APP_BASE_URL = '/okhes/public'


STEP 4 — IMPORT DATABASE (phpMyAdmin)
-------------------------------------
Click bgmxghks_okhes in the LEFT sidebar first, then import IN ORDER:

  1. database/schema_cpanel.sql
  2. database/seed_roles_permissions_cpanel.sql
  3. database/migrate_manufacturing_v2.sql   (starts with USE bgmxghks_okhes;)

Optional extra migrations if needed:
  migrate_settings_tables.sql, migrate_granular_permissions.sql, etc.


STEP 5 — FIRST ADMIN USER
-------------------------
Visit: https://okhes.averycaregroupltd.com/okhes/public/setup.php
Create admin → then DELETE setup.php from the server.


STEP 6 — LOGIN
--------------
https://okhes.averycaregroupltd.com/okhes/public/login.php


OPTIONAL — COPY DATA FROM OLD DATABASE
--------------------------------------
Only if you want existing ingredients/customers from bgmxghks_averycrm:
  Export from old DB → Import into bgmxghks_okhes
  Then run once: .../okhes/public/migrate_okhes_data.php (delete after)


WHAT IS NOT IN THIS PACKAGE (intentionally)
-------------------------------------------
  db.local.php          — you create on server (contains password)
  full_export_for_main_site.sql — live data dump (too large)
  Dev tools: export_local_db.php, check_server.php, etc.

================================================================================