I have just learned that “unique” is not a good name for column name when creating table. If you try to use it then you will get following meaningless (at least to me) error:
SQLError: 'Error #3115: SQL Error.', details:'near 'BOOLEAN': syntax error'
So whenever you will have similar error and at first glimpse everything looks fine then check your column IDs.