table varchar fix for cid, more examples finished purchase