updated sql update data with better names and fix for id
added bonus cap define to config