id column too small, data truncated, cannot be null

[tfk-kaare]

There are a few neglected error messages in the ruter import causing missing and fault data. They are:

• Warning: 1265 Data truncated for column 'product_id' at row 4 (Connection: mysql, SQL: insert into ruter_passengers (chunk_date, count, product_id …)
• String data, right truncated: 1406 Data too long for column 'id' at row 25 (Connection: mysql, SQL: insert into ruter_transactions …)
• Integrity constraint violation: 1048 Column 'ticket_type_id' cannot be null (Connection: mysql, SQL: insert into ruter_transactions …)

DoD

• [x] Fix above DB issues by creating a migration for each
• [x] Changelog entry

[tfk-kaare]

ID columns with more than 256 chars is problematic in mysql. The solution is to create a md5 of it and add the transaction ID as a separate real_id column with type tinytext.