[fix] added orm mapping annotations to define some fields as clob
instead of varchar(255)
renamed and updated sql scripts