-
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.
