MySQL compatibility

[anderson@…]

The creation of the fields must be diffent for MySQL db. To put the fields on the primary key they must have a limitation. So, they can´t be TEXT fields. I have used smaller sizes for the fields because the index key can´t be longer than 1024 bytes. you can increase it if you want but i must not pass 1024 bytes (remember that the db is in utf8_general collation)

This lines on env_setup.py file were modified to work with mysql:

CREATE TABLE trac_unread (

username varchar(50), last_read_on integer, type varchar(50), id varchar(20), UNIQUE (type, id, username)

);

[anderson@…]

Please include this in next releases.

[Vladislav Naumov]

Issue must be fixed in rev3935.

SQL generation code is used now (the same one that Trac uses internally), so all current and future backends should work.

Please test, if possible and re-open this ticket if there are any issues unresolved.