ideas for fixing auto inc and 'bit' data type