STEP 7 - ORDER SYSTEM SETUP
============================

Run this SQL in phpMyAdmin on database: food_delivery

File: database/orders_schema.sql

Tables created:
  - customers         (links users to customer profiles)
  - orders            (main order record)
  - order_items       (items per order)
  - order_item_choices (size/variant choices per item)
  - order_status_log  (full status history)
  - invoices          (invoice numbers)

Also inserts:
  - Test customer: customer@test.com / Customer@123
  - Sample order: ORD-20260619-0001 (status: pending)
    So you can see the live board and order detail immediately.

URLs to test:
  http://localhost:8084/abc/food_delivery/public/orders
  http://localhost:8084/abc/food_delivery/public/orders/live
  http://localhost:8084/abc/food_delivery/public/orders/1
  http://localhost:8084/abc/food_delivery/public/orders/1/invoice
  http://localhost:8084/abc/food_delivery/public/orders/1/kot
