fix drop index for mysql
some more unit tests
datatype shorthandler