finally fix misunderstandings about MYSQL TIMESTAMP type (ti's not a unix timestamp) and my own design of the transaction type as a type code instead of the text