Hi Philip, On May 22, 2008, at 20:17 , Philip M. Gollucci wrote:
| http://www.freebsd.org/cgi/query-pr.cgi?pr=123905 | | The attached patch is required to have the ALTER statements parse as vaild | SQL. I guess this must be a MySQL 5.1 thing since it looks like MySQL | 5.0 is | the primary testing location. It is back-compatible.
If would help more if I updated the generated and sent that --
Cool! :) Many thanks for feedback. One question. Would it also work on your MySQL 5.1 with my $SQL = "ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; $SQL .= "$Param{Local}) REFERENCES "; $SQL .= "$Param{ForeignTableName} ($Param{Foreign})"; (without all "`")? Many thanks for feedback! :) -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann