SQLite type affinity and limited support for altering table means that hibernate.hbm2ddl.auto cannot be set to modify nor create (I seem to recall that FK constraints are added after tables).
And when hibernate.hbm2ddl.auto is set to validate, Hibernate don't know that 'float', 'double', 'real' means the same thing for SQLite.
Also, there is no date/time datatype (See Time Strings). So a date can be stored in a column declared with text or float or integer or numeric affinity.