adding bit column, integer constraint, other text types, other fixes
re-doccco