Idempotent (INSERT IGNORE on unique keys) script that populates:
- tStaff: 20 print-industry employees with realistic Chinese names,
staff numbers (S0001..S0020), and varied departments
- tUser: admin + 18 business users, all BCrypt(666666), linked to
staff rows; mix of 超级管理员 / 普通用户, languages zh/en/zh-TW,
with one bDeleted=1 to demo the 作废 column
- tPermissionCategory: 30 groups matching prototype's permission grid
- tUserPermission: department-correlated permission grants
(e.g. 财务部 users get PERM_FINANCE + PERM_VIEW_ORDER_PRICE)
- tModule: 5 KPI flow trees (估价/订单/拼版/送货/采购) + 系统设置,
~30 nodes with proper parent/child relationships
Final SELECT prints row counts for verification.