Hi Philip,
On May 22, 2008, at 20:17 , Philip M. Gollucci wrote:
| http://www.freebsd.org/cgi/query-pr.cgi?pr3905
|
| 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
_______________________________________________
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
