Modify

Opened 9 years ago

Closed 9 years ago

#3297 closed enhancement (fixed)

MySQL compatibility

Reported by: anderson@… Owned by: Vladislav Naumov
Priority: high Component: TracUnreadPlugin
Severity: major Keywords:
Cc: Trac Release: 0.11

Description

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)

);

Attachments (0)

Change History (2)

comment:1 Changed 9 years ago by anderson@…

Please include this in next releases.

comment:2 Changed 9 years ago by Vladislav Naumov

Resolution: fixed
Status: newclosed
Summary: MySQL compatibilyMySQL compatibility

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.

Modify Ticket

Action
as closed The owner will remain Vladislav Naumov.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.