# MCBDL Task Progress

## Task Complete: Fixed db.js CAST(? AS JSON) errors for MariaDB

✅ **Step 1: Create TODO.md** - Done  
✅ **Step 2: Edit backend/src/db.js** - Done (seedFromJsonFileIfAny & seedRoleUsers fixed)  
✅ **Step 3: Verified no more CAST patterns** - Done (search_files: 0 results)  
✅ **Step 4: Task complete** - Done  

**Test command:**  
`cd backend && node cli.js migrate:refresh` (drops tables, remigrates, reseeds)  

DB now MariaDB-compatible. Original + seedRoleUsers blocks replaced with pool.execute + JSON.stringify.