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.
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
