Importing uwu_catcafe.sql sets up everything the resource needs to function. All statements use CREATE TABLE IF NOT EXISTS and INSERT ... ON DUPLICATE KEY UPDATE so the file is safe to re-import.
Tables Created#
| Table | Purpose |
|---|---|
jobs | Registers the uwucafe job entry. |
job_grades | Defines the four staff grades with salaries. |
items | Inserts item definitions (if your server uses a DB-backed items table). |
uwu_store_stock | Persists shop stock levels across server restarts. |
Job Grades#
| Grade | Name | Label | Salary |
|---|---|---|---|
| 0 | trainee | Trainee | $50 |
| 1 | barista | Barista | $75 |
| 2 | manager | Manager | $100 |
| 3 | boss | Owner | $150 |
Store Stock#
Shop stock levels are stored in the uwu_store_stock table and loaded into memory when the resource starts. Stock decreases as players purchase items and increases when staff trigger a warehouse delivery. Changes are written back to the database automatically.
Initial stock values set by the SQL file:
| Item | Starting stock |
|---|---|
uwu_milk_tea | 500 |
uwu_cat_cookie | 500 |
uwu_mochi_icecream | 500 |
uwu_cat_bento | 500 |
uwu_cake_slice | 500 |
uwu_frappe | 500 |
uwu_sandwich | 500 |
uwu_pancake_stack | 500 |
uwu_ramen_bowl | 500 |
uwu_macaron_box | 500 |
uwu_garden_salad | 500 |
uwu_valentine_cookie | 500 |
If you already have an items table and jobs/job_grades tables populated from another framework import, review the SQL before running it. Skip or merge the sections that would conflict with existing rows.
MySQL Compatibility#
The resource supports both oxmysql and ghmattimysql for database operations. If neither is detected, stock persistence is disabled and an in-memory fallback is used — stock will reset on every restart.