updated recognition
fixed schema generator(#191)
fixed order of generated SQL constraints