
Hello Martin and Philip, If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords: it's not only reserved characters, but everything that could have a meaning somewhere. BTW, considering that there are already table names with underscores (which is a special character...), you are pretty much obliged to keep them. Additionally readability gets better. On the other I do appreciate the difficulties in handling string delimiters in code :-/. BTW, just fyi: the (wrong) syntax was working so far because the foreign key part was simply ignored by MySQL for MyISAM tables (and the statements produced plain indexes). If you switched to a foreign key aware engine (e.g. like InnoDB), MySQL (5.0) complained. Maybe 5.1 got a little more picky on the syntax... Regards, Gilles Martin Edenhofer wrote:
Hi Philip,
I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and higher. :)
-> http://bugs.otrs.org/show_bug.cgi?id=2882
Both, .sql and .pm file.